ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 36059 and state = "New York" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
565 | 565 | 2020-03-05 | Nassau | New York | 36059 | 1 | 0 |
627 | 627 | 2020-03-06 | Nassau | New York | 36059 | 4 | 0 |
715 | 715 | 2020-03-07 | Nassau | New York | 36059 | 4 | 0 |
820 | 820 | 2020-03-08 | Nassau | New York | 36059 | 5 | 0 |
947 | 947 | 2020-03-09 | Nassau | New York | 36059 | 17 | 0 |
1098 | 1098 | 2020-03-10 | Nassau | New York | 36059 | 19 | 0 |
1285 | 1285 | 2020-03-11 | Nassau | New York | 36059 | 28 | 0 |
1521 | 1521 | 2020-03-12 | Nassau | New York | 36059 | 41 | 0 |
1814 | 1814 | 2020-03-13 | Nassau | New York | 36059 | 51 | 0 |
2163 | 2163 | 2020-03-14 | Nassau | New York | 36059 | 79 | 0 |
2574 | 2574 | 2020-03-15 | Nassau | New York | 36059 | 98 | 0 |
3033 | 3033 | 2020-03-16 | Nassau | New York | 36059 | 109 | 0 |
3549 | 3549 | 2020-03-17 | Nassau | New York | 36059 | 131 | 2 |
4150 | 4150 | 2020-03-18 | Nassau | New York | 36059 | 183 | 2 |
4879 | 4879 | 2020-03-19 | Nassau | New York | 36059 | 382 | 3 |
5728 | 5728 | 2020-03-20 | Nassau | New York | 36059 | 754 | 4 |
6722 | 6722 | 2020-03-21 | Nassau | New York | 36059 | 1234 | 7 |
7817 | 7817 | 2020-03-22 | Nassau | New York | 36059 | 1900 | 7 |
9015 | 9015 | 2020-03-23 | Nassau | New York | 36059 | 2442 | 9 |
10322 | 10322 | 2020-03-24 | Nassau | New York | 36059 | 2869 | 9 |
11758 | 11758 | 2020-03-25 | Nassau | New York | 36059 | 3285 | 17 |
13361 | 13361 | 2020-03-26 | Nassau | New York | 36059 | 3914 | 19 |
15095 | 15095 | 2020-03-27 | Nassau | New York | 36059 | 4657 | 27 |
16925 | 16925 | 2020-03-28 | Nassau | New York | 36059 | 5537 | 35 |
18850 | 18850 | 2020-03-29 | Nassau | New York | 36059 | 6445 | 39 |
20889 | 20889 | 2020-03-30 | Nassau | New York | 36059 | 7344 | 48 |
23012 | 23012 | 2020-03-31 | Nassau | New York | 36059 | 8544 | 63 |
25206 | 25206 | 2020-04-01 | Nassau | New York | 36059 | 9555 | 76 |
27466 | 27466 | 2020-04-02 | Nassau | New York | 36059 | 10587 | 95 |
29790 | 29790 | 2020-04-03 | Nassau | New York | 36059 | 12024 | 138 |
32176 | 32176 | 2020-04-04 | Nassau | New York | 36059 | 13346 | 396 |
34607 | 34607 | 2020-04-05 | Nassau | New York | 36059 | 14398 | 396 |
37077 | 37077 | 2020-04-06 | Nassau | New York | 36059 | 15616 | 535 |
39592 | 39592 | 2020-04-07 | Nassau | New York | 36059 | 16610 | 620 |
42149 | 42149 | 2020-04-08 | Nassau | New York | 36059 | 18548 | 701 |
44732 | 44732 | 2020-04-09 | Nassau | New York | 36059 | 20140 | 778 |
47345 | 47345 | 2020-04-10 | Nassau | New York | 36059 | 21512 | 890 |
50000 | 50000 | 2020-04-11 | Nassau | New York | 36059 | 22584 | 965 |
52673 | 52673 | 2020-04-12 | Nassau | New York | 36059 | 23553 | 1030 |
55356 | 55356 | 2020-04-13 | Nassau | New York | 36059 | 24358 | 1109 |
58056 | 58056 | 2020-04-14 | Nassau | New York | 36059 | 25250 | 1217 |
60770 | 60770 | 2020-04-15 | Nassau | New York | 36059 | 26715 | 1286 |
63496 | 63496 | 2020-04-16 | Nassau | New York | 36059 | 27772 | 1356 |
66238 | 66238 | 2020-04-17 | Nassau | New York | 36059 | 28539 | 1356 |
68995 | 68995 | 2020-04-18 | Nassau | New York | 36059 | 29180 | 1356 |
71762 | 71762 | 2020-04-19 | Nassau | New York | 36059 | 30013 | 1577 |
74537 | 74537 | 2020-04-20 | Nassau | New York | 36059 | 30677 | 1638 |
77318 | 77318 | 2020-04-21 | Nassau | New York | 36059 | 31079 | 1717 |
80107 | 80107 | 2020-04-22 | Nassau | New York | 36059 | 31555 | 1764 |
82906 | 82906 | 2020-04-23 | Nassau | New York | 36059 | 32124 | 1813 |
85710 | 85710 | 2020-04-24 | Nassau | New York | 36059 | 32765 | 1867 |
88522 | 88522 | 2020-04-25 | Nassau | New York | 36059 | 33798 | 1917 |
91337 | 91337 | 2020-04-26 | Nassau | New York | 36059 | 34522 | 1962 |
94162 | 94162 | 2020-04-27 | Nassau | New York | 36059 | 34865 | 2003 |
96998 | 96998 | 2020-04-28 | Nassau | New York | 36059 | 35085 | 2039 |
99845 | 99845 | 2020-04-29 | Nassau | New York | 36059 | 35505 | 2077 |
102698 | 102698 | 2020-04-30 | Nassau | New York | 36059 | 35854 | 2111 |
105560 | 105560 | 2020-05-01 | Nassau | New York | 36059 | 36161 | 2140 |
108427 | 108427 | 2020-05-02 | Nassau | New York | 36059 | 36519 | 2167 |
111300 | 111300 | 2020-05-03 | Nassau | New York | 36059 | 36780 | 2194 |
407092 | 407092 | 2020-08-06 | Nassau | New York | 36059 | 43534 | 2194 |
410312 | 410312 | 2020-08-07 | Nassau | New York | 36059 | 43580 | 2194 |
413532 | 413532 | 2020-08-08 | Nassau | New York | 36059 | 43628 | 2194 |
416753 | 416753 | 2020-08-09 | Nassau | New York | 36059 | 43655 | 2195 |
419973 | 419973 | 2020-08-10 | Nassau | New York | 36059 | 43690 | 2195 |
423196 | 423196 | 2020-08-11 | Nassau | New York | 36059 | 43724 | 2195 |
426419 | 426419 | 2020-08-12 | Nassau | New York | 36059 | 43761 | 2195 |
429644 | 429644 | 2020-08-13 | Nassau | New York | 36059 | 43795 | 2195 |
432870 | 432870 | 2020-08-14 | Nassau | New York | 36059 | 43840 | 2195 |
436096 | 436096 | 2020-08-15 | Nassau | New York | 36059 | 43891 | 2195 |
439321 | 439321 | 2020-08-16 | Nassau | New York | 36059 | 43929 | 2195 |
442548 | 442548 | 2020-08-17 | Nassau | New York | 36059 | 43955 | 2195 |
445774 | 445774 | 2020-08-18 | Nassau | New York | 36059 | 44001 | 2195 |
449002 | 449002 | 2020-08-19 | Nassau | New York | 36059 | 44063 | 2195 |
452230 | 452230 | 2020-08-20 | Nassau | New York | 36059 | 44112 | 2195 |
455458 | 455458 | 2020-08-21 | Nassau | New York | 36059 | 44162 | 2195 |
458686 | 458686 | 2020-08-22 | Nassau | New York | 36059 | 44205 | 2196 |
461914 | 461914 | 2020-08-23 | Nassau | New York | 36059 | 44245 | 2196 |
465143 | 465143 | 2020-08-24 | Nassau | New York | 36059 | 44284 | 2196 |
468371 | 468371 | 2020-08-25 | Nassau | New York | 36059 | 44348 | 2196 |
471603 | 471603 | 2020-08-26 | Nassau | New York | 36059 | 44403 | 2196 |
474837 | 474837 | 2020-08-27 | Nassau | New York | 36059 | 44450 | 2196 |
478070 | 478070 | 2020-08-28 | Nassau | New York | 36059 | 44503 | 2197 |
481303 | 481303 | 2020-08-29 | Nassau | New York | 36059 | 44554 | 2197 |
484538 | 484538 | 2020-08-30 | Nassau | New York | 36059 | 44610 | 2198 |
487771 | 487771 | 2020-08-31 | Nassau | New York | 36059 | 44677 | 2198 |
491004 | 491004 | 2020-09-01 | Nassau | New York | 36059 | 44761 | 2198 |
494238 | 494238 | 2020-09-02 | Nassau | New York | 36059 | 44845 | 2198 |
497471 | 497471 | 2020-09-03 | Nassau | New York | 36059 | 44924 | 2198 |
500705 | 500705 | 2020-09-04 | Nassau | New York | 36059 | 45008 | 2198 |
503939 | 503939 | 2020-09-05 | Nassau | New York | 36059 | 45115 | 2198 |
507171 | 507171 | 2020-09-06 | Nassau | New York | 36059 | 45193 | 2198 |
510404 | 510404 | 2020-09-07 | Nassau | New York | 36059 | 45229 | 2198 |
513637 | 513637 | 2020-09-08 | Nassau | New York | 36059 | 45294 | 2199 |
516872 | 516872 | 2020-09-09 | Nassau | New York | 36059 | 45372 | 2199 |
520108 | 520108 | 2020-09-10 | Nassau | New York | 36059 | 45445 | 2199 |
523344 | 523344 | 2020-09-11 | Nassau | New York | 36059 | 45550 | 2199 |
526580 | 526580 | 2020-09-12 | Nassau | New York | 36059 | 45633 | 2200 |
529817 | 529817 | 2020-09-13 | Nassau | New York | 36059 | 45711 | 2200 |
533052 | 533052 | 2020-09-14 | Nassau | New York | 36059 | 45763 | 2200 |
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);