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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282593 | 282593 | 2020-06-28 | Nassau | New York | 36059 | 41754 | 2692 |
279447 | 279447 | 2020-06-27 | Nassau | New York | 36059 | 41725 | 2691 |
276299 | 276299 | 2020-06-26 | Nassau | New York | 36059 | 41684 | 2690 |
273153 | 273153 | 2020-06-25 | Nassau | New York | 36059 | 41646 | 2688 |
270014 | 270014 | 2020-06-24 | Nassau | New York | 36059 | 41585 | 2687 |
266880 | 266880 | 2020-06-23 | Nassau | New York | 36059 | 41544 | 2686 |
263752 | 263752 | 2020-06-22 | Nassau | New York | 36059 | 41513 | 2683 |
260624 | 260624 | 2020-06-21 | Nassau | New York | 36059 | 41479 | 2683 |
257497 | 257497 | 2020-06-20 | Nassau | New York | 36059 | 41443 | 2680 |
254374 | 254374 | 2020-06-19 | Nassau | New York | 36059 | 41387 | 2680 |
251259 | 251259 | 2020-06-18 | Nassau | New York | 36059 | 41349 | 2677 |
248144 | 248144 | 2020-06-17 | Nassau | New York | 36059 | 41320 | 2677 |
245031 | 245031 | 2020-06-16 | Nassau | New York | 36059 | 41290 | 2676 |
241919 | 241919 | 2020-06-15 | Nassau | New York | 36059 | 41240 | 2672 |
238810 | 238810 | 2020-06-14 | Nassau | New York | 36059 | 41204 | 2670 |
235702 | 235702 | 2020-06-13 | Nassau | New York | 36059 | 41172 | 2668 |
232597 | 232597 | 2020-06-12 | Nassau | New York | 36059 | 41114 | 2667 |
229492 | 229492 | 2020-06-11 | Nassau | New York | 36059 | 41060 | 2654 |
226388 | 226388 | 2020-06-10 | Nassau | New York | 36059 | 41015 | 2653 |
223288 | 223288 | 2020-06-09 | Nassau | New York | 36059 | 40980 | 2650 |
220194 | 220194 | 2020-06-08 | Nassau | New York | 36059 | 40947 | 2645 |
217102 | 217102 | 2020-06-07 | Nassau | New York | 36059 | 40904 | 2642 |
214012 | 214012 | 2020-06-06 | Nassau | New York | 36059 | 40853 | 2635 |
210928 | 210928 | 2020-06-05 | Nassau | New York | 36059 | 40797 | 2631 |
207846 | 207846 | 2020-06-04 | Nassau | New York | 36059 | 40713 | 2629 |
204765 | 204765 | 2020-06-03 | Nassau | New York | 36059 | 40644 | 2626 |
201688 | 201688 | 2020-06-02 | Nassau | New York | 36059 | 40572 | 2622 |
198614 | 198614 | 2020-06-01 | Nassau | New York | 36059 | 40479 | 2619 |
195541 | 195541 | 2020-05-31 | Nassau | New York | 36059 | 40396 | 2615 |
192471 | 192471 | 2020-05-30 | Nassau | New York | 36059 | 40307 | 2615 |
189407 | 189407 | 2020-05-29 | Nassau | New York | 36059 | 40226 | 2611 |
186347 | 186347 | 2020-05-28 | Nassau | New York | 36059 | 40140 | 2608 |
183290 | 183290 | 2020-05-27 | Nassau | New York | 36059 | 40034 | 2604 |
180242 | 180242 | 2020-05-26 | Nassau | New York | 36059 | 39974 | 2601 |
177199 | 177199 | 2020-05-25 | Nassau | New York | 36059 | 39907 | 2597 |
174155 | 174155 | 2020-05-24 | Nassau | New York | 36059 | 39837 | 2586 |
171113 | 171113 | 2020-05-23 | Nassau | New York | 36059 | 39726 | 2578 |
168074 | 168074 | 2020-05-22 | Nassau | New York | 36059 | 39608 | 2572 |
165039 | 165039 | 2020-05-21 | Nassau | New York | 36059 | 39487 | 2558 |
162010 | 162010 | 2020-05-20 | Nassau | New York | 36059 | 39368 | 2550 |
158983 | 158983 | 2020-05-19 | Nassau | New York | 36059 | 39295 | 2541 |
155965 | 155965 | 2020-05-18 | Nassau | New York | 36059 | 39225 | 2530 |
152948 | 152948 | 2020-05-17 | Nassau | New York | 36059 | 39136 | 2517 |
149938 | 149938 | 2020-05-16 | Nassau | New York | 36059 | 39033 | 2507 |
146931 | 146931 | 2020-05-15 | Nassau | New York | 36059 | 38864 | 2499 |
143930 | 143930 | 2020-05-14 | Nassau | New York | 36059 | 38743 | 2485 |
140935 | 140935 | 2020-05-13 | Nassau | New York | 36059 | 38587 | 2468 |
137939 | 137939 | 2020-05-12 | Nassau | New York | 36059 | 38434 | 2453 |
134949 | 134949 | 2020-05-11 | Nassau | New York | 36059 | 38337 | 2425 |
131958 | 131958 | 2020-05-10 | Nassau | New York | 36059 | 38217 | 2413 |
128969 | 128969 | 2020-05-09 | Nassau | New York | 36059 | 38028 | 2388 |
125980 | 125980 | 2020-05-08 | Nassau | New York | 36059 | 37812 | 2362 |
122997 | 122997 | 2020-05-07 | Nassau | New York | 36059 | 37593 | 2340 |
120022 | 120022 | 2020-05-06 | Nassau | New York | 36059 | 37350 | 2325 |
117061 | 117061 | 2020-05-05 | Nassau | New York | 36059 | 37152 | 2250 |
114181 | 114181 | 2020-05-04 | Nassau | New York | 36059 | 36965 | 2221 |
111300 | 111300 | 2020-05-03 | Nassau | New York | 36059 | 36780 | 2194 |
108427 | 108427 | 2020-05-02 | Nassau | New York | 36059 | 36519 | 2167 |
105560 | 105560 | 2020-05-01 | Nassau | New York | 36059 | 36161 | 2140 |
102698 | 102698 | 2020-04-30 | Nassau | New York | 36059 | 35854 | 2111 |
99845 | 99845 | 2020-04-29 | Nassau | New York | 36059 | 35505 | 2077 |
96998 | 96998 | 2020-04-28 | Nassau | New York | 36059 | 35085 | 2039 |
94162 | 94162 | 2020-04-27 | Nassau | New York | 36059 | 34865 | 2003 |
91337 | 91337 | 2020-04-26 | Nassau | New York | 36059 | 34522 | 1962 |
88522 | 88522 | 2020-04-25 | Nassau | New York | 36059 | 33798 | 1917 |
85710 | 85710 | 2020-04-24 | Nassau | New York | 36059 | 32765 | 1867 |
82906 | 82906 | 2020-04-23 | Nassau | New York | 36059 | 32124 | 1813 |
80107 | 80107 | 2020-04-22 | Nassau | New York | 36059 | 31555 | 1764 |
77318 | 77318 | 2020-04-21 | Nassau | New York | 36059 | 31079 | 1717 |
74537 | 74537 | 2020-04-20 | Nassau | New York | 36059 | 30677 | 1638 |
71762 | 71762 | 2020-04-19 | Nassau | New York | 36059 | 30013 | 1577 |
68995 | 68995 | 2020-04-18 | Nassau | New York | 36059 | 29180 | 1356 |
66238 | 66238 | 2020-04-17 | Nassau | New York | 36059 | 28539 | 1356 |
63496 | 63496 | 2020-04-16 | Nassau | New York | 36059 | 27772 | 1356 |
60770 | 60770 | 2020-04-15 | Nassau | New York | 36059 | 26715 | 1286 |
58056 | 58056 | 2020-04-14 | Nassau | New York | 36059 | 25250 | 1217 |
55356 | 55356 | 2020-04-13 | Nassau | New York | 36059 | 24358 | 1109 |
52673 | 52673 | 2020-04-12 | Nassau | New York | 36059 | 23553 | 1030 |
50000 | 50000 | 2020-04-11 | Nassau | New York | 36059 | 22584 | 965 |
47345 | 47345 | 2020-04-10 | Nassau | New York | 36059 | 21512 | 890 |
44732 | 44732 | 2020-04-09 | Nassau | New York | 36059 | 20140 | 778 |
42149 | 42149 | 2020-04-08 | Nassau | New York | 36059 | 18548 | 701 |
39592 | 39592 | 2020-04-07 | Nassau | New York | 36059 | 16610 | 620 |
37077 | 37077 | 2020-04-06 | Nassau | New York | 36059 | 15616 | 535 |
34607 | 34607 | 2020-04-05 | Nassau | New York | 36059 | 14398 | 396 |
32176 | 32176 | 2020-04-04 | Nassau | New York | 36059 | 13346 | 396 |
29790 | 29790 | 2020-04-03 | Nassau | New York | 36059 | 12024 | 138 |
27466 | 27466 | 2020-04-02 | Nassau | New York | 36059 | 10587 | 95 |
25206 | 25206 | 2020-04-01 | Nassau | New York | 36059 | 9555 | 76 |
23012 | 23012 | 2020-03-31 | Nassau | New York | 36059 | 8544 | 63 |
20889 | 20889 | 2020-03-30 | Nassau | New York | 36059 | 7344 | 48 |
18850 | 18850 | 2020-03-29 | Nassau | New York | 36059 | 6445 | 39 |
16925 | 16925 | 2020-03-28 | Nassau | New York | 36059 | 5537 | 35 |
15095 | 15095 | 2020-03-27 | Nassau | New York | 36059 | 4657 | 27 |
13361 | 13361 | 2020-03-26 | Nassau | New York | 36059 | 3914 | 19 |
11758 | 11758 | 2020-03-25 | Nassau | New York | 36059 | 3285 | 17 |
10322 | 10322 | 2020-03-24 | Nassau | New York | 36059 | 2869 | 9 |
9015 | 9015 | 2020-03-23 | Nassau | New York | 36059 | 2442 | 9 |
7817 | 7817 | 2020-03-22 | Nassau | New York | 36059 | 1900 | 7 |
6722 | 6722 | 2020-03-21 | Nassau | New York | 36059 | 1234 | 7 |
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);