ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 36107 and state = "New York" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2170 | 2170 | 2020-03-14 | Tioga | New York | 36107 | 1 | 0 |
2582 | 2582 | 2020-03-15 | Tioga | New York | 36107 | 1 | 0 |
3043 | 3043 | 2020-03-16 | Tioga | New York | 36107 | 1 | 0 |
3561 | 3561 | 2020-03-17 | Tioga | New York | 36107 | 1 | 0 |
4162 | 4162 | 2020-03-18 | Tioga | New York | 36107 | 1 | 0 |
4892 | 4892 | 2020-03-19 | Tioga | New York | 36107 | 1 | 0 |
5743 | 5743 | 2020-03-20 | Tioga | New York | 36107 | 1 | 0 |
6738 | 6738 | 2020-03-21 | Tioga | New York | 36107 | 1 | 0 |
7834 | 7834 | 2020-03-22 | Tioga | New York | 36107 | 1 | 0 |
9034 | 9034 | 2020-03-23 | Tioga | New York | 36107 | 1 | 0 |
10342 | 10342 | 2020-03-24 | Tioga | New York | 36107 | 1 | 0 |
11778 | 11778 | 2020-03-25 | Tioga | New York | 36107 | 1 | 0 |
13381 | 13381 | 2020-03-26 | Tioga | New York | 36107 | 2 | 0 |
15115 | 15115 | 2020-03-27 | Tioga | New York | 36107 | 2 | 0 |
16946 | 16946 | 2020-03-28 | Tioga | New York | 36107 | 4 | 0 |
18871 | 18871 | 2020-03-29 | Tioga | New York | 36107 | 4 | 0 |
20910 | 20910 | 2020-03-30 | Tioga | New York | 36107 | 4 | 0 |
23034 | 23034 | 2020-03-31 | Tioga | New York | 36107 | 7 | 0 |
25228 | 25228 | 2020-04-01 | Tioga | New York | 36107 | 7 | 0 |
27488 | 27488 | 2020-04-02 | Tioga | New York | 36107 | 8 | 0 |
29812 | 29812 | 2020-04-03 | Tioga | New York | 36107 | 8 | 0 |
32198 | 32198 | 2020-04-04 | Tioga | New York | 36107 | 8 | 0 |
34629 | 34629 | 2020-04-05 | Tioga | New York | 36107 | 8 | 0 |
37099 | 37099 | 2020-04-06 | Tioga | New York | 36107 | 9 | 0 |
39614 | 39614 | 2020-04-07 | Tioga | New York | 36107 | 10 | 0 |
42171 | 42171 | 2020-04-08 | Tioga | New York | 36107 | 12 | 0 |
44754 | 44754 | 2020-04-09 | Tioga | New York | 36107 | 17 | 0 |
47367 | 47367 | 2020-04-10 | Tioga | New York | 36107 | 18 | 0 |
50022 | 50022 | 2020-04-11 | Tioga | New York | 36107 | 19 | 0 |
52695 | 52695 | 2020-04-12 | Tioga | New York | 36107 | 19 | 0 |
55378 | 55378 | 2020-04-13 | Tioga | New York | 36107 | 20 | 0 |
58078 | 58078 | 2020-04-14 | Tioga | New York | 36107 | 24 | 0 |
60792 | 60792 | 2020-04-15 | Tioga | New York | 36107 | 25 | 0 |
63518 | 63518 | 2020-04-16 | Tioga | New York | 36107 | 27 | 0 |
66260 | 66260 | 2020-04-17 | Tioga | New York | 36107 | 30 | 0 |
69017 | 69017 | 2020-04-18 | Tioga | New York | 36107 | 32 | 0 |
71784 | 71784 | 2020-04-19 | Tioga | New York | 36107 | 35 | 1 |
74559 | 74559 | 2020-04-20 | Tioga | New York | 36107 | 37 | 1 |
77340 | 77340 | 2020-04-21 | Tioga | New York | 36107 | 37 | 2 |
80129 | 80129 | 2020-04-22 | Tioga | New York | 36107 | 39 | 2 |
82928 | 82928 | 2020-04-23 | Tioga | New York | 36107 | 40 | 2 |
85732 | 85732 | 2020-04-24 | Tioga | New York | 36107 | 40 | 2 |
88544 | 88544 | 2020-04-25 | Tioga | New York | 36107 | 71 | 3 |
91359 | 91359 | 2020-04-26 | Tioga | New York | 36107 | 71 | 3 |
94184 | 94184 | 2020-04-27 | Tioga | New York | 36107 | 71 | 3 |
97020 | 97020 | 2020-04-28 | Tioga | New York | 36107 | 82 | 4 |
99867 | 99867 | 2020-04-29 | Tioga | New York | 36107 | 84 | 5 |
102720 | 102720 | 2020-04-30 | Tioga | New York | 36107 | 88 | 6 |
105582 | 105582 | 2020-05-01 | Tioga | New York | 36107 | 90 | 6 |
108449 | 108449 | 2020-05-02 | Tioga | New York | 36107 | 90 | 6 |
111322 | 111322 | 2020-05-03 | Tioga | New York | 36107 | 90 | 8 |
114203 | 114203 | 2020-05-04 | Tioga | New York | 36107 | 90 | 8 |
117083 | 117083 | 2020-05-05 | Tioga | New York | 36107 | 92 | 8 |
120044 | 120044 | 2020-05-06 | Tioga | New York | 36107 | 96 | 12 |
123019 | 123019 | 2020-05-07 | Tioga | New York | 36107 | 97 | 12 |
126002 | 126002 | 2020-05-08 | Tioga | New York | 36107 | 99 | 12 |
128991 | 128991 | 2020-05-09 | Tioga | New York | 36107 | 104 | 12 |
131980 | 131980 | 2020-05-10 | Tioga | New York | 36107 | 105 | 14 |
134971 | 134971 | 2020-05-11 | Tioga | New York | 36107 | 107 | 14 |
137961 | 137961 | 2020-05-12 | Tioga | New York | 36107 | 107 | 15 |
140957 | 140957 | 2020-05-13 | Tioga | New York | 36107 | 108 | 16 |
143952 | 143952 | 2020-05-14 | Tioga | New York | 36107 | 108 | 16 |
146953 | 146953 | 2020-05-15 | Tioga | New York | 36107 | 110 | 16 |
149960 | 149960 | 2020-05-16 | Tioga | New York | 36107 | 112 | 16 |
152970 | 152970 | 2020-05-17 | Tioga | New York | 36107 | 113 | 16 |
155987 | 155987 | 2020-05-18 | Tioga | New York | 36107 | 113 | 16 |
159005 | 159005 | 2020-05-19 | Tioga | New York | 36107 | 113 | 16 |
162032 | 162032 | 2020-05-20 | Tioga | New York | 36107 | 114 | 16 |
165061 | 165061 | 2020-05-21 | Tioga | New York | 36107 | 117 | 16 |
168096 | 168096 | 2020-05-22 | Tioga | New York | 36107 | 118 | 17 |
171135 | 171135 | 2020-05-23 | Tioga | New York | 36107 | 121 | 18 |
174177 | 174177 | 2020-05-24 | Tioga | New York | 36107 | 122 | 18 |
177221 | 177221 | 2020-05-25 | Tioga | New York | 36107 | 122 | 18 |
180264 | 180264 | 2020-05-26 | Tioga | New York | 36107 | 122 | 18 |
183312 | 183312 | 2020-05-27 | Tioga | New York | 36107 | 124 | 18 |
186369 | 186369 | 2020-05-28 | Tioga | New York | 36107 | 126 | 18 |
189429 | 189429 | 2020-05-29 | Tioga | New York | 36107 | 126 | 17 |
192493 | 192493 | 2020-05-30 | Tioga | New York | 36107 | 128 | 17 |
195563 | 195563 | 2020-05-31 | Tioga | New York | 36107 | 130 | 17 |
198636 | 198636 | 2020-06-01 | Tioga | New York | 36107 | 130 | 17 |
201710 | 201710 | 2020-06-02 | Tioga | New York | 36107 | 131 | 17 |
204787 | 204787 | 2020-06-03 | Tioga | New York | 36107 | 133 | 17 |
207868 | 207868 | 2020-06-04 | Tioga | New York | 36107 | 133 | 17 |
210950 | 210950 | 2020-06-05 | Tioga | New York | 36107 | 134 | 18 |
214034 | 214034 | 2020-06-06 | Tioga | New York | 36107 | 134 | 18 |
217124 | 217124 | 2020-06-07 | Tioga | New York | 36107 | 134 | 18 |
220216 | 220216 | 2020-06-08 | Tioga | New York | 36107 | 134 | 18 |
223310 | 223310 | 2020-06-09 | Tioga | New York | 36107 | 134 | 18 |
226410 | 226410 | 2020-06-10 | Tioga | New York | 36107 | 135 | 18 |
229514 | 229514 | 2020-06-11 | Tioga | New York | 36107 | 135 | 18 |
232619 | 232619 | 2020-06-12 | Tioga | New York | 36107 | 137 | 18 |
235724 | 235724 | 2020-06-13 | Tioga | New York | 36107 | 137 | 18 |
238832 | 238832 | 2020-06-14 | Tioga | New York | 36107 | 139 | 18 |
241941 | 241941 | 2020-06-15 | Tioga | New York | 36107 | 139 | 18 |
245053 | 245053 | 2020-06-16 | Tioga | New York | 36107 | 140 | 18 |
248166 | 248166 | 2020-06-17 | Tioga | New York | 36107 | 140 | 18 |
251281 | 251281 | 2020-06-18 | Tioga | New York | 36107 | 140 | 18 |
254396 | 254396 | 2020-06-19 | Tioga | New York | 36107 | 140 | 18 |
257519 | 257519 | 2020-06-20 | Tioga | New York | 36107 | 140 | 18 |
260646 | 260646 | 2020-06-21 | Tioga | New York | 36107 | 140 | 18 |
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);