ssdb_state_county_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_state_county_cdc
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| sourceeventtime | The timestamp of the change event from the source system (e.g., Debezium's ts_ms field). | NULLABLE | INTEGER | |
| sourceeventdate | The UTC date of the change event, derived from sourceeventtime. | NULLABLE | DATE | |
| operation | The type of operation that caused the change event (e.g., 'c' for create/insert, 'u' for update, 'd' for delete, 'r' for read). This corresponds to Debezium's 'op' field. | NULLABLE | STRING | |
| statecountykey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| state | NULLABLE | STRING | ||
| county_1 | NULLABLE | STRING | ||
| county_2 | NULLABLE | STRING | ||
| county_3 | NULLABLE | STRING | ||
| county_4 | NULLABLE | STRING | ||
| county_5 | NULLABLE | STRING | ||
| county_6 | NULLABLE | STRING | ||
| county_7 | NULLABLE | STRING | ||
| county_8 | NULLABLE | STRING | ||
| county_9 | NULLABLE | STRING | ||
| county_10 | NULLABLE | STRING | ||
| county_11 | NULLABLE | STRING | ||
| county_12 | NULLABLE | STRING | ||
| county_13 | NULLABLE | STRING | ||
| county_14 | NULLABLE | STRING | ||
| county_15 | NULLABLE | STRING | ||
| county_16 | NULLABLE | STRING | ||
| county_17 | NULLABLE | STRING | ||
| county_18 | NULLABLE | STRING | ||
| county_19 | NULLABLE | STRING | ||
| county_20 | NULLABLE | STRING | ||
| county_21 | NULLABLE | STRING | ||
| county_22 | NULLABLE | STRING | ||
| county_23 | NULLABLE | STRING | ||
| county_24 | NULLABLE | STRING | ||
| county_25 | NULLABLE | STRING | ||
| county_26 | NULLABLE | STRING | ||
| county_27 | NULLABLE | STRING | ||
| county_28 | NULLABLE | STRING | ||
| county_29 | NULLABLE | STRING | ||
| county_30 | NULLABLE | STRING | ||
| county_31 | NULLABLE | STRING | ||
| county_32 | NULLABLE | STRING | ||
| county_33 | NULLABLE | STRING | ||
| county_34 | NULLABLE | STRING | ||
| county_35 | NULLABLE | STRING | ||
| county_36 | NULLABLE | STRING | ||
| county_37 | NULLABLE | STRING | ||
| county_38 | NULLABLE | STRING | ||
| county_39 | NULLABLE | STRING | ||
| county_40 | NULLABLE | STRING | ||
| county_41 | NULLABLE | STRING | ||
| county_42 | NULLABLE | STRING | ||
| county_43 | NULLABLE | STRING | ||
| county_44 | NULLABLE | STRING | ||
| county_45 | NULLABLE | STRING | ||
| county_46 | NULLABLE | STRING | ||
| county_47 | NULLABLE | STRING | ||
| county_48 | NULLABLE | STRING | ||
| county_49 | NULLABLE | STRING | ||
| county_50 | NULLABLE | STRING | ||
| county_51 | NULLABLE | STRING | ||
| county_52 | NULLABLE | STRING | ||
| county_53 | NULLABLE | STRING | ||
| county_54 | NULLABLE | STRING | ||
| county_55 | NULLABLE | STRING | ||
| county_56 | NULLABLE | STRING | ||
| county_57 | NULLABLE | STRING | ||
| county_58 | NULLABLE | STRING | ||
| county_59 | NULLABLE | STRING | ||
| county_60 | NULLABLE | STRING | ||
| county_61 | NULLABLE | STRING | ||
| county_62 | NULLABLE | STRING | ||
| county_63 | NULLABLE | STRING | ||
| county_64 | NULLABLE | STRING | ||
| county_65 | NULLABLE | STRING | ||
| county_66 | NULLABLE | STRING | ||
| county_67 | NULLABLE | STRING | ||
| county_68 | NULLABLE | STRING | ||
| county_69 | NULLABLE | STRING | ||
| county_70 | NULLABLE | STRING | ||
| county_71 | NULLABLE | STRING | ||
| county_72 | NULLABLE | STRING | ||
| county_73 | NULLABLE | STRING | ||
| county_74 | NULLABLE | STRING | ||
| county_75 | NULLABLE | STRING | ||
| county_76 | NULLABLE | STRING | ||
| county_77 | NULLABLE | STRING | ||
| county_78 | NULLABLE | STRING | ||
| county_79 | NULLABLE | STRING | ||
| county_80 | NULLABLE | STRING | ||
| county_81 | NULLABLE | STRING | ||
| county_82 | NULLABLE | STRING | ||
| county_83 | NULLABLE | STRING | ||
| county_84 | NULLABLE | STRING | ||
| county_85 | NULLABLE | STRING | ||
| county_86 | NULLABLE | STRING | ||
| county_87 | NULLABLE | STRING | ||
| county_88 | NULLABLE | STRING | ||
| county_89 | NULLABLE | STRING | ||
| county_90 | NULLABLE | STRING | ||
| county_91 | NULLABLE | STRING | ||
| county_92 | NULLABLE | STRING | ||
| county_93 | NULLABLE | STRING | ||
| county_94 | NULLABLE | STRING | ||
| county_95 | NULLABLE | STRING | ||
| county_96 | NULLABLE | STRING | ||
| county_97 | NULLABLE | STRING | ||
| county_98 | NULLABLE | STRING | ||
| county_99 | NULLABLE | STRING | ||
| county_100 | NULLABLE | STRING | ||
| county_101 | NULLABLE | STRING | ||
| county_102 | NULLABLE | STRING | ||
| county_103 | NULLABLE | STRING | ||
| county_104 | NULLABLE | STRING | ||
| county_105 | NULLABLE | STRING | ||
| county_106 | NULLABLE | STRING | ||
| county_107 | NULLABLE | STRING | ||
| county_108 | NULLABLE | STRING | ||
| county_109 | NULLABLE | STRING | ||
| county_110 | NULLABLE | STRING | ||
| county_111 | NULLABLE | STRING | ||
| county_112 | NULLABLE | STRING | ||
| county_113 | NULLABLE | STRING | ||
| county_114 | NULLABLE | STRING | ||
| county_115 | NULLABLE | STRING | ||
| county_116 | NULLABLE | STRING | ||
| county_117 | NULLABLE | STRING | ||
| county_118 | NULLABLE | STRING | ||
| county_119 | NULLABLE | STRING | ||
| county_120 | NULLABLE | STRING | ||
| county_121 | NULLABLE | STRING | ||
| county_122 | NULLABLE | STRING | ||
| county_123 | NULLABLE | STRING | ||
| county_124 | NULLABLE | STRING | ||
| county_125 | NULLABLE | STRING | ||
| county_126 | NULLABLE | STRING | ||
| county_127 | NULLABLE | STRING | ||
| county_128 | NULLABLE | STRING | ||
| county_129 | NULLABLE | STRING | ||
| county_130 | NULLABLE | STRING | ||
| county_131 | NULLABLE | STRING | ||
| county_132 | NULLABLE | STRING | ||
| county_133 | NULLABLE | STRING | ||
| county_134 | NULLABLE | STRING | ||
| county_135 | NULLABLE | STRING | ||
| county_136 | NULLABLE | STRING | ||
| county_137 | NULLABLE | STRING | ||
| county_138 | NULLABLE | STRING | ||
| county_139 | NULLABLE | STRING | ||
| county_140 | NULLABLE | STRING | ||
| county_141 | NULLABLE | STRING | ||
| county_142 | NULLABLE | STRING | ||
| county_143 | NULLABLE | STRING | ||
| county_144 | NULLABLE | STRING | ||
| county_145 | NULLABLE | STRING | ||
| county_146 | NULLABLE | STRING | ||
| county_147 | NULLABLE | STRING | ||
| county_148 | NULLABLE | STRING | ||
| county_149 | NULLABLE | STRING | ||
| county_150 | NULLABLE | STRING | ||
| county_151 | NULLABLE | STRING | ||
| county_152 | NULLABLE | STRING | ||
| county_153 | NULLABLE | STRING | ||
| county_154 | NULLABLE | STRING | ||
| county_155 | NULLABLE | STRING | ||
| county_156 | NULLABLE | STRING | ||
| county_157 | NULLABLE | STRING | ||
| county_158 | NULLABLE | STRING | ||
| county_159 | NULLABLE | STRING | ||
| county_160 | NULLABLE | STRING | ||
| county_161 | NULLABLE | STRING | ||
| county_162 | NULLABLE | STRING | ||
| county_163 | NULLABLE | STRING | ||
| county_164 | NULLABLE | STRING | ||
| county_165 | NULLABLE | STRING | ||
| county_166 | NULLABLE | STRING | ||
| county_167 | NULLABLE | STRING | ||
| county_168 | NULLABLE | STRING | ||
| county_169 | NULLABLE | STRING | ||
| county_170 | NULLABLE | STRING | ||
| county_171 | NULLABLE | STRING | ||
| county_172 | NULLABLE | STRING | ||
| county_173 | NULLABLE | STRING | ||
| county_174 | NULLABLE | STRING | ||
| county_175 | NULLABLE | STRING | ||
| county_176 | NULLABLE | STRING | ||
| county_177 | NULLABLE | STRING | ||
| county_178 | NULLABLE | STRING | ||
| county_179 | NULLABLE | STRING | ||
| county_180 | NULLABLE | STRING | ||
| county_181 | NULLABLE | STRING | ||
| county_182 | NULLABLE | STRING | ||
| county_183 | NULLABLE | STRING | ||
| county_184 | NULLABLE | STRING | ||
| county_185 | NULLABLE | STRING | ||
| county_186 | NULLABLE | STRING | ||
| county_187 | NULLABLE | STRING | ||
| county_188 | NULLABLE | STRING | ||
| county_189 | NULLABLE | STRING | ||
| county_190 | NULLABLE | STRING | ||
| county_191 | NULLABLE | STRING | ||
| county_192 | NULLABLE | STRING | ||
| county_193 | NULLABLE | STRING | ||
| county_194 | NULLABLE | STRING | ||
| county_195 | NULLABLE | STRING | ||
| county_196 | NULLABLE | STRING | ||
| county_197 | NULLABLE | STRING | ||
| county_198 | NULLABLE | STRING | ||
| county_199 | NULLABLE | STRING | ||
| county_200 | NULLABLE | STRING | ||
| county_201 | NULLABLE | STRING | ||
| county_202 | NULLABLE | STRING | ||
| county_203 | NULLABLE | STRING | ||
| county_204 | NULLABLE | STRING | ||
| county_205 | NULLABLE | STRING | ||
| county_206 | NULLABLE | STRING | ||
| county_207 | NULLABLE | STRING | ||
| county_208 | NULLABLE | STRING | ||
| county_209 | NULLABLE | STRING | ||
| county_210 | NULLABLE | STRING | ||
| county_211 | NULLABLE | STRING | ||
| county_212 | NULLABLE | STRING | ||
| county_213 | NULLABLE | STRING | ||
| county_214 | NULLABLE | STRING | ||
| county_215 | NULLABLE | STRING | ||
| county_216 | NULLABLE | STRING | ||
| county_217 | NULLABLE | STRING | ||
| county_218 | NULLABLE | STRING | ||
| county_219 | NULLABLE | STRING | ||
| county_220 | NULLABLE | STRING | ||
| county_221 | NULLABLE | STRING | ||
| county_222 | NULLABLE | STRING | ||
| county_223 | NULLABLE | STRING | ||
| county_224 | NULLABLE | STRING | ||
| county_225 | NULLABLE | STRING | ||
| county_226 | NULLABLE | STRING | ||
| county_227 | NULLABLE | STRING | ||
| county_228 | NULLABLE | STRING | ||
| county_229 | NULLABLE | STRING | ||
| county_230 | NULLABLE | STRING | ||
| county_231 | NULLABLE | STRING | ||
| county_232 | NULLABLE | STRING | ||
| county_233 | NULLABLE | STRING | ||
| county_234 | NULLABLE | STRING | ||
| county_235 | NULLABLE | STRING | ||
| county_236 | NULLABLE | STRING | ||
| county_237 | NULLABLE | STRING | ||
| county_238 | NULLABLE | STRING | ||
| county_239 | NULLABLE | STRING | ||
| county_240 | NULLABLE | STRING | ||
| county_241 | NULLABLE | STRING | ||
| county_242 | NULLABLE | STRING | ||
| county_243 | NULLABLE | STRING | ||
| county_244 | NULLABLE | STRING | ||
| county_245 | NULLABLE | STRING | ||
| county_246 | NULLABLE | STRING | ||
| county_247 | NULLABLE | STRING | ||
| county_248 | NULLABLE | STRING | ||
| county_249 | NULLABLE | STRING | ||
| county_250 | NULLABLE | STRING | ||
| county_251 | NULLABLE | STRING | ||
| county_252 | NULLABLE | STRING | ||
| county_253 | NULLABLE | STRING | ||
| county_254 | NULLABLE | STRING | ||
| county_255 | NULLABLE | STRING | ||
| county_256 | NULLABLE | STRING | ||
| county_257 | NULLABLE | STRING | ||
| county_258 | NULLABLE | STRING | ||
| county_259 | NULLABLE | STRING | ||
| county_260 | NULLABLE | STRING | ||
| county_261 | NULLABLE | STRING | ||
| county_262 | NULLABLE | STRING | ||
| county_263 | NULLABLE | STRING | ||
| county_264 | NULLABLE | STRING | ||
| county_265 | NULLABLE | STRING | ||
| county_266 | NULLABLE | STRING | ||
| county_267 | NULLABLE | STRING | ||
| county_268 | NULLABLE | STRING | ||
| county_269 | NULLABLE | STRING | ||
| county_270 | NULLABLE | STRING | ||
| county_271 | NULLABLE | STRING | ||
| county_272 | NULLABLE | STRING | ||
| county_273 | NULLABLE | STRING | ||
| county_274 | NULLABLE | STRING | ||
| county_275 | NULLABLE | STRING | ||
| county_276 | NULLABLE | STRING | ||
| county_277 | NULLABLE | STRING | ||
| county_278 | NULLABLE | STRING | ||
| county_279 | NULLABLE | STRING | ||
| county_280 | NULLABLE | STRING | ||
| county_281 | NULLABLE | STRING | ||
| county_282 | NULLABLE | STRING | ||
| county_283 | NULLABLE | STRING | ||
| county_284 | NULLABLE | STRING | ||
| county_285 | NULLABLE | STRING | ||
| county_286 | NULLABLE | STRING | ||
| county_287 | NULLABLE | STRING | ||
| county_288 | NULLABLE | STRING | ||
| county_289 | NULLABLE | STRING | ||
| county_290 | NULLABLE | STRING | ||
| county_291 | NULLABLE | STRING | ||
| county_292 | NULLABLE | STRING | ||
| county_293 | NULLABLE | STRING | ||
| county_294 | NULLABLE | STRING | ||
| county_295 | NULLABLE | STRING | ||
| county_296 | NULLABLE | STRING | ||
| county_297 | NULLABLE | STRING | ||
| county_298 | NULLABLE | STRING | ||
| county_299 | NULLABLE | STRING | ||
| county_300 | NULLABLE | STRING |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
- Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.
Did this page help you?
Last updated Tue Sep 15 2026