ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1075 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5174 | 5174 | 2020-03-20 | Lamar | Alabama | 1075 | 1 | 0 |
6090 | 6090 | 2020-03-21 | Lamar | Alabama | 1075 | 1 | 0 |
7124 | 7124 | 2020-03-22 | Lamar | Alabama | 1075 | 1 | 0 |
8264 | 8264 | 2020-03-23 | Lamar | Alabama | 1075 | 1 | 0 |
9491 | 9491 | 2020-03-24 | Lamar | Alabama | 1075 | 1 | 0 |
10855 | 10855 | 2020-03-25 | Lamar | Alabama | 1075 | 1 | 0 |
12392 | 12392 | 2020-03-26 | Lamar | Alabama | 1075 | 1 | 0 |
14053 | 14053 | 2020-03-27 | Lamar | Alabama | 1075 | 1 | 0 |
15831 | 15831 | 2020-03-28 | Lamar | Alabama | 1075 | 1 | 0 |
17714 | 17714 | 2020-03-29 | Lamar | Alabama | 1075 | 1 | 0 |
19686 | 19686 | 2020-03-30 | Lamar | Alabama | 1075 | 1 | 0 |
21758 | 21758 | 2020-03-31 | Lamar | Alabama | 1075 | 1 | 0 |
23914 | 23914 | 2020-04-01 | Lamar | Alabama | 1075 | 1 | 0 |
26136 | 26136 | 2020-04-02 | Lamar | Alabama | 1075 | 1 | 0 |
28433 | 28433 | 2020-04-03 | Lamar | Alabama | 1075 | 1 | 0 |
30790 | 30790 | 2020-04-04 | Lamar | Alabama | 1075 | 3 | 0 |
33194 | 33194 | 2020-04-05 | Lamar | Alabama | 1075 | 3 | 0 |
35633 | 35633 | 2020-04-06 | Lamar | Alabama | 1075 | 5 | 0 |
38121 | 38121 | 2020-04-07 | Lamar | Alabama | 1075 | 5 | 0 |
40663 | 40663 | 2020-04-08 | Lamar | Alabama | 1075 | 6 | 0 |
43236 | 43236 | 2020-04-09 | Lamar | Alabama | 1075 | 7 | 0 |
45834 | 45834 | 2020-04-10 | Lamar | Alabama | 1075 | 7 | 0 |
48463 | 48463 | 2020-04-11 | Lamar | Alabama | 1075 | 7 | 0 |
51125 | 51125 | 2020-04-12 | Lamar | Alabama | 1075 | 8 | 0 |
53803 | 53803 | 2020-04-13 | Lamar | Alabama | 1075 | 8 | 0 |
56495 | 56495 | 2020-04-14 | Lamar | Alabama | 1075 | 7 | 0 |
59203 | 59203 | 2020-04-15 | Lamar | Alabama | 1075 | 7 | 0 |
61921 | 61921 | 2020-04-16 | Lamar | Alabama | 1075 | 7 | 0 |
64654 | 64654 | 2020-04-17 | Lamar | Alabama | 1075 | 7 | 0 |
67402 | 67402 | 2020-04-18 | Lamar | Alabama | 1075 | 8 | 0 |
70164 | 70164 | 2020-04-19 | Lamar | Alabama | 1075 | 8 | 0 |
72933 | 72933 | 2020-04-20 | Lamar | Alabama | 1075 | 9 | 0 |
75709 | 75709 | 2020-04-21 | Lamar | Alabama | 1075 | 9 | 0 |
78492 | 78492 | 2020-04-22 | Lamar | Alabama | 1075 | 8 | 0 |
81285 | 81285 | 2020-04-23 | Lamar | Alabama | 1075 | 9 | 0 |
84086 | 84086 | 2020-04-24 | Lamar | Alabama | 1075 | 10 | 0 |
86894 | 86894 | 2020-04-25 | Lamar | Alabama | 1075 | 10 | 0 |
89710 | 89710 | 2020-04-26 | Lamar | Alabama | 1075 | 10 | 0 |
92528 | 92528 | 2020-04-27 | Lamar | Alabama | 1075 | 10 | 0 |
95358 | 95358 | 2020-04-28 | Lamar | Alabama | 1075 | 10 | 0 |
98203 | 98203 | 2020-04-29 | Lamar | Alabama | 1075 | 10 | 0 |
101053 | 101053 | 2020-04-30 | Lamar | Alabama | 1075 | 11 | 0 |
103908 | 103908 | 2020-05-01 | Lamar | Alabama | 1075 | 11 | 0 |
106773 | 106773 | 2020-05-02 | Lamar | Alabama | 1075 | 11 | 0 |
109642 | 109642 | 2020-05-03 | Lamar | Alabama | 1075 | 11 | 0 |
112517 | 112517 | 2020-05-04 | Lamar | Alabama | 1075 | 12 | 0 |
115400 | 115400 | 2020-05-05 | Lamar | Alabama | 1075 | 13 | 0 |
118359 | 118359 | 2020-05-06 | Lamar | Alabama | 1075 | 13 | 0 |
121325 | 121325 | 2020-05-07 | Lamar | Alabama | 1075 | 13 | 0 |
124305 | 124305 | 2020-05-08 | Lamar | Alabama | 1075 | 13 | 0 |
127290 | 127290 | 2020-05-09 | Lamar | Alabama | 1075 | 13 | 0 |
130280 | 130280 | 2020-05-10 | Lamar | Alabama | 1075 | 13 | 0 |
133270 | 133270 | 2020-05-11 | Lamar | Alabama | 1075 | 13 | 0 |
136260 | 136260 | 2020-05-12 | Lamar | Alabama | 1075 | 13 | 0 |
139251 | 139251 | 2020-05-13 | Lamar | Alabama | 1075 | 14 | 0 |
142247 | 142247 | 2020-05-14 | Lamar | Alabama | 1075 | 14 | 0 |
145246 | 145246 | 2020-05-15 | Lamar | Alabama | 1075 | 14 | 0 |
148249 | 148249 | 2020-05-16 | Lamar | Alabama | 1075 | 15 | 0 |
151258 | 151258 | 2020-05-17 | Lamar | Alabama | 1075 | 15 | 0 |
154270 | 154270 | 2020-05-18 | Lamar | Alabama | 1075 | 15 | 0 |
157286 | 157286 | 2020-05-19 | Lamar | Alabama | 1075 | 15 | 0 |
160310 | 160310 | 2020-05-20 | Lamar | Alabama | 1075 | 15 | 0 |
163338 | 163338 | 2020-05-21 | Lamar | Alabama | 1075 | 18 | 0 |
166370 | 166370 | 2020-05-22 | Lamar | Alabama | 1075 | 17 | 0 |
169406 | 169406 | 2020-05-23 | Lamar | Alabama | 1075 | 18 | 0 |
172447 | 172447 | 2020-05-24 | Lamar | Alabama | 1075 | 20 | 0 |
175490 | 175490 | 2020-05-25 | Lamar | Alabama | 1075 | 20 | 0 |
178535 | 178535 | 2020-05-26 | Lamar | Alabama | 1075 | 21 | 0 |
181579 | 181579 | 2020-05-27 | Lamar | Alabama | 1075 | 21 | 0 |
184631 | 184631 | 2020-05-28 | Lamar | Alabama | 1075 | 21 | 0 |
187688 | 187688 | 2020-05-29 | Lamar | Alabama | 1075 | 23 | 0 |
190752 | 190752 | 2020-05-30 | Lamar | Alabama | 1075 | 23 | 0 |
193818 | 193818 | 2020-05-31 | Lamar | Alabama | 1075 | 26 | 0 |
196888 | 196888 | 2020-06-01 | Lamar | Alabama | 1075 | 26 | 0 |
199961 | 199961 | 2020-06-02 | Lamar | Alabama | 1075 | 26 | 0 |
203037 | 203037 | 2020-06-03 | Lamar | Alabama | 1075 | 26 | 0 |
206116 | 206116 | 2020-06-04 | Lamar | Alabama | 1075 | 28 | 0 |
209198 | 209198 | 2020-06-05 | Lamar | Alabama | 1075 | 29 | 1 |
212283 | 212283 | 2020-06-06 | Lamar | Alabama | 1075 | 29 | 1 |
215370 | 215370 | 2020-06-07 | Lamar | Alabama | 1075 | 30 | 1 |
218460 | 218460 | 2020-06-08 | Lamar | Alabama | 1075 | 30 | 0 |
221552 | 221552 | 2020-06-09 | Lamar | Alabama | 1075 | 30 | 0 |
224648 | 224648 | 2020-06-10 | Lamar | Alabama | 1075 | 31 | 0 |
227749 | 227749 | 2020-06-11 | Lamar | Alabama | 1075 | 31 | 0 |
230853 | 230853 | 2020-06-12 | Lamar | Alabama | 1075 | 35 | 0 |
233958 | 233958 | 2020-06-13 | Lamar | Alabama | 1075 | 36 | 0 |
237065 | 237065 | 2020-06-14 | Lamar | Alabama | 1075 | 44 | 0 |
240173 | 240173 | 2020-06-15 | Lamar | Alabama | 1075 | 46 | 0 |
243284 | 243284 | 2020-06-16 | Lamar | Alabama | 1075 | 50 | 0 |
246397 | 246397 | 2020-06-17 | Lamar | Alabama | 1075 | 51 | 0 |
249509 | 249509 | 2020-06-18 | Lamar | Alabama | 1075 | 53 | 0 |
252624 | 252624 | 2020-06-19 | Lamar | Alabama | 1075 | 55 | 0 |
255743 | 255743 | 2020-06-20 | Lamar | Alabama | 1075 | 55 | 0 |
258870 | 258870 | 2020-06-21 | Lamar | Alabama | 1075 | 55 | 0 |
261997 | 261997 | 2020-06-22 | Lamar | Alabama | 1075 | 56 | 0 |
265126 | 265126 | 2020-06-23 | Lamar | Alabama | 1075 | 58 | 0 |
268255 | 268255 | 2020-06-24 | Lamar | Alabama | 1075 | 60 | 0 |
271389 | 271389 | 2020-06-25 | Lamar | Alabama | 1075 | 63 | 0 |
274529 | 274529 | 2020-06-26 | Lamar | Alabama | 1075 | 64 | 1 |
277677 | 277677 | 2020-06-27 | Lamar | Alabama | 1075 | 65 | 1 |
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);