ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 48159 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19346 | 19346 | 2020-03-29 | Franklin | Texas | 48159 | 1 | 0 |
21405 | 21405 | 2020-03-30 | Franklin | Texas | 48159 | 1 | 0 |
23544 | 23544 | 2020-03-31 | Franklin | Texas | 48159 | 1 | 0 |
25752 | 25752 | 2020-04-01 | Franklin | Texas | 48159 | 1 | 0 |
28033 | 28033 | 2020-04-02 | Franklin | Texas | 48159 | 1 | 0 |
30368 | 30368 | 2020-04-03 | Franklin | Texas | 48159 | 1 | 0 |
32761 | 32761 | 2020-04-04 | Franklin | Texas | 48159 | 1 | 0 |
35199 | 35199 | 2020-04-05 | Franklin | Texas | 48159 | 1 | 0 |
37675 | 37675 | 2020-04-06 | Franklin | Texas | 48159 | 1 | 0 |
40200 | 40200 | 2020-04-07 | Franklin | Texas | 48159 | 1 | 0 |
42766 | 42766 | 2020-04-08 | Franklin | Texas | 48159 | 1 | 0 |
45355 | 45355 | 2020-04-09 | Franklin | Texas | 48159 | 1 | 0 |
47975 | 47975 | 2020-04-10 | Franklin | Texas | 48159 | 1 | 0 |
50633 | 50633 | 2020-04-11 | Franklin | Texas | 48159 | 1 | 0 |
53308 | 53308 | 2020-04-12 | Franklin | Texas | 48159 | 1 | 0 |
55996 | 55996 | 2020-04-13 | Franklin | Texas | 48159 | 1 | 0 |
58701 | 58701 | 2020-04-14 | Franklin | Texas | 48159 | 1 | 0 |
61418 | 61418 | 2020-04-15 | Franklin | Texas | 48159 | 1 | 0 |
64145 | 64145 | 2020-04-16 | Franklin | Texas | 48159 | 1 | 0 |
66892 | 66892 | 2020-04-17 | Franklin | Texas | 48159 | 1 | 0 |
69652 | 69652 | 2020-04-18 | Franklin | Texas | 48159 | 1 | 0 |
72420 | 72420 | 2020-04-19 | Franklin | Texas | 48159 | 1 | 0 |
75195 | 75195 | 2020-04-20 | Franklin | Texas | 48159 | 1 | 0 |
77977 | 77977 | 2020-04-21 | Franklin | Texas | 48159 | 1 | 0 |
80768 | 80768 | 2020-04-22 | Franklin | Texas | 48159 | 1 | 0 |
83568 | 83568 | 2020-04-23 | Franklin | Texas | 48159 | 1 | 0 |
86373 | 86373 | 2020-04-24 | Franklin | Texas | 48159 | 1 | 0 |
89188 | 89188 | 2020-04-25 | Franklin | Texas | 48159 | 1 | 0 |
92005 | 92005 | 2020-04-26 | Franklin | Texas | 48159 | 1 | 0 |
94834 | 94834 | 2020-04-27 | Franklin | Texas | 48159 | 1 | 0 |
97674 | 97674 | 2020-04-28 | Franklin | Texas | 48159 | 1 | 0 |
100524 | 100524 | 2020-04-29 | Franklin | Texas | 48159 | 1 | 0 |
103377 | 103377 | 2020-04-30 | Franklin | Texas | 48159 | 1 | 0 |
106241 | 106241 | 2020-05-01 | Franklin | Texas | 48159 | 1 | 0 |
109110 | 109110 | 2020-05-02 | Franklin | Texas | 48159 | 2 | 0 |
111984 | 111984 | 2020-05-03 | Franklin | Texas | 48159 | 2 | 0 |
114866 | 114866 | 2020-05-04 | Franklin | Texas | 48159 | 2 | 0 |
117825 | 117825 | 2020-05-05 | Franklin | Texas | 48159 | 2 | 0 |
120789 | 120789 | 2020-05-06 | Franklin | Texas | 48159 | 3 | 0 |
123768 | 123768 | 2020-05-07 | Franklin | Texas | 48159 | 3 | 0 |
126751 | 126751 | 2020-05-08 | Franklin | Texas | 48159 | 3 | 0 |
129740 | 129740 | 2020-05-09 | Franklin | Texas | 48159 | 3 | 0 |
132730 | 132730 | 2020-05-10 | Franklin | Texas | 48159 | 3 | 0 |
135721 | 135721 | 2020-05-11 | Franklin | Texas | 48159 | 3 | 0 |
138711 | 138711 | 2020-05-12 | Franklin | Texas | 48159 | 3 | 0 |
141707 | 141707 | 2020-05-13 | Franklin | Texas | 48159 | 3 | 0 |
144704 | 144704 | 2020-05-14 | Franklin | Texas | 48159 | 4 | 0 |
147707 | 147707 | 2020-05-15 | Franklin | Texas | 48159 | 4 | 0 |
150715 | 150715 | 2020-05-16 | Franklin | Texas | 48159 | 5 | 0 |
153726 | 153726 | 2020-05-17 | Franklin | Texas | 48159 | 5 | 0 |
156743 | 156743 | 2020-05-18 | Franklin | Texas | 48159 | 6 | 0 |
159765 | 159765 | 2020-05-19 | Franklin | Texas | 48159 | 7 | 0 |
162792 | 162792 | 2020-05-20 | Franklin | Texas | 48159 | 8 | 0 |
165821 | 165821 | 2020-05-21 | Franklin | Texas | 48159 | 8 | 0 |
168857 | 168857 | 2020-05-22 | Franklin | Texas | 48159 | 8 | 0 |
171896 | 171896 | 2020-05-23 | Franklin | Texas | 48159 | 11 | 0 |
174939 | 174939 | 2020-05-24 | Franklin | Texas | 48159 | 12 | 0 |
177983 | 177983 | 2020-05-25 | Franklin | Texas | 48159 | 12 | 0 |
181026 | 181026 | 2020-05-26 | Franklin | Texas | 48159 | 12 | 0 |
184076 | 184076 | 2020-05-27 | Franklin | Texas | 48159 | 13 | 0 |
187133 | 187133 | 2020-05-28 | Franklin | Texas | 48159 | 13 | 0 |
190197 | 190197 | 2020-05-29 | Franklin | Texas | 48159 | 13 | 0 |
193262 | 193262 | 2020-05-30 | Franklin | Texas | 48159 | 15 | 0 |
196332 | 196332 | 2020-05-31 | Franklin | Texas | 48159 | 15 | 0 |
199405 | 199405 | 2020-06-01 | Franklin | Texas | 48159 | 16 | 0 |
202480 | 202480 | 2020-06-02 | Franklin | Texas | 48159 | 16 | 0 |
205559 | 205559 | 2020-06-03 | Franklin | Texas | 48159 | 17 | 0 |
208641 | 208641 | 2020-06-04 | Franklin | Texas | 48159 | 18 | 0 |
211725 | 211725 | 2020-06-05 | Franklin | Texas | 48159 | 18 | 0 |
214812 | 214812 | 2020-06-06 | Franklin | Texas | 48159 | 19 | 0 |
217902 | 217902 | 2020-06-07 | Franklin | Texas | 48159 | 19 | 0 |
220994 | 220994 | 2020-06-08 | Franklin | Texas | 48159 | 19 | 0 |
224089 | 224089 | 2020-06-09 | Franklin | Texas | 48159 | 22 | 0 |
227189 | 227189 | 2020-06-10 | Franklin | Texas | 48159 | 22 | 0 |
230293 | 230293 | 2020-06-11 | Franklin | Texas | 48159 | 24 | 0 |
233397 | 233397 | 2020-06-12 | Franklin | Texas | 48159 | 24 | 0 |
236503 | 236503 | 2020-06-13 | Franklin | Texas | 48159 | 27 | 0 |
239611 | 239611 | 2020-06-14 | Franklin | Texas | 48159 | 27 | 0 |
242721 | 242721 | 2020-06-15 | Franklin | Texas | 48159 | 27 | 0 |
245833 | 245833 | 2020-06-16 | Franklin | Texas | 48159 | 27 | 0 |
248946 | 248946 | 2020-06-17 | Franklin | Texas | 48159 | 29 | 0 |
252061 | 252061 | 2020-06-18 | Franklin | Texas | 48159 | 30 | 0 |
255176 | 255176 | 2020-06-19 | Franklin | Texas | 48159 | 30 | 0 |
258303 | 258303 | 2020-06-20 | Franklin | Texas | 48159 | 31 | 0 |
261430 | 261430 | 2020-06-21 | Franklin | Texas | 48159 | 33 | 0 |
264558 | 264558 | 2020-06-22 | Franklin | Texas | 48159 | 33 | 0 |
267686 | 267686 | 2020-06-23 | Franklin | Texas | 48159 | 35 | 0 |
270820 | 270820 | 2020-06-24 | Franklin | Texas | 48159 | 35 | 0 |
273960 | 273960 | 2020-06-25 | Franklin | Texas | 48159 | 36 | 0 |
277107 | 277107 | 2020-06-26 | Franklin | Texas | 48159 | 39 | 0 |
280255 | 280255 | 2020-06-27 | Franklin | Texas | 48159 | 41 | 0 |
283401 | 283401 | 2020-06-28 | Franklin | Texas | 48159 | 41 | 0 |
286547 | 286547 | 2020-06-29 | Franklin | Texas | 48159 | 41 | 0 |
289697 | 289697 | 2020-06-30 | Franklin | Texas | 48159 | 41 | 0 |
292850 | 292850 | 2020-07-01 | Franklin | Texas | 48159 | 41 | 0 |
296005 | 296005 | 2020-07-02 | Franklin | Texas | 48159 | 47 | 0 |
299165 | 299165 | 2020-07-03 | Franklin | Texas | 48159 | 50 | 0 |
302329 | 302329 | 2020-07-04 | Franklin | Texas | 48159 | 50 | 0 |
305493 | 305493 | 2020-07-05 | Franklin | Texas | 48159 | 50 | 0 |
308661 | 308661 | 2020-07-06 | Franklin | Texas | 48159 | 50 | 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);