ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 34019 and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536214 | 536214 | 2020-09-15 | Hunterdon | New Jersey | 34019 | 1318 | 125 |
532979 | 532979 | 2020-09-14 | Hunterdon | New Jersey | 34019 | 1318 | 125 |
529743 | 529743 | 2020-09-13 | Hunterdon | New Jersey | 34019 | 1310 | 125 |
526507 | 526507 | 2020-09-12 | Hunterdon | New Jersey | 34019 | 1307 | 125 |
523271 | 523271 | 2020-09-11 | Hunterdon | New Jersey | 34019 | 1303 | 125 |
520034 | 520034 | 2020-09-10 | Hunterdon | New Jersey | 34019 | 1299 | 125 |
516799 | 516799 | 2020-09-09 | Hunterdon | New Jersey | 34019 | 1296 | 125 |
513565 | 513565 | 2020-09-08 | Hunterdon | New Jersey | 34019 | 1290 | 125 |
510332 | 510332 | 2020-09-07 | Hunterdon | New Jersey | 34019 | 1289 | 125 |
507099 | 507099 | 2020-09-06 | Hunterdon | New Jersey | 34019 | 1284 | 125 |
503867 | 503867 | 2020-09-05 | Hunterdon | New Jersey | 34019 | 1283 | 125 |
500633 | 500633 | 2020-09-04 | Hunterdon | New Jersey | 34019 | 1278 | 125 |
497399 | 497399 | 2020-09-03 | Hunterdon | New Jersey | 34019 | 1276 | 125 |
494166 | 494166 | 2020-09-02 | Hunterdon | New Jersey | 34019 | 1271 | 125 |
490932 | 490932 | 2020-09-01 | Hunterdon | New Jersey | 34019 | 1266 | 124 |
487699 | 487699 | 2020-08-31 | Hunterdon | New Jersey | 34019 | 1267 | 124 |
484465 | 484465 | 2020-08-30 | Hunterdon | New Jersey | 34019 | 1266 | 124 |
481230 | 481230 | 2020-08-29 | Hunterdon | New Jersey | 34019 | 1267 | 124 |
477998 | 477998 | 2020-08-28 | Hunterdon | New Jersey | 34019 | 1263 | 124 |
474765 | 474765 | 2020-08-27 | Hunterdon | New Jersey | 34019 | 1260 | 124 |
471531 | 471531 | 2020-08-26 | Hunterdon | New Jersey | 34019 | 1256 | 124 |
468299 | 468299 | 2020-08-25 | Hunterdon | New Jersey | 34019 | 1251 | 124 |
465071 | 465071 | 2020-08-24 | Hunterdon | New Jersey | 34019 | 1250 | 124 |
461841 | 461841 | 2020-08-23 | Hunterdon | New Jersey | 34019 | 1246 | 124 |
458613 | 458613 | 2020-08-22 | Hunterdon | New Jersey | 34019 | 1244 | 124 |
455386 | 455386 | 2020-08-21 | Hunterdon | New Jersey | 34019 | 1236 | 124 |
452158 | 452158 | 2020-08-20 | Hunterdon | New Jersey | 34019 | 1234 | 124 |
448929 | 448929 | 2020-08-19 | Hunterdon | New Jersey | 34019 | 1225 | 124 |
445702 | 445702 | 2020-08-18 | Hunterdon | New Jersey | 34019 | 1219 | 124 |
442476 | 442476 | 2020-08-17 | Hunterdon | New Jersey | 34019 | 1217 | 124 |
439249 | 439249 | 2020-08-16 | Hunterdon | New Jersey | 34019 | 1215 | 124 |
436024 | 436024 | 2020-08-15 | Hunterdon | New Jersey | 34019 | 1212 | 124 |
432798 | 432798 | 2020-08-14 | Hunterdon | New Jersey | 34019 | 1208 | 124 |
429571 | 429571 | 2020-08-13 | Hunterdon | New Jersey | 34019 | 1205 | 124 |
426347 | 426347 | 2020-08-12 | Hunterdon | New Jersey | 34019 | 1204 | 124 |
423124 | 423124 | 2020-08-11 | Hunterdon | New Jersey | 34019 | 1205 | 126 |
419901 | 419901 | 2020-08-10 | Hunterdon | New Jersey | 34019 | 1205 | 126 |
416681 | 416681 | 2020-08-09 | Hunterdon | New Jersey | 34019 | 1205 | 126 |
413460 | 413460 | 2020-08-08 | Hunterdon | New Jersey | 34019 | 1204 | 126 |
410240 | 410240 | 2020-08-07 | Hunterdon | New Jersey | 34019 | 1202 | 126 |
407020 | 407020 | 2020-08-06 | Hunterdon | New Jersey | 34019 | 1200 | 126 |
403801 | 403801 | 2020-08-05 | Hunterdon | New Jersey | 34019 | 1200 | 126 |
400583 | 400583 | 2020-08-04 | Hunterdon | New Jersey | 34019 | 1195 | 126 |
397368 | 397368 | 2020-08-03 | Hunterdon | New Jersey | 34019 | 1194 | 126 |
394151 | 394151 | 2020-08-02 | Hunterdon | New Jersey | 34019 | 1193 | 126 |
390934 | 390934 | 2020-08-01 | Hunterdon | New Jersey | 34019 | 1192 | 126 |
387718 | 387718 | 2020-07-31 | Hunterdon | New Jersey | 34019 | 1186 | 126 |
384501 | 384501 | 2020-07-30 | Hunterdon | New Jersey | 34019 | 1181 | 126 |
381283 | 381283 | 2020-07-29 | Hunterdon | New Jersey | 34019 | 1181 | 126 |
378065 | 378065 | 2020-07-28 | Hunterdon | New Jersey | 34019 | 1179 | 126 |
374850 | 374850 | 2020-07-27 | Hunterdon | New Jersey | 34019 | 1178 | 126 |
371638 | 371638 | 2020-07-26 | Hunterdon | New Jersey | 34019 | 1176 | 126 |
368426 | 368426 | 2020-07-25 | Hunterdon | New Jersey | 34019 | 1171 | 126 |
365217 | 365217 | 2020-07-24 | Hunterdon | New Jersey | 34019 | 1169 | 126 |
362011 | 362011 | 2020-07-23 | Hunterdon | New Jersey | 34019 | 1158 | 126 |
358805 | 358805 | 2020-07-22 | Hunterdon | New Jersey | 34019 | 1158 | 126 |
355601 | 355601 | 2020-07-21 | Hunterdon | New Jersey | 34019 | 1157 | 126 |
352398 | 352398 | 2020-07-20 | Hunterdon | New Jersey | 34019 | 1156 | 126 |
349195 | 349195 | 2020-07-19 | Hunterdon | New Jersey | 34019 | 1156 | 126 |
345994 | 345994 | 2020-07-18 | Hunterdon | New Jersey | 34019 | 1157 | 126 |
342795 | 342795 | 2020-07-17 | Hunterdon | New Jersey | 34019 | 1155 | 126 |
339597 | 339597 | 2020-07-16 | Hunterdon | New Jersey | 34019 | 1154 | 126 |
336401 | 336401 | 2020-07-15 | Hunterdon | New Jersey | 34019 | 1154 | 126 |
333207 | 333207 | 2020-07-14 | Hunterdon | New Jersey | 34019 | 1151 | 126 |
330017 | 330017 | 2020-07-13 | Hunterdon | New Jersey | 34019 | 1150 | 126 |
326830 | 326830 | 2020-07-12 | Hunterdon | New Jersey | 34019 | 1150 | 125 |
323646 | 323646 | 2020-07-11 | Hunterdon | New Jersey | 34019 | 1150 | 125 |
320466 | 320466 | 2020-07-10 | Hunterdon | New Jersey | 34019 | 1152 | 125 |
317290 | 317290 | 2020-07-09 | Hunterdon | New Jersey | 34019 | 1150 | 125 |
314116 | 314116 | 2020-07-08 | Hunterdon | New Jersey | 34019 | 1146 | 124 |
310945 | 310945 | 2020-07-07 | Hunterdon | New Jersey | 34019 | 1145 | 124 |
307777 | 307777 | 2020-07-06 | Hunterdon | New Jersey | 34019 | 1145 | 124 |
304610 | 304610 | 2020-07-05 | Hunterdon | New Jersey | 34019 | 1143 | 124 |
301447 | 301447 | 2020-07-04 | Hunterdon | New Jersey | 34019 | 1142 | 124 |
298284 | 298284 | 2020-07-03 | Hunterdon | New Jersey | 34019 | 1140 | 124 |
295124 | 295124 | 2020-07-02 | Hunterdon | New Jersey | 34019 | 1138 | 124 |
291969 | 291969 | 2020-07-01 | Hunterdon | New Jersey | 34019 | 1136 | 124 |
288817 | 288817 | 2020-06-30 | Hunterdon | New Jersey | 34019 | 1135 | 124 |
285667 | 285667 | 2020-06-29 | Hunterdon | New Jersey | 34019 | 1131 | 123 |
282522 | 282522 | 2020-06-28 | Hunterdon | New Jersey | 34019 | 1129 | 123 |
279375 | 279375 | 2020-06-27 | Hunterdon | New Jersey | 34019 | 1120 | 122 |
276227 | 276227 | 2020-06-26 | Hunterdon | New Jersey | 34019 | 1120 | 122 |
273082 | 273082 | 2020-06-25 | Hunterdon | New Jersey | 34019 | 1120 | 122 |
269943 | 269943 | 2020-06-24 | Hunterdon | New Jersey | 34019 | 1064 | 67 |
266808 | 266808 | 2020-06-23 | Hunterdon | New Jersey | 34019 | 1062 | 67 |
263681 | 263681 | 2020-06-22 | Hunterdon | New Jersey | 34019 | 1060 | 67 |
260552 | 260552 | 2020-06-21 | Hunterdon | New Jersey | 34019 | 1054 | 67 |
257426 | 257426 | 2020-06-20 | Hunterdon | New Jersey | 34019 | 1053 | 67 |
254303 | 254303 | 2020-06-19 | Hunterdon | New Jersey | 34019 | 1050 | 67 |
251188 | 251188 | 2020-06-18 | Hunterdon | New Jersey | 34019 | 1049 | 67 |
248073 | 248073 | 2020-06-17 | Hunterdon | New Jersey | 34019 | 1049 | 67 |
244960 | 244960 | 2020-06-16 | Hunterdon | New Jersey | 34019 | 1042 | 66 |
241848 | 241848 | 2020-06-15 | Hunterdon | New Jersey | 34019 | 1041 | 66 |
238738 | 238738 | 2020-06-14 | Hunterdon | New Jersey | 34019 | 1039 | 66 |
235631 | 235631 | 2020-06-13 | Hunterdon | New Jersey | 34019 | 1038 | 66 |
232526 | 232526 | 2020-06-12 | Hunterdon | New Jersey | 34019 | 1034 | 66 |
229421 | 229421 | 2020-06-11 | Hunterdon | New Jersey | 34019 | 1032 | 65 |
226317 | 226317 | 2020-06-10 | Hunterdon | New Jersey | 34019 | 1028 | 64 |
223217 | 223217 | 2020-06-09 | Hunterdon | New Jersey | 34019 | 1027 | 64 |
220122 | 220122 | 2020-06-08 | Hunterdon | New Jersey | 34019 | 1025 | 64 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);