ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Spotsylvania" and state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2279 | 2279 | 2020-03-14 | Spotsylvania | Virginia | 51177 | 1 | 0 |
2706 | 2706 | 2020-03-15 | Spotsylvania | Virginia | 51177 | 1 | 0 |
3178 | 3178 | 2020-03-16 | Spotsylvania | Virginia | 51177 | 1 | 0 |
3717 | 3717 | 2020-03-17 | Spotsylvania | Virginia | 51177 | 1 | 0 |
4351 | 4351 | 2020-03-18 | Spotsylvania | Virginia | 51177 | 1 | 0 |
5107 | 5107 | 2020-03-19 | Spotsylvania | Virginia | 51177 | 1 | 0 |
6008 | 6008 | 2020-03-20 | Spotsylvania | Virginia | 51177 | 1 | 0 |
7038 | 7038 | 2020-03-21 | Spotsylvania | Virginia | 51177 | 1 | 0 |
8175 | 8175 | 2020-03-22 | Spotsylvania | Virginia | 51177 | 2 | 0 |
9398 | 9398 | 2020-03-23 | Spotsylvania | Virginia | 51177 | 2 | 0 |
10746 | 10746 | 2020-03-24 | Spotsylvania | Virginia | 51177 | 2 | 0 |
12268 | 12268 | 2020-03-25 | Spotsylvania | Virginia | 51177 | 3 | 0 |
13916 | 13916 | 2020-03-26 | Spotsylvania | Virginia | 51177 | 3 | 0 |
15685 | 15685 | 2020-03-27 | Spotsylvania | Virginia | 51177 | 3 | 0 |
17565 | 17565 | 2020-03-28 | Spotsylvania | Virginia | 51177 | 3 | 0 |
19527 | 19527 | 2020-03-29 | Spotsylvania | Virginia | 51177 | 5 | 0 |
21594 | 21594 | 2020-03-30 | Spotsylvania | Virginia | 51177 | 6 | 0 |
23741 | 23741 | 2020-03-31 | Spotsylvania | Virginia | 51177 | 7 | 0 |
25957 | 25957 | 2020-04-01 | Spotsylvania | Virginia | 51177 | 8 | 0 |
28248 | 28248 | 2020-04-02 | Spotsylvania | Virginia | 51177 | 9 | 0 |
30597 | 30597 | 2020-04-03 | Spotsylvania | Virginia | 51177 | 11 | 0 |
32996 | 32996 | 2020-04-04 | Spotsylvania | Virginia | 51177 | 18 | 0 |
35434 | 35434 | 2020-04-05 | Spotsylvania | Virginia | 51177 | 24 | 0 |
37918 | 37918 | 2020-04-06 | Spotsylvania | Virginia | 51177 | 26 | 0 |
40453 | 40453 | 2020-04-07 | Spotsylvania | Virginia | 51177 | 29 | 0 |
43022 | 43022 | 2020-04-08 | Spotsylvania | Virginia | 51177 | 31 | 0 |
45618 | 45618 | 2020-04-09 | Spotsylvania | Virginia | 51177 | 36 | 0 |
48245 | 48245 | 2020-04-10 | Spotsylvania | Virginia | 51177 | 43 | 0 |
50903 | 50903 | 2020-04-11 | Spotsylvania | Virginia | 51177 | 47 | 0 |
53578 | 53578 | 2020-04-12 | Spotsylvania | Virginia | 51177 | 50 | 0 |
56268 | 56268 | 2020-04-13 | Spotsylvania | Virginia | 51177 | 51 | 0 |
58974 | 58974 | 2020-04-14 | Spotsylvania | Virginia | 51177 | 56 | 0 |
61693 | 61693 | 2020-04-15 | Spotsylvania | Virginia | 51177 | 60 | 0 |
64426 | 64426 | 2020-04-16 | Spotsylvania | Virginia | 51177 | 62 | 0 |
67174 | 67174 | 2020-04-17 | Spotsylvania | Virginia | 51177 | 69 | 0 |
69936 | 69936 | 2020-04-18 | Spotsylvania | Virginia | 51177 | 72 | 0 |
72706 | 72706 | 2020-04-19 | Spotsylvania | Virginia | 51177 | 74 | 0 |
75482 | 75482 | 2020-04-20 | Spotsylvania | Virginia | 51177 | 77 | 0 |
78266 | 78266 | 2020-04-21 | Spotsylvania | Virginia | 51177 | 79 | 2 |
81059 | 81059 | 2020-04-22 | Spotsylvania | Virginia | 51177 | 83 | 3 |
83860 | 83860 | 2020-04-23 | Spotsylvania | Virginia | 51177 | 94 | 3 |
86667 | 86667 | 2020-04-24 | Spotsylvania | Virginia | 51177 | 97 | 3 |
89482 | 89482 | 2020-04-25 | Spotsylvania | Virginia | 51177 | 101 | 3 |
92299 | 92299 | 2020-04-26 | Spotsylvania | Virginia | 51177 | 107 | 3 |
95128 | 95128 | 2020-04-27 | Spotsylvania | Virginia | 51177 | 119 | 3 |
97972 | 97972 | 2020-04-28 | Spotsylvania | Virginia | 51177 | 126 | 3 |
100822 | 100822 | 2020-04-29 | Spotsylvania | Virginia | 51177 | 131 | 3 |
103677 | 103677 | 2020-04-30 | Spotsylvania | Virginia | 51177 | 143 | 3 |
106541 | 106541 | 2020-05-01 | Spotsylvania | Virginia | 51177 | 155 | 4 |
109410 | 109410 | 2020-05-02 | Spotsylvania | Virginia | 51177 | 174 | 4 |
112284 | 112284 | 2020-05-03 | Spotsylvania | Virginia | 51177 | 186 | 4 |
115167 | 115167 | 2020-05-04 | Spotsylvania | Virginia | 51177 | 195 | 4 |
118126 | 118126 | 2020-05-05 | Spotsylvania | Virginia | 51177 | 206 | 4 |
121090 | 121090 | 2020-05-06 | Spotsylvania | Virginia | 51177 | 206 | 4 |
124071 | 124071 | 2020-05-07 | Spotsylvania | Virginia | 51177 | 230 | 4 |
127056 | 127056 | 2020-05-08 | Spotsylvania | Virginia | 51177 | 233 | 4 |
130046 | 130046 | 2020-05-09 | Spotsylvania | Virginia | 51177 | 239 | 4 |
133036 | 133036 | 2020-05-10 | Spotsylvania | Virginia | 51177 | 248 | 4 |
136026 | 136026 | 2020-05-11 | Spotsylvania | Virginia | 51177 | 257 | 4 |
139017 | 139017 | 2020-05-12 | Spotsylvania | Virginia | 51177 | 261 | 4 |
142013 | 142013 | 2020-05-13 | Spotsylvania | Virginia | 51177 | 270 | 4 |
145010 | 145010 | 2020-05-14 | Spotsylvania | Virginia | 51177 | 282 | 4 |
148013 | 148013 | 2020-05-15 | Spotsylvania | Virginia | 51177 | 291 | 4 |
151022 | 151022 | 2020-05-16 | Spotsylvania | Virginia | 51177 | 304 | 4 |
154033 | 154033 | 2020-05-17 | Spotsylvania | Virginia | 51177 | 312 | 4 |
157050 | 157050 | 2020-05-18 | Spotsylvania | Virginia | 51177 | 319 | 4 |
160074 | 160074 | 2020-05-19 | Spotsylvania | Virginia | 51177 | 339 | 4 |
163102 | 163102 | 2020-05-20 | Spotsylvania | Virginia | 51177 | 351 | 4 |
166131 | 166131 | 2020-05-21 | Spotsylvania | Virginia | 51177 | 366 | 4 |
169167 | 169167 | 2020-05-22 | Spotsylvania | Virginia | 51177 | 373 | 4 |
172208 | 172208 | 2020-05-23 | Spotsylvania | Virginia | 51177 | 386 | 4 |
175251 | 175251 | 2020-05-24 | Spotsylvania | Virginia | 51177 | 401 | 5 |
178296 | 178296 | 2020-05-25 | Spotsylvania | Virginia | 51177 | 422 | 6 |
181340 | 181340 | 2020-05-26 | Spotsylvania | Virginia | 51177 | 463 | 6 |
184391 | 184391 | 2020-05-27 | Spotsylvania | Virginia | 51177 | 474 | 6 |
187448 | 187448 | 2020-05-28 | Spotsylvania | Virginia | 51177 | 487 | 6 |
190512 | 190512 | 2020-05-29 | Spotsylvania | Virginia | 51177 | 500 | 7 |
193578 | 193578 | 2020-05-30 | Spotsylvania | Virginia | 51177 | 524 | 7 |
196648 | 196648 | 2020-05-31 | Spotsylvania | Virginia | 51177 | 556 | 7 |
199721 | 199721 | 2020-06-01 | Spotsylvania | Virginia | 51177 | 571 | 7 |
202797 | 202797 | 2020-06-02 | Spotsylvania | Virginia | 51177 | 586 | 7 |
205876 | 205876 | 2020-06-03 | Spotsylvania | Virginia | 51177 | 590 | 7 |
208958 | 208958 | 2020-06-04 | Spotsylvania | Virginia | 51177 | 593 | 7 |
212043 | 212043 | 2020-06-05 | Spotsylvania | Virginia | 51177 | 615 | 7 |
215130 | 215130 | 2020-06-06 | Spotsylvania | Virginia | 51177 | 634 | 7 |
218220 | 218220 | 2020-06-07 | Spotsylvania | Virginia | 51177 | 695 | 7 |
221312 | 221312 | 2020-06-08 | Spotsylvania | Virginia | 51177 | 707 | 7 |
224408 | 224408 | 2020-06-09 | Spotsylvania | Virginia | 51177 | 712 | 9 |
227508 | 227508 | 2020-06-10 | Spotsylvania | Virginia | 51177 | 723 | 10 |
230612 | 230612 | 2020-06-11 | Spotsylvania | Virginia | 51177 | 729 | 11 |
233717 | 233717 | 2020-06-12 | Spotsylvania | Virginia | 51177 | 739 | 12 |
236824 | 236824 | 2020-06-13 | Spotsylvania | Virginia | 51177 | 752 | 13 |
239932 | 239932 | 2020-06-14 | Spotsylvania | Virginia | 51177 | 813 | 15 |
243043 | 243043 | 2020-06-15 | Spotsylvania | Virginia | 51177 | 837 | 16 |
246156 | 246156 | 2020-06-16 | Spotsylvania | Virginia | 51177 | 849 | 17 |
249268 | 249268 | 2020-06-17 | Spotsylvania | Virginia | 51177 | 858 | 17 |
252383 | 252383 | 2020-06-18 | Spotsylvania | Virginia | 51177 | 862 | 17 |
255502 | 255502 | 2020-06-19 | Spotsylvania | Virginia | 51177 | 874 | 19 |
258629 | 258629 | 2020-06-20 | Spotsylvania | Virginia | 51177 | 891 | 20 |
261756 | 261756 | 2020-06-21 | Spotsylvania | Virginia | 51177 | 902 | 20 |
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);