ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Chautauqua" and state = "New York" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11737 | 11737 | 2020-03-25 | Chautauqua | New York | 36013 | 1 | 0 |
13340 | 13340 | 2020-03-26 | Chautauqua | New York | 36013 | 1 | 0 |
15074 | 15074 | 2020-03-27 | Chautauqua | New York | 36013 | 1 | 0 |
16904 | 16904 | 2020-03-28 | Chautauqua | New York | 36013 | 5 | 0 |
18828 | 18828 | 2020-03-29 | Chautauqua | New York | 36013 | 5 | 0 |
20867 | 20867 | 2020-03-30 | Chautauqua | New York | 36013 | 5 | 0 |
22990 | 22990 | 2020-03-31 | Chautauqua | New York | 36013 | 6 | 0 |
25184 | 25184 | 2020-04-01 | Chautauqua | New York | 36013 | 10 | 1 |
27444 | 27444 | 2020-04-02 | Chautauqua | New York | 36013 | 10 | 1 |
29768 | 29768 | 2020-04-03 | Chautauqua | New York | 36013 | 10 | 1 |
32154 | 32154 | 2020-04-04 | Chautauqua | New York | 36013 | 12 | 0 |
34585 | 34585 | 2020-04-05 | Chautauqua | New York | 36013 | 12 | 0 |
37055 | 37055 | 2020-04-06 | Chautauqua | New York | 36013 | 15 | 0 |
39570 | 39570 | 2020-04-07 | Chautauqua | New York | 36013 | 16 | 0 |
42127 | 42127 | 2020-04-08 | Chautauqua | New York | 36013 | 17 | 1 |
44710 | 44710 | 2020-04-09 | Chautauqua | New York | 36013 | 18 | 1 |
47323 | 47323 | 2020-04-10 | Chautauqua | New York | 36013 | 20 | 1 |
49978 | 49978 | 2020-04-11 | Chautauqua | New York | 36013 | 21 | 1 |
52651 | 52651 | 2020-04-12 | Chautauqua | New York | 36013 | 22 | 1 |
55334 | 55334 | 2020-04-13 | Chautauqua | New York | 36013 | 23 | 1 |
58034 | 58034 | 2020-04-14 | Chautauqua | New York | 36013 | 23 | 1 |
60748 | 60748 | 2020-04-15 | Chautauqua | New York | 36013 | 24 | 1 |
63474 | 63474 | 2020-04-16 | Chautauqua | New York | 36013 | 24 | 1 |
66216 | 66216 | 2020-04-17 | Chautauqua | New York | 36013 | 25 | 1 |
68973 | 68973 | 2020-04-18 | Chautauqua | New York | 36013 | 25 | 1 |
71740 | 71740 | 2020-04-19 | Chautauqua | New York | 36013 | 25 | 1 |
74515 | 74515 | 2020-04-20 | Chautauqua | New York | 36013 | 25 | 1 |
77296 | 77296 | 2020-04-21 | Chautauqua | New York | 36013 | 25 | 1 |
80085 | 80085 | 2020-04-22 | Chautauqua | New York | 36013 | 26 | 1 |
82884 | 82884 | 2020-04-23 | Chautauqua | New York | 36013 | 26 | 1 |
85688 | 85688 | 2020-04-24 | Chautauqua | New York | 36013 | 27 | 1 |
88500 | 88500 | 2020-04-25 | Chautauqua | New York | 36013 | 27 | 1 |
91315 | 91315 | 2020-04-26 | Chautauqua | New York | 36013 | 29 | 1 |
94140 | 94140 | 2020-04-27 | Chautauqua | New York | 36013 | 30 | 1 |
96976 | 96976 | 2020-04-28 | Chautauqua | New York | 36013 | 30 | 1 |
99823 | 99823 | 2020-04-29 | Chautauqua | New York | 36013 | 31 | 1 |
102676 | 102676 | 2020-04-30 | Chautauqua | New York | 36013 | 33 | 1 |
105538 | 105538 | 2020-05-01 | Chautauqua | New York | 36013 | 35 | 1 |
108405 | 108405 | 2020-05-02 | Chautauqua | New York | 36013 | 35 | 1 |
111278 | 111278 | 2020-05-03 | Chautauqua | New York | 36013 | 36 | 2 |
114159 | 114159 | 2020-05-04 | Chautauqua | New York | 36013 | 37 | 2 |
117039 | 117039 | 2020-05-05 | Chautauqua | New York | 36013 | 37 | 2 |
120000 | 120000 | 2020-05-06 | Chautauqua | New York | 36013 | 38 | 2 |
122975 | 122975 | 2020-05-07 | Chautauqua | New York | 36013 | 40 | 2 |
125958 | 125958 | 2020-05-08 | Chautauqua | New York | 36013 | 40 | 2 |
128947 | 128947 | 2020-05-09 | Chautauqua | New York | 36013 | 40 | 2 |
131936 | 131936 | 2020-05-10 | Chautauqua | New York | 36013 | 41 | 2 |
134927 | 134927 | 2020-05-11 | Chautauqua | New York | 36013 | 41 | 2 |
137917 | 137917 | 2020-05-12 | Chautauqua | New York | 36013 | 42 | 3 |
140913 | 140913 | 2020-05-13 | Chautauqua | New York | 36013 | 43 | 3 |
143908 | 143908 | 2020-05-14 | Chautauqua | New York | 36013 | 44 | 3 |
146909 | 146909 | 2020-05-15 | Chautauqua | New York | 36013 | 45 | 3 |
149916 | 149916 | 2020-05-16 | Chautauqua | New York | 36013 | 48 | 3 |
152926 | 152926 | 2020-05-17 | Chautauqua | New York | 36013 | 48 | 3 |
155943 | 155943 | 2020-05-18 | Chautauqua | New York | 36013 | 49 | 3 |
158961 | 158961 | 2020-05-19 | Chautauqua | New York | 36013 | 49 | 3 |
161988 | 161988 | 2020-05-20 | Chautauqua | New York | 36013 | 50 | 3 |
165017 | 165017 | 2020-05-21 | Chautauqua | New York | 36013 | 58 | 3 |
168052 | 168052 | 2020-05-22 | Chautauqua | New York | 36013 | 63 | 3 |
171091 | 171091 | 2020-05-23 | Chautauqua | New York | 36013 | 72 | 3 |
174133 | 174133 | 2020-05-24 | Chautauqua | New York | 36013 | 75 | 3 |
177177 | 177177 | 2020-05-25 | Chautauqua | New York | 36013 | 75 | 3 |
180220 | 180220 | 2020-05-26 | Chautauqua | New York | 36013 | 77 | 3 |
183268 | 183268 | 2020-05-27 | Chautauqua | New York | 36013 | 78 | 3 |
186325 | 186325 | 2020-05-28 | Chautauqua | New York | 36013 | 81 | 3 |
189385 | 189385 | 2020-05-29 | Chautauqua | New York | 36013 | 82 | 3 |
192449 | 192449 | 2020-05-30 | Chautauqua | New York | 36013 | 83 | 3 |
195519 | 195519 | 2020-05-31 | Chautauqua | New York | 36013 | 84 | 3 |
198592 | 198592 | 2020-06-01 | Chautauqua | New York | 36013 | 85 | 3 |
201666 | 201666 | 2020-06-02 | Chautauqua | New York | 36013 | 86 | 3 |
204743 | 204743 | 2020-06-03 | Chautauqua | New York | 36013 | 89 | 3 |
207824 | 207824 | 2020-06-04 | Chautauqua | New York | 36013 | 95 | 4 |
210906 | 210906 | 2020-06-05 | Chautauqua | New York | 36013 | 97 | 4 |
213990 | 213990 | 2020-06-06 | Chautauqua | New York | 36013 | 99 | 4 |
217080 | 217080 | 2020-06-07 | Chautauqua | New York | 36013 | 101 | 4 |
220172 | 220172 | 2020-06-08 | Chautauqua | New York | 36013 | 101 | 4 |
223266 | 223266 | 2020-06-09 | Chautauqua | New York | 36013 | 103 | 4 |
226366 | 226366 | 2020-06-10 | Chautauqua | New York | 36013 | 105 | 4 |
229470 | 229470 | 2020-06-11 | Chautauqua | New York | 36013 | 106 | 4 |
232575 | 232575 | 2020-06-12 | Chautauqua | New York | 36013 | 106 | 4 |
235680 | 235680 | 2020-06-13 | Chautauqua | New York | 36013 | 106 | 4 |
238788 | 238788 | 2020-06-14 | Chautauqua | New York | 36013 | 107 | 4 |
241897 | 241897 | 2020-06-15 | Chautauqua | New York | 36013 | 107 | 4 |
245009 | 245009 | 2020-06-16 | Chautauqua | New York | 36013 | 108 | 4 |
248122 | 248122 | 2020-06-17 | Chautauqua | New York | 36013 | 108 | 4 |
251237 | 251237 | 2020-06-18 | Chautauqua | New York | 36013 | 110 | 4 |
254352 | 254352 | 2020-06-19 | Chautauqua | New York | 36013 | 112 | 4 |
257475 | 257475 | 2020-06-20 | Chautauqua | New York | 36013 | 115 | 4 |
260602 | 260602 | 2020-06-21 | Chautauqua | New York | 36013 | 116 | 4 |
263730 | 263730 | 2020-06-22 | Chautauqua | New York | 36013 | 116 | 4 |
266858 | 266858 | 2020-06-23 | Chautauqua | New York | 36013 | 116 | 4 |
269992 | 269992 | 2020-06-24 | Chautauqua | New York | 36013 | 118 | 4 |
273131 | 273131 | 2020-06-25 | Chautauqua | New York | 36013 | 121 | 4 |
276277 | 276277 | 2020-06-26 | Chautauqua | New York | 36013 | 122 | 4 |
279425 | 279425 | 2020-06-27 | Chautauqua | New York | 36013 | 123 | 4 |
282571 | 282571 | 2020-06-28 | Chautauqua | New York | 36013 | 123 | 4 |
285716 | 285716 | 2020-06-29 | Chautauqua | New York | 36013 | 123 | 4 |
288866 | 288866 | 2020-06-30 | Chautauqua | New York | 36013 | 127 | 4 |
292018 | 292018 | 2020-07-01 | Chautauqua | New York | 36013 | 127 | 4 |
295173 | 295173 | 2020-07-02 | Chautauqua | New York | 36013 | 127 | 4 |
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);