ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

793 rows where county = "Essex", fips = 34013 and state = "New Jersey" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • New Jersey · 793 ✖

fips 1

  • 34013 · 793 ✖

county 1

  • Essex · 793 ✖
Link rowid date ▲ county state fips cases deaths
2501378 2501378 2022-05-13 Essex New Jersey 34013 222558 3614
2498120 2498120 2022-05-12 Essex New Jersey 34013 221984 3612
2494862 2494862 2022-05-11 Essex New Jersey 34013 221477 3611
2491604 2491604 2022-05-10 Essex New Jersey 34013 221033 3611
2488346 2488346 2022-05-09 Essex New Jersey 34013 220683 3611
2485089 2485089 2022-05-08 Essex New Jersey 34013 220451 3610
2481831 2481831 2022-05-07 Essex New Jersey 34013 220065 3610
2478573 2478573 2022-05-06 Essex New Jersey 34013 219718 3610
2475315 2475315 2022-05-05 Essex New Jersey 34013 219342 3610
2472058 2472058 2022-05-04 Essex New Jersey 34013 218989 3610
2468802 2468802 2022-05-03 Essex New Jersey 34013 218710 3607
2465546 2465546 2022-05-02 Essex New Jersey 34013 218510 3606
2462291 2462291 2022-05-01 Essex New Jersey 34013 218154 3604
2459035 2459035 2022-04-30 Essex New Jersey 34013 217910 3604
2455779 2455779 2022-04-29 Essex New Jersey 34013 217586 3604
2452523 2452523 2022-04-28 Essex New Jersey 34013 217255 3604
2449267 2449267 2022-04-27 Essex New Jersey 34013 216999 3604
2446010 2446010 2022-04-26 Essex New Jersey 34013 216680 3603
2442755 2442755 2022-04-25 Essex New Jersey 34013 216385 3603
2439499 2439499 2022-04-24 Essex New Jersey 34013 216241 3602
2436243 2436243 2022-04-23 Essex New Jersey 34013 216059 3602
2432987 2432987 2022-04-22 Essex New Jersey 34013 215839 3601
2429731 2429731 2022-04-21 Essex New Jersey 34013 215585 3601
2426475 2426475 2022-04-20 Essex New Jersey 34013 215359 3600
2423219 2423219 2022-04-19 Essex New Jersey 34013 215155 3600
2419962 2419962 2022-04-18 Essex New Jersey 34013 215010 3598
2416707 2416707 2022-04-17 Essex New Jersey 34013 214933 3600
2413451 2413451 2022-04-16 Essex New Jersey 34013 214767 3600
2410195 2410195 2022-04-15 Essex New Jersey 34013 214304 3599
2406939 2406939 2022-04-14 Essex New Jersey 34013 214304 3599
2403683 2403683 2022-04-13 Essex New Jersey 34013 213994 3598
2400428 2400428 2022-04-12 Essex New Jersey 34013 213770 3598
2397173 2397173 2022-04-11 Essex New Jersey 34013 213607 3598
2393918 2393918 2022-04-10 Essex New Jersey 34013 213485 3597
2390662 2390662 2022-04-09 Essex New Jersey 34013 213301 3597
2387406 2387406 2022-04-08 Essex New Jersey 34013 213147 3597
2384151 2384151 2022-04-07 Essex New Jersey 34013 212946 3596
2380896 2380896 2022-04-06 Essex New Jersey 34013 212763 3595
2377641 2377641 2022-04-05 Essex New Jersey 34013 212590 3594
2374388 2374388 2022-04-04 Essex New Jersey 34013 212437 3595
2371136 2371136 2022-04-03 Essex New Jersey 34013 212335 3594
2367883 2367883 2022-04-02 Essex New Jersey 34013 212234 3594
2364630 2364630 2022-04-01 Essex New Jersey 34013 212094 3594
2361376 2361376 2022-03-31 Essex New Jersey 34013 211952 3593
2358122 2358122 2022-03-30 Essex New Jersey 34013 211827 3593
2354869 2354869 2022-03-29 Essex New Jersey 34013 211693 3593
2351616 2351616 2022-03-28 Essex New Jersey 34013 211625 3593
2348364 2348364 2022-03-27 Essex New Jersey 34013 211554 3593
2345111 2345111 2022-03-26 Essex New Jersey 34013 211467 3593
2341858 2341858 2022-03-25 Essex New Jersey 34013 211374 3593
2338605 2338605 2022-03-24 Essex New Jersey 34013 211272 3592
2335351 2335351 2022-03-23 Essex New Jersey 34013 211125 3592
2332097 2332097 2022-03-22 Essex New Jersey 34013 210981 3592
2328844 2328844 2022-03-21 Essex New Jersey 34013 210971 3591
2325592 2325592 2022-03-20 Essex New Jersey 34013 210918 3590
2322338 2322338 2022-03-19 Essex New Jersey 34013 210873 3589
2319084 2319084 2022-03-18 Essex New Jersey 34013 210817 3588
2315831 2315831 2022-03-17 Essex New Jersey 34013 210663 3588
2312578 2312578 2022-03-16 Essex New Jersey 34013 210566 3586
2309325 2309325 2022-03-15 Essex New Jersey 34013 210392 3586
2306072 2306072 2022-03-14 Essex New Jersey 34013 210309 3586
2302821 2302821 2022-03-13 Essex New Jersey 34013 210274 3584
2299569 2299569 2022-03-12 Essex New Jersey 34013 210190 3581
2296317 2296317 2022-03-11 Essex New Jersey 34013 210190 3581
2293065 2293065 2022-03-10 Essex New Jersey 34013 210034 3578
2289813 2289813 2022-03-09 Essex New Jersey 34013 209933 3577
2286561 2286561 2022-03-08 Essex New Jersey 34013 209817 3574
2283309 2283309 2022-03-07 Essex New Jersey 34013 209714 3573
2280056 2280056 2022-03-06 Essex New Jersey 34013 209609 3572
2276803 2276803 2022-03-05 Essex New Jersey 34013 209547 3572
2273550 2273550 2022-03-04 Essex New Jersey 34013 209470 3572
2270298 2270298 2022-03-03 Essex New Jersey 34013 209367 3572
2267045 2267045 2022-03-02 Essex New Jersey 34013 209272 3571
2263794 2263794 2022-03-01 Essex New Jersey 34013 209147 3568
2260543 2260543 2022-02-28 Essex New Jersey 34013 209068 3566
2257292 2257292 2022-02-27 Essex New Jersey 34013 209003 3566
2254041 2254041 2022-02-26 Essex New Jersey 34013 208917 3563
2250790 2250790 2022-02-25 Essex New Jersey 34013 208831 3562
2247539 2247539 2022-02-24 Essex New Jersey 34013 208715 3560
2244288 2244288 2022-02-23 Essex New Jersey 34013 208566 3556
2241037 2241037 2022-02-22 Essex New Jersey 34013 208455 3552
2237786 2237786 2022-02-21 Essex New Jersey 34013 208366 3552
2234535 2234535 2022-02-20 Essex New Jersey 34013 208314 3549
2231284 2231284 2022-02-19 Essex New Jersey 34013 208150 3547
2228033 2228033 2022-02-18 Essex New Jersey 34013 208065 3542
2224782 2224782 2022-02-17 Essex New Jersey 34013 207838 3539
2221531 2221531 2022-02-16 Essex New Jersey 34013 207671 3536
2218280 2218280 2022-02-15 Essex New Jersey 34013 207506 3532
2215029 2215029 2022-02-14 Essex New Jersey 34013 207375 3529
2211777 2211777 2022-02-13 Essex New Jersey 34013 207297 3527
2208524 2208524 2022-02-12 Essex New Jersey 34013 207221 3526
2205271 2205271 2022-02-11 Essex New Jersey 34013 207128 3524
2202018 2202018 2022-02-10 Essex New Jersey 34013 206962 3519
2198764 2198764 2022-02-09 Essex New Jersey 34013 206682 3511
2195510 2195510 2022-02-08 Essex New Jersey 34013 206534 3501
2192256 2192256 2022-02-07 Essex New Jersey 34013 206450 3493
2189003 2189003 2022-02-06 Essex New Jersey 34013 206434 3491
2185750 2185750 2022-02-05 Essex New Jersey 34013 206309 3490
2182498 2182498 2022-02-04 Essex New Jersey 34013 206149 3479
2179246 2179246 2022-02-03 Essex New Jersey 34013 205976 3472

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);