ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Cattaraugus" and state = "New York" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16902 | 16902 | 2020-03-28 | Cattaraugus | New York | 36009 | 1 | 0 |
18826 | 18826 | 2020-03-29 | Cattaraugus | New York | 36009 | 4 | 0 |
20865 | 20865 | 2020-03-30 | Cattaraugus | New York | 36009 | 6 | 0 |
22988 | 22988 | 2020-03-31 | Cattaraugus | New York | 36009 | 6 | 0 |
25182 | 25182 | 2020-04-01 | Cattaraugus | New York | 36009 | 7 | 0 |
27442 | 27442 | 2020-04-02 | Cattaraugus | New York | 36009 | 8 | 0 |
29766 | 29766 | 2020-04-03 | Cattaraugus | New York | 36009 | 8 | 0 |
32152 | 32152 | 2020-04-04 | Cattaraugus | New York | 36009 | 8 | 0 |
34583 | 34583 | 2020-04-05 | Cattaraugus | New York | 36009 | 10 | 0 |
37053 | 37053 | 2020-04-06 | Cattaraugus | New York | 36009 | 15 | 0 |
39568 | 39568 | 2020-04-07 | Cattaraugus | New York | 36009 | 13 | 0 |
42125 | 42125 | 2020-04-08 | Cattaraugus | New York | 36009 | 15 | 0 |
44708 | 44708 | 2020-04-09 | Cattaraugus | New York | 36009 | 17 | 0 |
47321 | 47321 | 2020-04-10 | Cattaraugus | New York | 36009 | 18 | 0 |
49976 | 49976 | 2020-04-11 | Cattaraugus | New York | 36009 | 19 | 0 |
52649 | 52649 | 2020-04-12 | Cattaraugus | New York | 36009 | 28 | 0 |
55332 | 55332 | 2020-04-13 | Cattaraugus | New York | 36009 | 28 | 0 |
58032 | 58032 | 2020-04-14 | Cattaraugus | New York | 36009 | 32 | 0 |
60746 | 60746 | 2020-04-15 | Cattaraugus | New York | 36009 | 32 | 0 |
63472 | 63472 | 2020-04-16 | Cattaraugus | New York | 36009 | 32 | 0 |
66214 | 66214 | 2020-04-17 | Cattaraugus | New York | 36009 | 34 | 0 |
68971 | 68971 | 2020-04-18 | Cattaraugus | New York | 36009 | 34 | 0 |
71738 | 71738 | 2020-04-19 | Cattaraugus | New York | 36009 | 34 | 0 |
74513 | 74513 | 2020-04-20 | Cattaraugus | New York | 36009 | 34 | 0 |
77294 | 77294 | 2020-04-21 | Cattaraugus | New York | 36009 | 35 | 0 |
80083 | 80083 | 2020-04-22 | Cattaraugus | New York | 36009 | 37 | 0 |
82882 | 82882 | 2020-04-23 | Cattaraugus | New York | 36009 | 37 | 0 |
85686 | 85686 | 2020-04-24 | Cattaraugus | New York | 36009 | 39 | 0 |
88498 | 88498 | 2020-04-25 | Cattaraugus | New York | 36009 | 45 | 1 |
91313 | 91313 | 2020-04-26 | Cattaraugus | New York | 36009 | 45 | 1 |
94138 | 94138 | 2020-04-27 | Cattaraugus | New York | 36009 | 45 | 1 |
96974 | 96974 | 2020-04-28 | Cattaraugus | New York | 36009 | 45 | 1 |
99821 | 99821 | 2020-04-29 | Cattaraugus | New York | 36009 | 47 | 1 |
102674 | 102674 | 2020-04-30 | Cattaraugus | New York | 36009 | 47 | 1 |
105536 | 105536 | 2020-05-01 | Cattaraugus | New York | 36009 | 49 | 1 |
108403 | 108403 | 2020-05-02 | Cattaraugus | New York | 36009 | 50 | 1 |
111276 | 111276 | 2020-05-03 | Cattaraugus | New York | 36009 | 53 | 1 |
114157 | 114157 | 2020-05-04 | Cattaraugus | New York | 36009 | 53 | 1 |
117037 | 117037 | 2020-05-05 | Cattaraugus | New York | 36009 | 53 | 1 |
119998 | 119998 | 2020-05-06 | Cattaraugus | New York | 36009 | 54 | 1 |
122973 | 122973 | 2020-05-07 | Cattaraugus | New York | 36009 | 59 | 1 |
125956 | 125956 | 2020-05-08 | Cattaraugus | New York | 36009 | 59 | 1 |
128945 | 128945 | 2020-05-09 | Cattaraugus | New York | 36009 | 60 | 1 |
131934 | 131934 | 2020-05-10 | Cattaraugus | New York | 36009 | 60 | 1 |
134925 | 134925 | 2020-05-11 | Cattaraugus | New York | 36009 | 61 | 1 |
137915 | 137915 | 2020-05-12 | Cattaraugus | New York | 36009 | 61 | 1 |
140911 | 140911 | 2020-05-13 | Cattaraugus | New York | 36009 | 61 | 1 |
143906 | 143906 | 2020-05-14 | Cattaraugus | New York | 36009 | 64 | 1 |
146907 | 146907 | 2020-05-15 | Cattaraugus | New York | 36009 | 64 | 1 |
149914 | 149914 | 2020-05-16 | Cattaraugus | New York | 36009 | 65 | 1 |
152924 | 152924 | 2020-05-17 | Cattaraugus | New York | 36009 | 65 | 1 |
155941 | 155941 | 2020-05-18 | Cattaraugus | New York | 36009 | 67 | 1 |
158959 | 158959 | 2020-05-19 | Cattaraugus | New York | 36009 | 69 | 1 |
161986 | 161986 | 2020-05-20 | Cattaraugus | New York | 36009 | 70 | 1 |
165015 | 165015 | 2020-05-21 | Cattaraugus | New York | 36009 | 71 | 1 |
168050 | 168050 | 2020-05-22 | Cattaraugus | New York | 36009 | 74 | 1 |
171089 | 171089 | 2020-05-23 | Cattaraugus | New York | 36009 | 78 | 1 |
174131 | 174131 | 2020-05-24 | Cattaraugus | New York | 36009 | 78 | 1 |
177175 | 177175 | 2020-05-25 | Cattaraugus | New York | 36009 | 81 | 2 |
180218 | 180218 | 2020-05-26 | Cattaraugus | New York | 36009 | 81 | 2 |
183266 | 183266 | 2020-05-27 | Cattaraugus | New York | 36009 | 82 | 2 |
186323 | 186323 | 2020-05-28 | Cattaraugus | New York | 36009 | 85 | 2 |
189383 | 189383 | 2020-05-29 | Cattaraugus | New York | 36009 | 86 | 2 |
192447 | 192447 | 2020-05-30 | Cattaraugus | New York | 36009 | 87 | 2 |
195517 | 195517 | 2020-05-31 | Cattaraugus | New York | 36009 | 88 | 3 |
198590 | 198590 | 2020-06-01 | Cattaraugus | New York | 36009 | 89 | 3 |
201664 | 201664 | 2020-06-02 | Cattaraugus | New York | 36009 | 89 | 3 |
204741 | 204741 | 2020-06-03 | Cattaraugus | New York | 36009 | 90 | 3 |
207822 | 207822 | 2020-06-04 | Cattaraugus | New York | 36009 | 91 | 3 |
210904 | 210904 | 2020-06-05 | Cattaraugus | New York | 36009 | 92 | 4 |
213988 | 213988 | 2020-06-06 | Cattaraugus | New York | 36009 | 92 | 4 |
217078 | 217078 | 2020-06-07 | Cattaraugus | New York | 36009 | 94 | 4 |
220170 | 220170 | 2020-06-08 | Cattaraugus | New York | 36009 | 95 | 4 |
223264 | 223264 | 2020-06-09 | Cattaraugus | New York | 36009 | 95 | 4 |
226364 | 226364 | 2020-06-10 | Cattaraugus | New York | 36009 | 96 | 4 |
229468 | 229468 | 2020-06-11 | Cattaraugus | New York | 36009 | 98 | 4 |
232573 | 232573 | 2020-06-12 | Cattaraugus | New York | 36009 | 101 | 4 |
235678 | 235678 | 2020-06-13 | Cattaraugus | New York | 36009 | 101 | 5 |
238786 | 238786 | 2020-06-14 | Cattaraugus | New York | 36009 | 104 | 5 |
241895 | 241895 | 2020-06-15 | Cattaraugus | New York | 36009 | 106 | 5 |
245007 | 245007 | 2020-06-16 | Cattaraugus | New York | 36009 | 107 | 5 |
248120 | 248120 | 2020-06-17 | Cattaraugus | New York | 36009 | 109 | 5 |
251235 | 251235 | 2020-06-18 | Cattaraugus | New York | 36009 | 109 | 5 |
254350 | 254350 | 2020-06-19 | Cattaraugus | New York | 36009 | 109 | 5 |
257473 | 257473 | 2020-06-20 | Cattaraugus | New York | 36009 | 113 | 5 |
260600 | 260600 | 2020-06-21 | Cattaraugus | New York | 36009 | 115 | 5 |
263728 | 263728 | 2020-06-22 | Cattaraugus | New York | 36009 | 115 | 5 |
266856 | 266856 | 2020-06-23 | Cattaraugus | New York | 36009 | 118 | 5 |
269990 | 269990 | 2020-06-24 | Cattaraugus | New York | 36009 | 120 | 5 |
273129 | 273129 | 2020-06-25 | Cattaraugus | New York | 36009 | 121 | 5 |
276275 | 276275 | 2020-06-26 | Cattaraugus | New York | 36009 | 123 | 5 |
279423 | 279423 | 2020-06-27 | Cattaraugus | New York | 36009 | 123 | 5 |
282569 | 282569 | 2020-06-28 | Cattaraugus | New York | 36009 | 123 | 5 |
285714 | 285714 | 2020-06-29 | Cattaraugus | New York | 36009 | 123 | 5 |
288864 | 288864 | 2020-06-30 | Cattaraugus | New York | 36009 | 123 | 5 |
292016 | 292016 | 2020-07-01 | Cattaraugus | New York | 36009 | 123 | 5 |
295171 | 295171 | 2020-07-02 | Cattaraugus | New York | 36009 | 124 | 5 |
298331 | 298331 | 2020-07-03 | Cattaraugus | New York | 36009 | 124 | 5 |
301494 | 301494 | 2020-07-04 | Cattaraugus | New York | 36009 | 127 | 5 |
304657 | 304657 | 2020-07-05 | Cattaraugus | New York | 36009 | 127 | 5 |
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);