ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Union" 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 |
---|---|---|---|---|---|---|---|
536224 | 536224 | 2020-09-15 | Union | New Jersey | 34039 | 17503 | 1356 |
532989 | 532989 | 2020-09-14 | Union | New Jersey | 34039 | 17490 | 1355 |
529753 | 529753 | 2020-09-13 | Union | New Jersey | 34039 | 17481 | 1355 |
526517 | 526517 | 2020-09-12 | Union | New Jersey | 34039 | 17465 | 1354 |
523281 | 523281 | 2020-09-11 | Union | New Jersey | 34039 | 17452 | 1354 |
520044 | 520044 | 2020-09-10 | Union | New Jersey | 34039 | 17433 | 1354 |
516809 | 516809 | 2020-09-09 | Union | New Jersey | 34039 | 17414 | 1355 |
513575 | 513575 | 2020-09-08 | Union | New Jersey | 34039 | 17404 | 1354 |
510342 | 510342 | 2020-09-07 | Union | New Jersey | 34039 | 17384 | 1354 |
507109 | 507109 | 2020-09-06 | Union | New Jersey | 34039 | 17378 | 1354 |
503877 | 503877 | 2020-09-05 | Union | New Jersey | 34039 | 17362 | 1353 |
500643 | 500643 | 2020-09-04 | Union | New Jersey | 34039 | 17353 | 1352 |
497409 | 497409 | 2020-09-03 | Union | New Jersey | 34039 | 17327 | 1352 |
494176 | 494176 | 2020-09-02 | Union | New Jersey | 34039 | 17303 | 1351 |
490942 | 490942 | 2020-09-01 | Union | New Jersey | 34039 | 17290 | 1351 |
487709 | 487709 | 2020-08-31 | Union | New Jersey | 34039 | 17269 | 1351 |
484475 | 484475 | 2020-08-30 | Union | New Jersey | 34039 | 17243 | 1350 |
481240 | 481240 | 2020-08-29 | Union | New Jersey | 34039 | 17232 | 1350 |
478008 | 478008 | 2020-08-28 | Union | New Jersey | 34039 | 17218 | 1350 |
474775 | 474775 | 2020-08-27 | Union | New Jersey | 34039 | 17206 | 1350 |
471541 | 471541 | 2020-08-26 | Union | New Jersey | 34039 | 17189 | 1350 |
468309 | 468309 | 2020-08-25 | Union | New Jersey | 34039 | 17176 | 1350 |
465081 | 465081 | 2020-08-24 | Union | New Jersey | 34039 | 17158 | 1352 |
461851 | 461851 | 2020-08-23 | Union | New Jersey | 34039 | 17144 | 1352 |
458623 | 458623 | 2020-08-22 | Union | New Jersey | 34039 | 17133 | 1352 |
455396 | 455396 | 2020-08-21 | Union | New Jersey | 34039 | 17113 | 1352 |
452168 | 452168 | 2020-08-20 | Union | New Jersey | 34039 | 17093 | 1350 |
448939 | 448939 | 2020-08-19 | Union | New Jersey | 34039 | 17087 | 1349 |
445712 | 445712 | 2020-08-18 | Union | New Jersey | 34039 | 17066 | 1350 |
442486 | 442486 | 2020-08-17 | Union | New Jersey | 34039 | 17047 | 1350 |
439259 | 439259 | 2020-08-16 | Union | New Jersey | 34039 | 17037 | 1349 |
436034 | 436034 | 2020-08-15 | Union | New Jersey | 34039 | 17015 | 1349 |
432808 | 432808 | 2020-08-14 | Union | New Jersey | 34039 | 16995 | 1349 |
429581 | 429581 | 2020-08-13 | Union | New Jersey | 34039 | 16980 | 1349 |
426357 | 426357 | 2020-08-12 | Union | New Jersey | 34039 | 16948 | 1348 |
423134 | 423134 | 2020-08-11 | Union | New Jersey | 34039 | 16919 | 1349 |
419911 | 419911 | 2020-08-10 | Union | New Jersey | 34039 | 16895 | 1350 |
416691 | 416691 | 2020-08-09 | Union | New Jersey | 34039 | 16865 | 1350 |
413470 | 413470 | 2020-08-08 | Union | New Jersey | 34039 | 16833 | 1350 |
410250 | 410250 | 2020-08-07 | Union | New Jersey | 34039 | 16806 | 1348 |
407030 | 407030 | 2020-08-06 | Union | New Jersey | 34039 | 16792 | 1348 |
403811 | 403811 | 2020-08-05 | Union | New Jersey | 34039 | 16775 | 1347 |
400593 | 400593 | 2020-08-04 | Union | New Jersey | 34039 | 16761 | 1348 |
397378 | 397378 | 2020-08-03 | Union | New Jersey | 34039 | 16761 | 1348 |
394161 | 394161 | 2020-08-02 | Union | New Jersey | 34039 | 16746 | 1348 |
390944 | 390944 | 2020-08-01 | Union | New Jersey | 34039 | 16716 | 1347 |
387728 | 387728 | 2020-07-31 | Union | New Jersey | 34039 | 16694 | 1347 |
384511 | 384511 | 2020-07-30 | Union | New Jersey | 34039 | 16627 | 1346 |
381293 | 381293 | 2020-07-29 | Union | New Jersey | 34039 | 16610 | 1345 |
378075 | 378075 | 2020-07-28 | Union | New Jersey | 34039 | 16585 | 1349 |
374860 | 374860 | 2020-07-27 | Union | New Jersey | 34039 | 16551 | 1347 |
371648 | 371648 | 2020-07-26 | Union | New Jersey | 34039 | 16534 | 1345 |
368436 | 368436 | 2020-07-25 | Union | New Jersey | 34039 | 16510 | 1345 |
365227 | 365227 | 2020-07-24 | Union | New Jersey | 34039 | 16496 | 1345 |
362021 | 362021 | 2020-07-23 | Union | New Jersey | 34039 | 16472 | 1343 |
358815 | 358815 | 2020-07-22 | Union | New Jersey | 34039 | 16526 | 1342 |
355611 | 355611 | 2020-07-21 | Union | New Jersey | 34039 | 16694 | 1346 |
352408 | 352408 | 2020-07-20 | Union | New Jersey | 34039 | 16696 | 1344 |
349205 | 349205 | 2020-07-19 | Union | New Jersey | 34039 | 16687 | 1344 |
346004 | 346004 | 2020-07-18 | Union | New Jersey | 34039 | 16725 | 1344 |
342805 | 342805 | 2020-07-17 | Union | New Jersey | 34039 | 16719 | 1343 |
339607 | 339607 | 2020-07-16 | Union | New Jersey | 34039 | 16746 | 1341 |
336411 | 336411 | 2020-07-15 | Union | New Jersey | 34039 | 16742 | 1340 |
333217 | 333217 | 2020-07-14 | Union | New Jersey | 34039 | 16721 | 1344 |
330027 | 330027 | 2020-07-13 | Union | New Jersey | 34039 | 16703 | 1343 |
326840 | 326840 | 2020-07-12 | Union | New Jersey | 34039 | 16685 | 1343 |
323656 | 323656 | 2020-07-11 | Union | New Jersey | 34039 | 16655 | 1343 |
320476 | 320476 | 2020-07-10 | Union | New Jersey | 34039 | 16644 | 1341 |
317300 | 317300 | 2020-07-09 | Union | New Jersey | 34039 | 16646 | 1341 |
314126 | 314126 | 2020-07-08 | Union | New Jersey | 34039 | 16618 | 1330 |
310955 | 310955 | 2020-07-07 | Union | New Jersey | 34039 | 16625 | 1331 |
307787 | 307787 | 2020-07-06 | Union | New Jersey | 34039 | 16607 | 1328 |
304620 | 304620 | 2020-07-05 | Union | New Jersey | 34039 | 16630 | 1328 |
301457 | 301457 | 2020-07-04 | Union | New Jersey | 34039 | 16616 | 1327 |
298294 | 298294 | 2020-07-03 | Union | New Jersey | 34039 | 16591 | 1326 |
295134 | 295134 | 2020-07-02 | Union | New Jersey | 34039 | 16569 | 1325 |
291979 | 291979 | 2020-07-01 | Union | New Jersey | 34039 | 16564 | 1329 |
288827 | 288827 | 2020-06-30 | Union | New Jersey | 34039 | 16566 | 1326 |
285677 | 285677 | 2020-06-29 | Union | New Jersey | 34039 | 16557 | 1325 |
282532 | 282532 | 2020-06-28 | Union | New Jersey | 34039 | 16548 | 1325 |
279385 | 279385 | 2020-06-27 | Union | New Jersey | 34039 | 16533 | 1324 |
276237 | 276237 | 2020-06-26 | Union | New Jersey | 34039 | 16536 | 1323 |
273092 | 273092 | 2020-06-25 | Union | New Jersey | 34039 | 16514 | 1321 |
269953 | 269953 | 2020-06-24 | Union | New Jersey | 34039 | 16330 | 1140 |
266818 | 266818 | 2020-06-23 | Union | New Jersey | 34039 | 16341 | 1139 |
263691 | 263691 | 2020-06-22 | Union | New Jersey | 34039 | 16340 | 1138 |
260562 | 260562 | 2020-06-21 | Union | New Jersey | 34039 | 16322 | 1135 |
257436 | 257436 | 2020-06-20 | Union | New Jersey | 34039 | 16298 | 1135 |
254313 | 254313 | 2020-06-19 | Union | New Jersey | 34039 | 16291 | 1131 |
251198 | 251198 | 2020-06-18 | Union | New Jersey | 34039 | 16304 | 1132 |
248083 | 248083 | 2020-06-17 | Union | New Jersey | 34039 | 16315 | 1131 |
244970 | 244970 | 2020-06-16 | Union | New Jersey | 34039 | 16320 | 1130 |
241858 | 241858 | 2020-06-15 | Union | New Jersey | 34039 | 16308 | 1128 |
238748 | 238748 | 2020-06-14 | Union | New Jersey | 34039 | 16322 | 1126 |
235641 | 235641 | 2020-06-13 | Union | New Jersey | 34039 | 16337 | 1121 |
232536 | 232536 | 2020-06-12 | Union | New Jersey | 34039 | 16351 | 1112 |
229431 | 229431 | 2020-06-11 | Union | New Jersey | 34039 | 16337 | 1104 |
226327 | 226327 | 2020-06-10 | Union | New Jersey | 34039 | 16317 | 1103 |
223227 | 223227 | 2020-06-09 | Union | New Jersey | 34039 | 16302 | 1100 |
220132 | 220132 | 2020-06-08 | Union | New Jersey | 34039 | 16241 | 1100 |
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);