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 = 48149 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12140 | 12140 | 2020-03-25 | Fayette | Texas | 48149 | 1 | 0 |
13769 | 13769 | 2020-03-26 | Fayette | Texas | 48149 | 1 | 0 |
15523 | 15523 | 2020-03-27 | Fayette | Texas | 48149 | 1 | 0 |
17392 | 17392 | 2020-03-28 | Fayette | Texas | 48149 | 1 | 0 |
19344 | 19344 | 2020-03-29 | Fayette | Texas | 48149 | 1 | 0 |
21403 | 21403 | 2020-03-30 | Fayette | Texas | 48149 | 2 | 0 |
23542 | 23542 | 2020-03-31 | Fayette | Texas | 48149 | 2 | 0 |
25750 | 25750 | 2020-04-01 | Fayette | Texas | 48149 | 4 | 0 |
28031 | 28031 | 2020-04-02 | Fayette | Texas | 48149 | 4 | 0 |
30366 | 30366 | 2020-04-03 | Fayette | Texas | 48149 | 10 | 0 |
32759 | 32759 | 2020-04-04 | Fayette | Texas | 48149 | 11 | 0 |
35197 | 35197 | 2020-04-05 | Fayette | Texas | 48149 | 11 | 0 |
37673 | 37673 | 2020-04-06 | Fayette | Texas | 48149 | 16 | 0 |
40198 | 40198 | 2020-04-07 | Fayette | Texas | 48149 | 16 | 0 |
42763 | 42763 | 2020-04-08 | Fayette | Texas | 48149 | 16 | 0 |
45352 | 45352 | 2020-04-09 | Fayette | Texas | 48149 | 17 | 0 |
47972 | 47972 | 2020-04-10 | Fayette | Texas | 48149 | 17 | 0 |
50630 | 50630 | 2020-04-11 | Fayette | Texas | 48149 | 17 | 0 |
53305 | 53305 | 2020-04-12 | Fayette | Texas | 48149 | 17 | 0 |
55993 | 55993 | 2020-04-13 | Fayette | Texas | 48149 | 17 | 0 |
58698 | 58698 | 2020-04-14 | Fayette | Texas | 48149 | 17 | 0 |
61415 | 61415 | 2020-04-15 | Fayette | Texas | 48149 | 17 | 0 |
64142 | 64142 | 2020-04-16 | Fayette | Texas | 48149 | 14 | 0 |
66889 | 66889 | 2020-04-17 | Fayette | Texas | 48149 | 15 | 0 |
69649 | 69649 | 2020-04-18 | Fayette | Texas | 48149 | 15 | 0 |
72417 | 72417 | 2020-04-19 | Fayette | Texas | 48149 | 15 | 0 |
75192 | 75192 | 2020-04-20 | Fayette | Texas | 48149 | 15 | 0 |
77974 | 77974 | 2020-04-21 | Fayette | Texas | 48149 | 14 | 0 |
80765 | 80765 | 2020-04-22 | Fayette | Texas | 48149 | 15 | 0 |
83565 | 83565 | 2020-04-23 | Fayette | Texas | 48149 | 15 | 0 |
86370 | 86370 | 2020-04-24 | Fayette | Texas | 48149 | 15 | 1 |
89185 | 89185 | 2020-04-25 | Fayette | Texas | 48149 | 15 | 1 |
92002 | 92002 | 2020-04-26 | Fayette | Texas | 48149 | 15 | 1 |
94831 | 94831 | 2020-04-27 | Fayette | Texas | 48149 | 15 | 1 |
97671 | 97671 | 2020-04-28 | Fayette | Texas | 48149 | 15 | 1 |
100521 | 100521 | 2020-04-29 | Fayette | Texas | 48149 | 15 | 1 |
103374 | 103374 | 2020-04-30 | Fayette | Texas | 48149 | 15 | 1 |
106238 | 106238 | 2020-05-01 | Fayette | Texas | 48149 | 15 | 1 |
109107 | 109107 | 2020-05-02 | Fayette | Texas | 48149 | 15 | 1 |
111981 | 111981 | 2020-05-03 | Fayette | Texas | 48149 | 15 | 1 |
114863 | 114863 | 2020-05-04 | Fayette | Texas | 48149 | 15 | 1 |
117822 | 117822 | 2020-05-05 | Fayette | Texas | 48149 | 17 | 1 |
120786 | 120786 | 2020-05-06 | Fayette | Texas | 48149 | 17 | 1 |
123765 | 123765 | 2020-05-07 | Fayette | Texas | 48149 | 19 | 1 |
126748 | 126748 | 2020-05-08 | Fayette | Texas | 48149 | 21 | 1 |
129737 | 129737 | 2020-05-09 | Fayette | Texas | 48149 | 24 | 1 |
132727 | 132727 | 2020-05-10 | Fayette | Texas | 48149 | 25 | 1 |
135718 | 135718 | 2020-05-11 | Fayette | Texas | 48149 | 25 | 1 |
138708 | 138708 | 2020-05-12 | Fayette | Texas | 48149 | 26 | 1 |
141704 | 141704 | 2020-05-13 | Fayette | Texas | 48149 | 26 | 1 |
144701 | 144701 | 2020-05-14 | Fayette | Texas | 48149 | 28 | 2 |
147703 | 147703 | 2020-05-15 | Fayette | Texas | 48149 | 26 | 2 |
150711 | 150711 | 2020-05-16 | Fayette | Texas | 48149 | 29 | 2 |
153722 | 153722 | 2020-05-17 | Fayette | Texas | 48149 | 29 | 2 |
156739 | 156739 | 2020-05-18 | Fayette | Texas | 48149 | 29 | 2 |
159761 | 159761 | 2020-05-19 | Fayette | Texas | 48149 | 31 | 2 |
162788 | 162788 | 2020-05-20 | Fayette | Texas | 48149 | 31 | 2 |
165817 | 165817 | 2020-05-21 | Fayette | Texas | 48149 | 31 | 2 |
168853 | 168853 | 2020-05-22 | Fayette | Texas | 48149 | 31 | 2 |
171892 | 171892 | 2020-05-23 | Fayette | Texas | 48149 | 32 | 2 |
174935 | 174935 | 2020-05-24 | Fayette | Texas | 48149 | 32 | 2 |
177979 | 177979 | 2020-05-25 | Fayette | Texas | 48149 | 32 | 2 |
181022 | 181022 | 2020-05-26 | Fayette | Texas | 48149 | 32 | 2 |
184072 | 184072 | 2020-05-27 | Fayette | Texas | 48149 | 32 | 2 |
187129 | 187129 | 2020-05-28 | Fayette | Texas | 48149 | 34 | 2 |
190193 | 190193 | 2020-05-29 | Fayette | Texas | 48149 | 34 | 2 |
193258 | 193258 | 2020-05-30 | Fayette | Texas | 48149 | 34 | 2 |
196328 | 196328 | 2020-05-31 | Fayette | Texas | 48149 | 34 | 2 |
199401 | 199401 | 2020-06-01 | Fayette | Texas | 48149 | 34 | 2 |
202476 | 202476 | 2020-06-02 | Fayette | Texas | 48149 | 34 | 2 |
205555 | 205555 | 2020-06-03 | Fayette | Texas | 48149 | 36 | 2 |
208637 | 208637 | 2020-06-04 | Fayette | Texas | 48149 | 38 | 2 |
211721 | 211721 | 2020-06-05 | Fayette | Texas | 48149 | 38 | 2 |
214808 | 214808 | 2020-06-06 | Fayette | Texas | 48149 | 38 | 2 |
217898 | 217898 | 2020-06-07 | Fayette | Texas | 48149 | 38 | 2 |
220990 | 220990 | 2020-06-08 | Fayette | Texas | 48149 | 38 | 2 |
224085 | 224085 | 2020-06-09 | Fayette | Texas | 48149 | 38 | 2 |
227185 | 227185 | 2020-06-10 | Fayette | Texas | 48149 | 39 | 2 |
230289 | 230289 | 2020-06-11 | Fayette | Texas | 48149 | 43 | 2 |
233393 | 233393 | 2020-06-12 | Fayette | Texas | 48149 | 44 | 2 |
236499 | 236499 | 2020-06-13 | Fayette | Texas | 48149 | 43 | 2 |
239607 | 239607 | 2020-06-14 | Fayette | Texas | 48149 | 44 | 2 |
242717 | 242717 | 2020-06-15 | Fayette | Texas | 48149 | 44 | 2 |
245829 | 245829 | 2020-06-16 | Fayette | Texas | 48149 | 45 | 2 |
248942 | 248942 | 2020-06-17 | Fayette | Texas | 48149 | 52 | 2 |
252057 | 252057 | 2020-06-18 | Fayette | Texas | 48149 | 51 | 2 |
255172 | 255172 | 2020-06-19 | Fayette | Texas | 48149 | 52 | 2 |
258299 | 258299 | 2020-06-20 | Fayette | Texas | 48149 | 58 | 2 |
261426 | 261426 | 2020-06-21 | Fayette | Texas | 48149 | 60 | 2 |
264554 | 264554 | 2020-06-22 | Fayette | Texas | 48149 | 66 | 2 |
267682 | 267682 | 2020-06-23 | Fayette | Texas | 48149 | 71 | 2 |
270816 | 270816 | 2020-06-24 | Fayette | Texas | 48149 | 75 | 2 |
273956 | 273956 | 2020-06-25 | Fayette | Texas | 48149 | 76 | 2 |
277103 | 277103 | 2020-06-26 | Fayette | Texas | 48149 | 75 | 2 |
280251 | 280251 | 2020-06-27 | Fayette | Texas | 48149 | 75 | 2 |
283397 | 283397 | 2020-06-28 | Fayette | Texas | 48149 | 80 | 2 |
286543 | 286543 | 2020-06-29 | Fayette | Texas | 48149 | 86 | 2 |
289693 | 289693 | 2020-06-30 | Fayette | Texas | 48149 | 86 | 2 |
292846 | 292846 | 2020-07-01 | Fayette | Texas | 48149 | 90 | 2 |
296001 | 296001 | 2020-07-02 | Fayette | Texas | 48149 | 95 | 2 |
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);