ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Alleghany" and fips = 51005 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19460 | 19460 | 2020-03-29 | Alleghany | Virginia | 51005 | 1 | 0 |
21523 | 21523 | 2020-03-30 | Alleghany | Virginia | 51005 | 1 | 0 |
23662 | 23662 | 2020-03-31 | Alleghany | Virginia | 51005 | 1 | 0 |
25877 | 25877 | 2020-04-01 | Alleghany | Virginia | 51005 | 1 | 0 |
28166 | 28166 | 2020-04-02 | Alleghany | Virginia | 51005 | 2 | 0 |
30509 | 30509 | 2020-04-03 | Alleghany | Virginia | 51005 | 2 | 0 |
32907 | 32907 | 2020-04-04 | Alleghany | Virginia | 51005 | 2 | 0 |
35345 | 35345 | 2020-04-05 | Alleghany | Virginia | 51005 | 2 | 0 |
37826 | 37826 | 2020-04-06 | Alleghany | Virginia | 51005 | 2 | 0 |
40356 | 40356 | 2020-04-07 | Alleghany | Virginia | 51005 | 2 | 0 |
42925 | 42925 | 2020-04-08 | Alleghany | Virginia | 51005 | 2 | 0 |
45519 | 45519 | 2020-04-09 | Alleghany | Virginia | 51005 | 2 | 0 |
48143 | 48143 | 2020-04-10 | Alleghany | Virginia | 51005 | 2 | 0 |
50801 | 50801 | 2020-04-11 | Alleghany | Virginia | 51005 | 4 | 0 |
53476 | 53476 | 2020-04-12 | Alleghany | Virginia | 51005 | 4 | 0 |
56165 | 56165 | 2020-04-13 | Alleghany | Virginia | 51005 | 4 | 0 |
58871 | 58871 | 2020-04-14 | Alleghany | Virginia | 51005 | 4 | 0 |
61590 | 61590 | 2020-04-15 | Alleghany | Virginia | 51005 | 4 | 0 |
64322 | 64322 | 2020-04-16 | Alleghany | Virginia | 51005 | 4 | 0 |
67070 | 67070 | 2020-04-17 | Alleghany | Virginia | 51005 | 4 | 0 |
69832 | 69832 | 2020-04-18 | Alleghany | Virginia | 51005 | 4 | 0 |
72602 | 72602 | 2020-04-19 | Alleghany | Virginia | 51005 | 5 | 0 |
75378 | 75378 | 2020-04-20 | Alleghany | Virginia | 51005 | 5 | 0 |
78160 | 78160 | 2020-04-21 | Alleghany | Virginia | 51005 | 5 | 0 |
80952 | 80952 | 2020-04-22 | Alleghany | Virginia | 51005 | 5 | 0 |
83753 | 83753 | 2020-04-23 | Alleghany | Virginia | 51005 | 5 | 0 |
86560 | 86560 | 2020-04-24 | Alleghany | Virginia | 51005 | 5 | 0 |
89375 | 89375 | 2020-04-25 | Alleghany | Virginia | 51005 | 5 | 0 |
92192 | 92192 | 2020-04-26 | Alleghany | Virginia | 51005 | 5 | 0 |
95021 | 95021 | 2020-04-27 | Alleghany | Virginia | 51005 | 5 | 0 |
97863 | 97863 | 2020-04-28 | Alleghany | Virginia | 51005 | 5 | 0 |
100713 | 100713 | 2020-04-29 | Alleghany | Virginia | 51005 | 6 | 0 |
103568 | 103568 | 2020-04-30 | Alleghany | Virginia | 51005 | 6 | 0 |
106432 | 106432 | 2020-05-01 | Alleghany | Virginia | 51005 | 6 | 0 |
109301 | 109301 | 2020-05-02 | Alleghany | Virginia | 51005 | 6 | 0 |
112175 | 112175 | 2020-05-03 | Alleghany | Virginia | 51005 | 6 | 0 |
115058 | 115058 | 2020-05-04 | Alleghany | Virginia | 51005 | 6 | 0 |
118017 | 118017 | 2020-05-05 | Alleghany | Virginia | 51005 | 6 | 0 |
120981 | 120981 | 2020-05-06 | Alleghany | Virginia | 51005 | 6 | 0 |
123962 | 123962 | 2020-05-07 | Alleghany | Virginia | 51005 | 6 | 0 |
126947 | 126947 | 2020-05-08 | Alleghany | Virginia | 51005 | 6 | 0 |
129936 | 129936 | 2020-05-09 | Alleghany | Virginia | 51005 | 6 | 0 |
132926 | 132926 | 2020-05-10 | Alleghany | Virginia | 51005 | 6 | 0 |
135916 | 135916 | 2020-05-11 | Alleghany | Virginia | 51005 | 6 | 0 |
138907 | 138907 | 2020-05-12 | Alleghany | Virginia | 51005 | 6 | 0 |
141903 | 141903 | 2020-05-13 | Alleghany | Virginia | 51005 | 6 | 0 |
144900 | 144900 | 2020-05-14 | Alleghany | Virginia | 51005 | 6 | 0 |
147903 | 147903 | 2020-05-15 | Alleghany | Virginia | 51005 | 6 | 0 |
150912 | 150912 | 2020-05-16 | Alleghany | Virginia | 51005 | 6 | 0 |
153923 | 153923 | 2020-05-17 | Alleghany | Virginia | 51005 | 7 | 0 |
156940 | 156940 | 2020-05-18 | Alleghany | Virginia | 51005 | 9 | 0 |
159964 | 159964 | 2020-05-19 | Alleghany | Virginia | 51005 | 9 | 0 |
162992 | 162992 | 2020-05-20 | Alleghany | Virginia | 51005 | 10 | 0 |
166021 | 166021 | 2020-05-21 | Alleghany | Virginia | 51005 | 9 | 0 |
169057 | 169057 | 2020-05-22 | Alleghany | Virginia | 51005 | 10 | 2 |
172098 | 172098 | 2020-05-23 | Alleghany | Virginia | 51005 | 13 | 2 |
175141 | 175141 | 2020-05-24 | Alleghany | Virginia | 51005 | 13 | 2 |
178186 | 178186 | 2020-05-25 | Alleghany | Virginia | 51005 | 13 | 2 |
181230 | 181230 | 2020-05-26 | Alleghany | Virginia | 51005 | 16 | 2 |
184281 | 184281 | 2020-05-27 | Alleghany | Virginia | 51005 | 16 | 2 |
187338 | 187338 | 2020-05-28 | Alleghany | Virginia | 51005 | 17 | 2 |
190402 | 190402 | 2020-05-29 | Alleghany | Virginia | 51005 | 19 | 2 |
193468 | 193468 | 2020-05-30 | Alleghany | Virginia | 51005 | 20 | 2 |
196538 | 196538 | 2020-05-31 | Alleghany | Virginia | 51005 | 20 | 2 |
199611 | 199611 | 2020-06-01 | Alleghany | Virginia | 51005 | 23 | 2 |
202687 | 202687 | 2020-06-02 | Alleghany | Virginia | 51005 | 24 | 2 |
205766 | 205766 | 2020-06-03 | Alleghany | Virginia | 51005 | 24 | 2 |
208848 | 208848 | 2020-06-04 | Alleghany | Virginia | 51005 | 24 | 2 |
211933 | 211933 | 2020-06-05 | Alleghany | Virginia | 51005 | 24 | 2 |
215020 | 215020 | 2020-06-06 | Alleghany | Virginia | 51005 | 26 | 2 |
218110 | 218110 | 2020-06-07 | Alleghany | Virginia | 51005 | 26 | 2 |
221202 | 221202 | 2020-06-08 | Alleghany | Virginia | 51005 | 26 | 2 |
224298 | 224298 | 2020-06-09 | Alleghany | Virginia | 51005 | 26 | 2 |
227398 | 227398 | 2020-06-10 | Alleghany | Virginia | 51005 | 26 | 2 |
230502 | 230502 | 2020-06-11 | Alleghany | Virginia | 51005 | 26 | 2 |
233607 | 233607 | 2020-06-12 | Alleghany | Virginia | 51005 | 27 | 2 |
236714 | 236714 | 2020-06-13 | Alleghany | Virginia | 51005 | 28 | 2 |
239822 | 239822 | 2020-06-14 | Alleghany | Virginia | 51005 | 28 | 2 |
242933 | 242933 | 2020-06-15 | Alleghany | Virginia | 51005 | 28 | 2 |
246045 | 246045 | 2020-06-16 | Alleghany | Virginia | 51005 | 30 | 2 |
249157 | 249157 | 2020-06-17 | Alleghany | Virginia | 51005 | 30 | 2 |
252272 | 252272 | 2020-06-18 | Alleghany | Virginia | 51005 | 30 | 2 |
255390 | 255390 | 2020-06-19 | Alleghany | Virginia | 51005 | 30 | 2 |
258517 | 258517 | 2020-06-20 | Alleghany | Virginia | 51005 | 30 | 2 |
261644 | 261644 | 2020-06-21 | Alleghany | Virginia | 51005 | 30 | 2 |
264773 | 264773 | 2020-06-22 | Alleghany | Virginia | 51005 | 31 | 2 |
267902 | 267902 | 2020-06-23 | Alleghany | Virginia | 51005 | 31 | 2 |
271036 | 271036 | 2020-06-24 | Alleghany | Virginia | 51005 | 31 | 2 |
274176 | 274176 | 2020-06-25 | Alleghany | Virginia | 51005 | 31 | 2 |
277324 | 277324 | 2020-06-26 | Alleghany | Virginia | 51005 | 31 | 2 |
280472 | 280472 | 2020-06-27 | Alleghany | Virginia | 51005 | 31 | 2 |
283618 | 283618 | 2020-06-28 | Alleghany | Virginia | 51005 | 31 | 2 |
286764 | 286764 | 2020-06-29 | Alleghany | Virginia | 51005 | 31 | 2 |
289914 | 289914 | 2020-06-30 | Alleghany | Virginia | 51005 | 31 | 2 |
293067 | 293067 | 2020-07-01 | Alleghany | Virginia | 51005 | 33 | 2 |
296222 | 296222 | 2020-07-02 | Alleghany | Virginia | 51005 | 33 | 2 |
299384 | 299384 | 2020-07-03 | Alleghany | Virginia | 51005 | 34 | 2 |
302548 | 302548 | 2020-07-04 | Alleghany | Virginia | 51005 | 35 | 2 |
305712 | 305712 | 2020-07-05 | Alleghany | Virginia | 51005 | 35 | 2 |
308880 | 308880 | 2020-07-06 | Alleghany | Virginia | 51005 | 36 | 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);