ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Albemarle" and state = "Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7014 | 7014 | 2020-03-21 | Albemarle | Virginia | 51003 | 1 | 0 |
8144 | 8144 | 2020-03-22 | Albemarle | Virginia | 51003 | 2 | 0 |
9365 | 9365 | 2020-03-23 | Albemarle | Virginia | 51003 | 2 | 0 |
10711 | 10711 | 2020-03-24 | Albemarle | Virginia | 51003 | 2 | 0 |
12223 | 12223 | 2020-03-25 | Albemarle | Virginia | 51003 | 4 | 0 |
13859 | 13859 | 2020-03-26 | Albemarle | Virginia | 51003 | 8 | 0 |
15625 | 15625 | 2020-03-27 | Albemarle | Virginia | 51003 | 8 | 0 |
17499 | 17499 | 2020-03-28 | Albemarle | Virginia | 51003 | 16 | 0 |
19458 | 19458 | 2020-03-29 | Albemarle | Virginia | 51003 | 17 | 0 |
21521 | 21521 | 2020-03-30 | Albemarle | Virginia | 51003 | 19 | 0 |
23660 | 23660 | 2020-03-31 | Albemarle | Virginia | 51003 | 21 | 0 |
25875 | 25875 | 2020-04-01 | Albemarle | Virginia | 51003 | 21 | 0 |
28164 | 28164 | 2020-04-02 | Albemarle | Virginia | 51003 | 23 | 0 |
30507 | 30507 | 2020-04-03 | Albemarle | Virginia | 51003 | 26 | 0 |
32905 | 32905 | 2020-04-04 | Albemarle | Virginia | 51003 | 27 | 0 |
35343 | 35343 | 2020-04-05 | Albemarle | Virginia | 51003 | 32 | 0 |
37824 | 37824 | 2020-04-06 | Albemarle | Virginia | 51003 | 34 | 0 |
40354 | 40354 | 2020-04-07 | Albemarle | Virginia | 51003 | 38 | 0 |
42923 | 42923 | 2020-04-08 | Albemarle | Virginia | 51003 | 41 | 0 |
45517 | 45517 | 2020-04-09 | Albemarle | Virginia | 51003 | 43 | 0 |
48141 | 48141 | 2020-04-10 | Albemarle | Virginia | 51003 | 43 | 0 |
50799 | 50799 | 2020-04-11 | Albemarle | Virginia | 51003 | 46 | 0 |
53474 | 53474 | 2020-04-12 | Albemarle | Virginia | 51003 | 46 | 0 |
56163 | 56163 | 2020-04-13 | Albemarle | Virginia | 51003 | 49 | 0 |
58869 | 58869 | 2020-04-14 | Albemarle | Virginia | 51003 | 50 | 0 |
61588 | 61588 | 2020-04-15 | Albemarle | Virginia | 51003 | 53 | 0 |
64320 | 64320 | 2020-04-16 | Albemarle | Virginia | 51003 | 54 | 0 |
67068 | 67068 | 2020-04-17 | Albemarle | Virginia | 51003 | 56 | 0 |
69830 | 69830 | 2020-04-18 | Albemarle | Virginia | 51003 | 56 | 0 |
72600 | 72600 | 2020-04-19 | Albemarle | Virginia | 51003 | 57 | 0 |
75376 | 75376 | 2020-04-20 | Albemarle | Virginia | 51003 | 61 | 0 |
78158 | 78158 | 2020-04-21 | Albemarle | Virginia | 51003 | 66 | 3 |
80950 | 80950 | 2020-04-22 | Albemarle | Virginia | 51003 | 68 | 3 |
83751 | 83751 | 2020-04-23 | Albemarle | Virginia | 51003 | 71 | 3 |
86558 | 86558 | 2020-04-24 | Albemarle | Virginia | 51003 | 72 | 3 |
89373 | 89373 | 2020-04-25 | Albemarle | Virginia | 51003 | 73 | 3 |
92190 | 92190 | 2020-04-26 | Albemarle | Virginia | 51003 | 76 | 3 |
95019 | 95019 | 2020-04-27 | Albemarle | Virginia | 51003 | 77 | 3 |
97861 | 97861 | 2020-04-28 | Albemarle | Virginia | 51003 | 80 | 4 |
100711 | 100711 | 2020-04-29 | Albemarle | Virginia | 51003 | 81 | 4 |
103566 | 103566 | 2020-04-30 | Albemarle | Virginia | 51003 | 103 | 4 |
106430 | 106430 | 2020-05-01 | Albemarle | Virginia | 51003 | 103 | 4 |
109299 | 109299 | 2020-05-02 | Albemarle | Virginia | 51003 | 105 | 4 |
112173 | 112173 | 2020-05-03 | Albemarle | Virginia | 51003 | 108 | 4 |
115056 | 115056 | 2020-05-04 | Albemarle | Virginia | 51003 | 110 | 4 |
118015 | 118015 | 2020-05-05 | Albemarle | Virginia | 51003 | 110 | 4 |
120979 | 120979 | 2020-05-06 | Albemarle | Virginia | 51003 | 110 | 4 |
123960 | 123960 | 2020-05-07 | Albemarle | Virginia | 51003 | 112 | 4 |
126945 | 126945 | 2020-05-08 | Albemarle | Virginia | 51003 | 116 | 4 |
129934 | 129934 | 2020-05-09 | Albemarle | Virginia | 51003 | 119 | 4 |
132924 | 132924 | 2020-05-10 | Albemarle | Virginia | 51003 | 120 | 4 |
135914 | 135914 | 2020-05-11 | Albemarle | Virginia | 51003 | 123 | 4 |
138905 | 138905 | 2020-05-12 | Albemarle | Virginia | 51003 | 124 | 4 |
141901 | 141901 | 2020-05-13 | Albemarle | Virginia | 51003 | 126 | 4 |
144898 | 144898 | 2020-05-14 | Albemarle | Virginia | 51003 | 130 | 4 |
147901 | 147901 | 2020-05-15 | Albemarle | Virginia | 51003 | 133 | 4 |
150910 | 150910 | 2020-05-16 | Albemarle | Virginia | 51003 | 136 | 4 |
153921 | 153921 | 2020-05-17 | Albemarle | Virginia | 51003 | 138 | 4 |
156938 | 156938 | 2020-05-18 | Albemarle | Virginia | 51003 | 139 | 4 |
159962 | 159962 | 2020-05-19 | Albemarle | Virginia | 51003 | 141 | 4 |
162990 | 162990 | 2020-05-20 | Albemarle | Virginia | 51003 | 142 | 4 |
166019 | 166019 | 2020-05-21 | Albemarle | Virginia | 51003 | 142 | 4 |
169055 | 169055 | 2020-05-22 | Albemarle | Virginia | 51003 | 142 | 4 |
172096 | 172096 | 2020-05-23 | Albemarle | Virginia | 51003 | 143 | 5 |
175139 | 175139 | 2020-05-24 | Albemarle | Virginia | 51003 | 148 | 8 |
178184 | 178184 | 2020-05-25 | Albemarle | Virginia | 51003 | 149 | 8 |
181228 | 181228 | 2020-05-26 | Albemarle | Virginia | 51003 | 161 | 8 |
184279 | 184279 | 2020-05-27 | Albemarle | Virginia | 51003 | 168 | 8 |
187336 | 187336 | 2020-05-28 | Albemarle | Virginia | 51003 | 170 | 8 |
190400 | 190400 | 2020-05-29 | Albemarle | Virginia | 51003 | 180 | 8 |
193466 | 193466 | 2020-05-30 | Albemarle | Virginia | 51003 | 187 | 8 |
196536 | 196536 | 2020-05-31 | Albemarle | Virginia | 51003 | 187 | 8 |
199609 | 199609 | 2020-06-01 | Albemarle | Virginia | 51003 | 199 | 8 |
202685 | 202685 | 2020-06-02 | Albemarle | Virginia | 51003 | 200 | 8 |
205764 | 205764 | 2020-06-03 | Albemarle | Virginia | 51003 | 204 | 8 |
208846 | 208846 | 2020-06-04 | Albemarle | Virginia | 51003 | 213 | 8 |
211931 | 211931 | 2020-06-05 | Albemarle | Virginia | 51003 | 217 | 8 |
215018 | 215018 | 2020-06-06 | Albemarle | Virginia | 51003 | 221 | 8 |
218108 | 218108 | 2020-06-07 | Albemarle | Virginia | 51003 | 251 | 8 |
221200 | 221200 | 2020-06-08 | Albemarle | Virginia | 51003 | 255 | 8 |
224296 | 224296 | 2020-06-09 | Albemarle | Virginia | 51003 | 258 | 8 |
227396 | 227396 | 2020-06-10 | Albemarle | Virginia | 51003 | 260 | 8 |
230500 | 230500 | 2020-06-11 | Albemarle | Virginia | 51003 | 269 | 8 |
233605 | 233605 | 2020-06-12 | Albemarle | Virginia | 51003 | 272 | 8 |
236712 | 236712 | 2020-06-13 | Albemarle | Virginia | 51003 | 275 | 8 |
239820 | 239820 | 2020-06-14 | Albemarle | Virginia | 51003 | 286 | 8 |
242931 | 242931 | 2020-06-15 | Albemarle | Virginia | 51003 | 290 | 8 |
246043 | 246043 | 2020-06-16 | Albemarle | Virginia | 51003 | 293 | 8 |
249155 | 249155 | 2020-06-17 | Albemarle | Virginia | 51003 | 293 | 8 |
252270 | 252270 | 2020-06-18 | Albemarle | Virginia | 51003 | 302 | 8 |
255388 | 255388 | 2020-06-19 | Albemarle | Virginia | 51003 | 304 | 8 |
258515 | 258515 | 2020-06-20 | Albemarle | Virginia | 51003 | 321 | 8 |
261642 | 261642 | 2020-06-21 | Albemarle | Virginia | 51003 | 334 | 8 |
264771 | 264771 | 2020-06-22 | Albemarle | Virginia | 51003 | 340 | 8 |
267900 | 267900 | 2020-06-23 | Albemarle | Virginia | 51003 | 352 | 8 |
271034 | 271034 | 2020-06-24 | Albemarle | Virginia | 51003 | 359 | 8 |
274174 | 274174 | 2020-06-25 | Albemarle | Virginia | 51003 | 367 | 8 |
277322 | 277322 | 2020-06-26 | Albemarle | Virginia | 51003 | 374 | 8 |
280470 | 280470 | 2020-06-27 | Albemarle | Virginia | 51003 | 382 | 8 |
283616 | 283616 | 2020-06-28 | Albemarle | Virginia | 51003 | 393 | 8 |
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);