ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 36059 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, 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 |
114181 | 114181 | 2020-05-04 | Nassau | New York | 36059 | 36965 | 2221 |
117061 | 117061 | 2020-05-05 | Nassau | New York | 36059 | 37152 | 2250 |
120022 | 120022 | 2020-05-06 | Nassau | New York | 36059 | 37350 | 2325 |
122997 | 122997 | 2020-05-07 | Nassau | New York | 36059 | 37593 | 2340 |
125980 | 125980 | 2020-05-08 | Nassau | New York | 36059 | 37812 | 2362 |
128969 | 128969 | 2020-05-09 | Nassau | New York | 36059 | 38028 | 2388 |
131958 | 131958 | 2020-05-10 | Nassau | New York | 36059 | 38217 | 2413 |
134949 | 134949 | 2020-05-11 | Nassau | New York | 36059 | 38337 | 2425 |
137939 | 137939 | 2020-05-12 | Nassau | New York | 36059 | 38434 | 2453 |
140935 | 140935 | 2020-05-13 | Nassau | New York | 36059 | 38587 | 2468 |
143930 | 143930 | 2020-05-14 | Nassau | New York | 36059 | 38743 | 2485 |
146931 | 146931 | 2020-05-15 | Nassau | New York | 36059 | 38864 | 2499 |
149938 | 149938 | 2020-05-16 | Nassau | New York | 36059 | 39033 | 2507 |
152948 | 152948 | 2020-05-17 | Nassau | New York | 36059 | 39136 | 2517 |
155965 | 155965 | 2020-05-18 | Nassau | New York | 36059 | 39225 | 2530 |
158983 | 158983 | 2020-05-19 | Nassau | New York | 36059 | 39295 | 2541 |
162010 | 162010 | 2020-05-20 | Nassau | New York | 36059 | 39368 | 2550 |
165039 | 165039 | 2020-05-21 | Nassau | New York | 36059 | 39487 | 2558 |
168074 | 168074 | 2020-05-22 | Nassau | New York | 36059 | 39608 | 2572 |
171113 | 171113 | 2020-05-23 | Nassau | New York | 36059 | 39726 | 2578 |
174155 | 174155 | 2020-05-24 | Nassau | New York | 36059 | 39837 | 2586 |
177199 | 177199 | 2020-05-25 | Nassau | New York | 36059 | 39907 | 2597 |
180242 | 180242 | 2020-05-26 | Nassau | New York | 36059 | 39974 | 2601 |
183290 | 183290 | 2020-05-27 | Nassau | New York | 36059 | 40034 | 2604 |
186347 | 186347 | 2020-05-28 | Nassau | New York | 36059 | 40140 | 2608 |
189407 | 189407 | 2020-05-29 | Nassau | New York | 36059 | 40226 | 2611 |
192471 | 192471 | 2020-05-30 | Nassau | New York | 36059 | 40307 | 2615 |
195541 | 195541 | 2020-05-31 | Nassau | New York | 36059 | 40396 | 2615 |
198614 | 198614 | 2020-06-01 | Nassau | New York | 36059 | 40479 | 2619 |
201688 | 201688 | 2020-06-02 | Nassau | New York | 36059 | 40572 | 2622 |
204765 | 204765 | 2020-06-03 | Nassau | New York | 36059 | 40644 | 2626 |
207846 | 207846 | 2020-06-04 | Nassau | New York | 36059 | 40713 | 2629 |
210928 | 210928 | 2020-06-05 | Nassau | New York | 36059 | 40797 | 2631 |
214012 | 214012 | 2020-06-06 | Nassau | New York | 36059 | 40853 | 2635 |
217102 | 217102 | 2020-06-07 | Nassau | New York | 36059 | 40904 | 2642 |
220194 | 220194 | 2020-06-08 | Nassau | New York | 36059 | 40947 | 2645 |
223288 | 223288 | 2020-06-09 | Nassau | New York | 36059 | 40980 | 2650 |
226388 | 226388 | 2020-06-10 | Nassau | New York | 36059 | 41015 | 2653 |
229492 | 229492 | 2020-06-11 | Nassau | New York | 36059 | 41060 | 2654 |
232597 | 232597 | 2020-06-12 | Nassau | New York | 36059 | 41114 | 2667 |
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);