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 |
---|---|---|---|---|---|---|---|
636694 | 636694 | 2020-10-16 | Union | New Jersey | 34039 | 18672 | 1362 |
633448 | 633448 | 2020-10-15 | Union | New Jersey | 34039 | 18607 | 1362 |
630203 | 630203 | 2020-10-14 | Union | New Jersey | 34039 | 18542 | 1362 |
626959 | 626959 | 2020-10-13 | Union | New Jersey | 34039 | 18483 | 1361 |
623717 | 623717 | 2020-10-12 | Union | New Jersey | 34039 | 18414 | 1361 |
620474 | 620474 | 2020-10-11 | Union | New Jersey | 34039 | 18373 | 1361 |
617232 | 617232 | 2020-10-10 | Union | New Jersey | 34039 | 18330 | 1361 |
613990 | 613990 | 2020-10-09 | Union | New Jersey | 34039 | 18276 | 1360 |
610749 | 610749 | 2020-10-08 | Union | New Jersey | 34039 | 18228 | 1360 |
607507 | 607507 | 2020-10-07 | Union | New Jersey | 34039 | 18145 | 1361 |
604264 | 604264 | 2020-10-06 | Union | New Jersey | 34039 | 18111 | 1360 |
601022 | 601022 | 2020-10-05 | Union | New Jersey | 34039 | 18070 | 1358 |
597778 | 597778 | 2020-10-04 | Union | New Jersey | 34039 | 18037 | 1357 |
594536 | 594536 | 2020-10-03 | Union | New Jersey | 34039 | 17999 | 1357 |
591295 | 591295 | 2020-10-02 | Union | New Jersey | 34039 | 17956 | 1357 |
588054 | 588054 | 2020-10-01 | Union | New Jersey | 34039 | 17928 | 1356 |
584814 | 584814 | 2020-09-30 | Union | New Jersey | 34039 | 17894 | 1356 |
581573 | 581573 | 2020-09-29 | Union | New Jersey | 34039 | 17855 | 1355 |
578332 | 578332 | 2020-09-28 | Union | New Jersey | 34039 | 17837 | 1355 |
575091 | 575091 | 2020-09-27 | Union | New Jersey | 34039 | 17807 | 1355 |
571848 | 571848 | 2020-09-26 | Union | New Jersey | 34039 | 17768 | 1355 |
568606 | 568606 | 2020-09-25 | Union | New Jersey | 34039 | 17731 | 1355 |
565365 | 565365 | 2020-09-24 | Union | New Jersey | 34039 | 17709 | 1356 |
562124 | 562124 | 2020-09-23 | Union | New Jersey | 34039 | 17683 | 1356 |
558887 | 558887 | 2020-09-22 | Union | New Jersey | 34039 | 17671 | 1357 |
555650 | 555650 | 2020-09-21 | Union | New Jersey | 34039 | 17632 | 1357 |
552412 | 552412 | 2020-09-20 | Union | New Jersey | 34039 | 17606 | 1357 |
549173 | 549173 | 2020-09-19 | Union | New Jersey | 34039 | 17581 | 1356 |
545935 | 545935 | 2020-09-18 | Union | New Jersey | 34039 | 17556 | 1356 |
542698 | 542698 | 2020-09-17 | Union | New Jersey | 34039 | 17533 | 1356 |
539461 | 539461 | 2020-09-16 | Union | New Jersey | 34039 | 17521 | 1356 |
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 |
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);