ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Fayette" and fips = 39047 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11870 | 11870 | 2020-03-25 | Fayette | Ohio | 39047 | 1 | 0 |
13477 | 13477 | 2020-03-26 | Fayette | Ohio | 39047 | 1 | 0 |
15214 | 15214 | 2020-03-27 | Fayette | Ohio | 39047 | 1 | 0 |
17056 | 17056 | 2020-03-28 | Fayette | Ohio | 39047 | 1 | 0 |
18990 | 18990 | 2020-03-29 | Fayette | Ohio | 39047 | 1 | 0 |
21034 | 21034 | 2020-03-30 | Fayette | Ohio | 39047 | 1 | 0 |
23166 | 23166 | 2020-03-31 | Fayette | Ohio | 39047 | 1 | 0 |
25361 | 25361 | 2020-04-01 | Fayette | Ohio | 39047 | 1 | 0 |
27627 | 27627 | 2020-04-02 | Fayette | Ohio | 39047 | 1 | 0 |
29956 | 29956 | 2020-04-03 | Fayette | Ohio | 39047 | 1 | 0 |
32345 | 32345 | 2020-04-04 | Fayette | Ohio | 39047 | 2 | 0 |
34778 | 34778 | 2020-04-05 | Fayette | Ohio | 39047 | 2 | 0 |
37247 | 37247 | 2020-04-06 | Fayette | Ohio | 39047 | 2 | 0 |
39764 | 39764 | 2020-04-07 | Fayette | Ohio | 39047 | 2 | 0 |
42322 | 42322 | 2020-04-08 | Fayette | Ohio | 39047 | 4 | 0 |
44907 | 44907 | 2020-04-09 | Fayette | Ohio | 39047 | 5 | 0 |
47522 | 47522 | 2020-04-10 | Fayette | Ohio | 39047 | 5 | 0 |
50177 | 50177 | 2020-04-11 | Fayette | Ohio | 39047 | 7 | 0 |
52850 | 52850 | 2020-04-12 | Fayette | Ohio | 39047 | 9 | 0 |
55534 | 55534 | 2020-04-13 | Fayette | Ohio | 39047 | 10 | 0 |
58235 | 58235 | 2020-04-14 | Fayette | Ohio | 39047 | 12 | 0 |
60949 | 60949 | 2020-04-15 | Fayette | Ohio | 39047 | 12 | 0 |
63675 | 63675 | 2020-04-16 | Fayette | Ohio | 39047 | 12 | 0 |
66418 | 66418 | 2020-04-17 | Fayette | Ohio | 39047 | 12 | 0 |
69175 | 69175 | 2020-04-18 | Fayette | Ohio | 39047 | 13 | 0 |
71942 | 71942 | 2020-04-19 | Fayette | Ohio | 39047 | 13 | 0 |
74717 | 74717 | 2020-04-20 | Fayette | Ohio | 39047 | 13 | 0 |
77498 | 77498 | 2020-04-21 | Fayette | Ohio | 39047 | 13 | 0 |
80288 | 80288 | 2020-04-22 | Fayette | Ohio | 39047 | 13 | 0 |
83087 | 83087 | 2020-04-23 | Fayette | Ohio | 39047 | 13 | 0 |
85891 | 85891 | 2020-04-24 | Fayette | Ohio | 39047 | 13 | 0 |
88705 | 88705 | 2020-04-25 | Fayette | Ohio | 39047 | 13 | 0 |
91521 | 91521 | 2020-04-26 | Fayette | Ohio | 39047 | 13 | 0 |
94347 | 94347 | 2020-04-27 | Fayette | Ohio | 39047 | 14 | 0 |
97184 | 97184 | 2020-04-28 | Fayette | Ohio | 39047 | 15 | 0 |
100033 | 100033 | 2020-04-29 | Fayette | Ohio | 39047 | 15 | 0 |
102886 | 102886 | 2020-04-30 | Fayette | Ohio | 39047 | 15 | 0 |
105749 | 105749 | 2020-05-01 | Fayette | Ohio | 39047 | 16 | 0 |
108616 | 108616 | 2020-05-02 | Fayette | Ohio | 39047 | 17 | 0 |
111490 | 111490 | 2020-05-03 | Fayette | Ohio | 39047 | 20 | 0 |
114371 | 114371 | 2020-05-04 | Fayette | Ohio | 39047 | 20 | 0 |
117252 | 117252 | 2020-05-05 | Fayette | Ohio | 39047 | 21 | 0 |
120213 | 120213 | 2020-05-06 | Fayette | Ohio | 39047 | 21 | 0 |
123190 | 123190 | 2020-05-07 | Fayette | Ohio | 39047 | 23 | 0 |
126173 | 126173 | 2020-05-08 | Fayette | Ohio | 39047 | 23 | 0 |
129162 | 129162 | 2020-05-09 | Fayette | Ohio | 39047 | 27 | 0 |
132151 | 132151 | 2020-05-10 | Fayette | Ohio | 39047 | 27 | 0 |
135142 | 135142 | 2020-05-11 | Fayette | Ohio | 39047 | 27 | 0 |
138132 | 138132 | 2020-05-12 | Fayette | Ohio | 39047 | 27 | 0 |
141128 | 141128 | 2020-05-13 | Fayette | Ohio | 39047 | 27 | 0 |
144123 | 144123 | 2020-05-14 | Fayette | Ohio | 39047 | 27 | 0 |
147124 | 147124 | 2020-05-15 | Fayette | Ohio | 39047 | 28 | 0 |
150131 | 150131 | 2020-05-16 | Fayette | Ohio | 39047 | 30 | 0 |
153142 | 153142 | 2020-05-17 | Fayette | Ohio | 39047 | 31 | 0 |
156159 | 156159 | 2020-05-18 | Fayette | Ohio | 39047 | 32 | 0 |
159179 | 159179 | 2020-05-19 | Fayette | Ohio | 39047 | 31 | 0 |
162206 | 162206 | 2020-05-20 | Fayette | Ohio | 39047 | 32 | 0 |
165235 | 165235 | 2020-05-21 | Fayette | Ohio | 39047 | 33 | 0 |
168271 | 168271 | 2020-05-22 | Fayette | Ohio | 39047 | 34 | 0 |
171310 | 171310 | 2020-05-23 | Fayette | Ohio | 39047 | 34 | 0 |
174352 | 174352 | 2020-05-24 | Fayette | Ohio | 39047 | 34 | 0 |
177396 | 177396 | 2020-05-25 | Fayette | Ohio | 39047 | 37 | 0 |
180439 | 180439 | 2020-05-26 | Fayette | Ohio | 39047 | 37 | 0 |
183488 | 183488 | 2020-05-27 | Fayette | Ohio | 39047 | 37 | 0 |
186545 | 186545 | 2020-05-28 | Fayette | Ohio | 39047 | 39 | 0 |
189605 | 189605 | 2020-05-29 | Fayette | Ohio | 39047 | 40 | 0 |
192669 | 192669 | 2020-05-30 | Fayette | Ohio | 39047 | 40 | 0 |
195739 | 195739 | 2020-05-31 | Fayette | Ohio | 39047 | 40 | 0 |
198812 | 198812 | 2020-06-01 | Fayette | Ohio | 39047 | 40 | 0 |
201887 | 201887 | 2020-06-02 | Fayette | Ohio | 39047 | 40 | 0 |
204964 | 204964 | 2020-06-03 | Fayette | Ohio | 39047 | 40 | 0 |
208045 | 208045 | 2020-06-04 | Fayette | Ohio | 39047 | 41 | 0 |
211127 | 211127 | 2020-06-05 | Fayette | Ohio | 39047 | 41 | 0 |
214213 | 214213 | 2020-06-06 | Fayette | Ohio | 39047 | 42 | 0 |
217303 | 217303 | 2020-06-07 | Fayette | Ohio | 39047 | 42 | 0 |
220395 | 220395 | 2020-06-08 | Fayette | Ohio | 39047 | 43 | 0 |
223490 | 223490 | 2020-06-09 | Fayette | Ohio | 39047 | 43 | 0 |
226590 | 226590 | 2020-06-10 | Fayette | Ohio | 39047 | 43 | 0 |
229694 | 229694 | 2020-06-11 | Fayette | Ohio | 39047 | 44 | 0 |
232799 | 232799 | 2020-06-12 | Fayette | Ohio | 39047 | 44 | 0 |
235904 | 235904 | 2020-06-13 | Fayette | Ohio | 39047 | 44 | 0 |
239012 | 239012 | 2020-06-14 | Fayette | Ohio | 39047 | 45 | 0 |
242121 | 242121 | 2020-06-15 | Fayette | Ohio | 39047 | 45 | 0 |
245233 | 245233 | 2020-06-16 | Fayette | Ohio | 39047 | 45 | 0 |
248346 | 248346 | 2020-06-17 | Fayette | Ohio | 39047 | 45 | 0 |
251461 | 251461 | 2020-06-18 | Fayette | Ohio | 39047 | 45 | 0 |
254576 | 254576 | 2020-06-19 | Fayette | Ohio | 39047 | 45 | 0 |
257701 | 257701 | 2020-06-20 | Fayette | Ohio | 39047 | 45 | 0 |
260828 | 260828 | 2020-06-21 | Fayette | Ohio | 39047 | 45 | 0 |
263956 | 263956 | 2020-06-22 | Fayette | Ohio | 39047 | 45 | 0 |
267084 | 267084 | 2020-06-23 | Fayette | Ohio | 39047 | 45 | 0 |
270218 | 270218 | 2020-06-24 | Fayette | Ohio | 39047 | 45 | 0 |
273357 | 273357 | 2020-06-25 | Fayette | Ohio | 39047 | 45 | 0 |
276504 | 276504 | 2020-06-26 | Fayette | Ohio | 39047 | 45 | 0 |
279652 | 279652 | 2020-06-27 | Fayette | Ohio | 39047 | 45 | 0 |
282798 | 282798 | 2020-06-28 | Fayette | Ohio | 39047 | 45 | 0 |
285943 | 285943 | 2020-06-29 | Fayette | Ohio | 39047 | 46 | 0 |
289093 | 289093 | 2020-06-30 | Fayette | Ohio | 39047 | 46 | 0 |
292245 | 292245 | 2020-07-01 | Fayette | Ohio | 39047 | 46 | 0 |
295400 | 295400 | 2020-07-02 | Fayette | Ohio | 39047 | 46 | 0 |
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);