ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36121 and state = "New York" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- …
state 1
- New York · 788 ✖
fips 1
- 36121 · 788 ✖
county 1
- Wyoming 788
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3565 | 3565 | 2020-03-17 | Wyoming | New York | 36121 | 1 | 0 |
4168 | 4168 | 2020-03-18 | Wyoming | New York | 36121 | 1 | 0 |
4899 | 4899 | 2020-03-19 | Wyoming | New York | 36121 | 2 | 0 |
5750 | 5750 | 2020-03-20 | Wyoming | New York | 36121 | 2 | 0 |
6745 | 6745 | 2020-03-21 | Wyoming | New York | 36121 | 2 | 0 |
7841 | 7841 | 2020-03-22 | Wyoming | New York | 36121 | 2 | 0 |
9041 | 9041 | 2020-03-23 | Wyoming | New York | 36121 | 4 | 0 |
10349 | 10349 | 2020-03-24 | Wyoming | New York | 36121 | 4 | 0 |
11785 | 11785 | 2020-03-25 | Wyoming | New York | 36121 | 4 | 0 |
13388 | 13388 | 2020-03-26 | Wyoming | New York | 36121 | 7 | 0 |
15122 | 15122 | 2020-03-27 | Wyoming | New York | 36121 | 7 | 0 |
16953 | 16953 | 2020-03-28 | Wyoming | New York | 36121 | 7 | 0 |
18879 | 18879 | 2020-03-29 | Wyoming | New York | 36121 | 8 | 0 |
20918 | 20918 | 2020-03-30 | Wyoming | New York | 36121 | 8 | 0 |
23042 | 23042 | 2020-03-31 | Wyoming | New York | 36121 | 9 | 1 |
25236 | 25236 | 2020-04-01 | Wyoming | New York | 36121 | 10 | 1 |
27496 | 27496 | 2020-04-02 | Wyoming | New York | 36121 | 15 | 1 |
29820 | 29820 | 2020-04-03 | Wyoming | New York | 36121 | 15 | 1 |
32206 | 32206 | 2020-04-04 | Wyoming | New York | 36121 | 18 | 1 |
34637 | 34637 | 2020-04-05 | Wyoming | New York | 36121 | 22 | 1 |
37106 | 37106 | 2020-04-06 | Wyoming | New York | 36121 | 23 | 1 |
39621 | 39621 | 2020-04-07 | Wyoming | New York | 36121 | 23 | 1 |
42178 | 42178 | 2020-04-08 | Wyoming | New York | 36121 | 27 | 0 |
44761 | 44761 | 2020-04-09 | Wyoming | New York | 36121 | 29 | 0 |
47374 | 47374 | 2020-04-10 | Wyoming | New York | 36121 | 30 | 0 |
50029 | 50029 | 2020-04-11 | Wyoming | New York | 36121 | 31 | 0 |
52702 | 52702 | 2020-04-12 | Wyoming | New York | 36121 | 31 | 0 |
55385 | 55385 | 2020-04-13 | Wyoming | New York | 36121 | 31 | 3 |
58085 | 58085 | 2020-04-14 | Wyoming | New York | 36121 | 32 | 3 |
60799 | 60799 | 2020-04-15 | Wyoming | New York | 36121 | 34 | 3 |
63525 | 63525 | 2020-04-16 | Wyoming | New York | 36121 | 34 | 3 |
66268 | 66268 | 2020-04-17 | Wyoming | New York | 36121 | 35 | 3 |
69025 | 69025 | 2020-04-18 | Wyoming | New York | 36121 | 36 | 3 |
71791 | 71791 | 2020-04-19 | Wyoming | New York | 36121 | 36 | 3 |
74566 | 74566 | 2020-04-20 | Wyoming | New York | 36121 | 36 | 3 |
77347 | 77347 | 2020-04-21 | Wyoming | New York | 36121 | 36 | 3 |
80136 | 80136 | 2020-04-22 | Wyoming | New York | 36121 | 40 | 3 |
82935 | 82935 | 2020-04-23 | Wyoming | New York | 36121 | 41 | 3 |
85739 | 85739 | 2020-04-24 | Wyoming | New York | 36121 | 43 | 3 |
88551 | 88551 | 2020-04-25 | Wyoming | New York | 36121 | 57 | 3 |
91366 | 91366 | 2020-04-26 | Wyoming | New York | 36121 | 59 | 3 |
94191 | 94191 | 2020-04-27 | Wyoming | New York | 36121 | 63 | 3 |
97027 | 97027 | 2020-04-28 | Wyoming | New York | 36121 | 63 | 3 |
99874 | 99874 | 2020-04-29 | Wyoming | New York | 36121 | 65 | 3 |
102727 | 102727 | 2020-04-30 | Wyoming | New York | 36121 | 65 | 3 |
105589 | 105589 | 2020-05-01 | Wyoming | New York | 36121 | 68 | 3 |
108456 | 108456 | 2020-05-02 | Wyoming | New York | 36121 | 69 | 3 |
111329 | 111329 | 2020-05-03 | Wyoming | New York | 36121 | 69 | 3 |
114210 | 114210 | 2020-05-04 | Wyoming | New York | 36121 | 69 | 3 |
117090 | 117090 | 2020-05-05 | Wyoming | New York | 36121 | 70 | 3 |
120051 | 120051 | 2020-05-06 | Wyoming | New York | 36121 | 70 | 3 |
123026 | 123026 | 2020-05-07 | Wyoming | New York | 36121 | 71 | 3 |
126009 | 126009 | 2020-05-08 | Wyoming | New York | 36121 | 73 | 3 |
128998 | 128998 | 2020-05-09 | Wyoming | New York | 36121 | 75 | 3 |
131987 | 131987 | 2020-05-10 | Wyoming | New York | 36121 | 77 | 3 |
134978 | 134978 | 2020-05-11 | Wyoming | New York | 36121 | 77 | 3 |
137968 | 137968 | 2020-05-12 | Wyoming | New York | 36121 | 77 | 3 |
140964 | 140964 | 2020-05-13 | Wyoming | New York | 36121 | 77 | 3 |
143959 | 143959 | 2020-05-14 | Wyoming | New York | 36121 | 77 | 3 |
146960 | 146960 | 2020-05-15 | Wyoming | New York | 36121 | 77 | 3 |
149967 | 149967 | 2020-05-16 | Wyoming | New York | 36121 | 78 | 3 |
152977 | 152977 | 2020-05-17 | Wyoming | New York | 36121 | 78 | 3 |
155994 | 155994 | 2020-05-18 | Wyoming | New York | 36121 | 79 | 3 |
159012 | 159012 | 2020-05-19 | Wyoming | New York | 36121 | 79 | 3 |
162039 | 162039 | 2020-05-20 | Wyoming | New York | 36121 | 79 | 3 |
165068 | 165068 | 2020-05-21 | Wyoming | New York | 36121 | 79 | 3 |
168103 | 168103 | 2020-05-22 | Wyoming | New York | 36121 | 79 | 3 |
171142 | 171142 | 2020-05-23 | Wyoming | New York | 36121 | 80 | 3 |
174184 | 174184 | 2020-05-24 | Wyoming | New York | 36121 | 81 | 3 |
177228 | 177228 | 2020-05-25 | Wyoming | New York | 36121 | 82 | 3 |
180271 | 180271 | 2020-05-26 | Wyoming | New York | 36121 | 82 | 3 |
183319 | 183319 | 2020-05-27 | Wyoming | New York | 36121 | 82 | 3 |
186376 | 186376 | 2020-05-28 | Wyoming | New York | 36121 | 82 | 3 |
189436 | 189436 | 2020-05-29 | Wyoming | New York | 36121 | 82 | 3 |
192500 | 192500 | 2020-05-30 | Wyoming | New York | 36121 | 84 | 3 |
195570 | 195570 | 2020-05-31 | Wyoming | New York | 36121 | 86 | 3 |
198643 | 198643 | 2020-06-01 | Wyoming | New York | 36121 | 86 | 3 |
201717 | 201717 | 2020-06-02 | Wyoming | New York | 36121 | 86 | 3 |
204794 | 204794 | 2020-06-03 | Wyoming | New York | 36121 | 87 | 3 |
207875 | 207875 | 2020-06-04 | Wyoming | New York | 36121 | 87 | 3 |
210957 | 210957 | 2020-06-05 | Wyoming | New York | 36121 | 88 | 3 |
214041 | 214041 | 2020-06-06 | Wyoming | New York | 36121 | 89 | 3 |
217131 | 217131 | 2020-06-07 | Wyoming | New York | 36121 | 89 | 3 |
220223 | 220223 | 2020-06-08 | Wyoming | New York | 36121 | 90 | 3 |
223317 | 223317 | 2020-06-09 | Wyoming | New York | 36121 | 91 | 3 |
226417 | 226417 | 2020-06-10 | Wyoming | New York | 36121 | 91 | 3 |
229521 | 229521 | 2020-06-11 | Wyoming | New York | 36121 | 91 | 3 |
232626 | 232626 | 2020-06-12 | Wyoming | New York | 36121 | 91 | 3 |
235731 | 235731 | 2020-06-13 | Wyoming | New York | 36121 | 91 | 3 |
238839 | 238839 | 2020-06-14 | Wyoming | New York | 36121 | 92 | 3 |
241948 | 241948 | 2020-06-15 | Wyoming | New York | 36121 | 92 | 3 |
245060 | 245060 | 2020-06-16 | Wyoming | New York | 36121 | 93 | 3 |
248173 | 248173 | 2020-06-17 | Wyoming | New York | 36121 | 93 | 3 |
251288 | 251288 | 2020-06-18 | Wyoming | New York | 36121 | 93 | 3 |
254403 | 254403 | 2020-06-19 | Wyoming | New York | 36121 | 93 | 3 |
257526 | 257526 | 2020-06-20 | Wyoming | New York | 36121 | 93 | 3 |
260653 | 260653 | 2020-06-21 | Wyoming | New York | 36121 | 93 | 3 |
263781 | 263781 | 2020-06-22 | Wyoming | New York | 36121 | 93 | 3 |
266909 | 266909 | 2020-06-23 | Wyoming | New York | 36121 | 93 | 3 |
270043 | 270043 | 2020-06-24 | Wyoming | New York | 36121 | 93 | 3 |
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);