ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51177 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388949 | 388949 | 2020-07-31 | Spotsylvania | Virginia | 51177 | 1305 | 33 |
385732 | 385732 | 2020-07-30 | Spotsylvania | Virginia | 51177 | 1291 | 33 |
382514 | 382514 | 2020-07-29 | Spotsylvania | Virginia | 51177 | 1271 | 33 |
379297 | 379297 | 2020-07-28 | Spotsylvania | Virginia | 51177 | 1254 | 33 |
376081 | 376081 | 2020-07-27 | Spotsylvania | Virginia | 51177 | 1244 | 33 |
372867 | 372867 | 2020-07-26 | Spotsylvania | Virginia | 51177 | 1225 | 32 |
369655 | 369655 | 2020-07-25 | Spotsylvania | Virginia | 51177 | 1212 | 32 |
366446 | 366446 | 2020-07-24 | Spotsylvania | Virginia | 51177 | 1213 | 33 |
363240 | 363240 | 2020-07-23 | Spotsylvania | Virginia | 51177 | 1212 | 33 |
360034 | 360034 | 2020-07-22 | Spotsylvania | Virginia | 51177 | 1197 | 33 |
356829 | 356829 | 2020-07-21 | Spotsylvania | Virginia | 51177 | 1168 | 33 |
353626 | 353626 | 2020-07-20 | Spotsylvania | Virginia | 51177 | 1154 | 32 |
350424 | 350424 | 2020-07-19 | Spotsylvania | Virginia | 51177 | 1148 | 32 |
347223 | 347223 | 2020-07-18 | Spotsylvania | Virginia | 51177 | 1136 | 32 |
344023 | 344023 | 2020-07-17 | Spotsylvania | Virginia | 51177 | 1124 | 32 |
340824 | 340824 | 2020-07-16 | Spotsylvania | Virginia | 51177 | 1108 | 31 |
337628 | 337628 | 2020-07-15 | Spotsylvania | Virginia | 51177 | 1094 | 32 |
334433 | 334433 | 2020-07-14 | Spotsylvania | Virginia | 51177 | 1088 | 32 |
331240 | 331240 | 2020-07-13 | Spotsylvania | Virginia | 51177 | 1083 | 31 |
328054 | 328054 | 2020-07-12 | Spotsylvania | Virginia | 51177 | 1082 | 31 |
324869 | 324869 | 2020-07-11 | Spotsylvania | Virginia | 51177 | 1076 | 31 |
321688 | 321688 | 2020-07-10 | Spotsylvania | Virginia | 51177 | 1077 | 31 |
318509 | 318509 | 2020-07-09 | Spotsylvania | Virginia | 51177 | 1060 | 31 |
315336 | 315336 | 2020-07-08 | Spotsylvania | Virginia | 51177 | 1053 | 31 |
312161 | 312161 | 2020-07-07 | Spotsylvania | Virginia | 51177 | 1048 | 31 |
308992 | 308992 | 2020-07-06 | Spotsylvania | Virginia | 51177 | 1038 | 31 |
305824 | 305824 | 2020-07-05 | Spotsylvania | Virginia | 51177 | 1036 | 31 |
302660 | 302660 | 2020-07-04 | Spotsylvania | Virginia | 51177 | 1027 | 31 |
299496 | 299496 | 2020-07-03 | Spotsylvania | Virginia | 51177 | 1010 | 31 |
296334 | 296334 | 2020-07-02 | Spotsylvania | Virginia | 51177 | 1001 | 31 |
293179 | 293179 | 2020-07-01 | Spotsylvania | Virginia | 51177 | 994 | 30 |
290026 | 290026 | 2020-06-30 | Spotsylvania | Virginia | 51177 | 993 | 29 |
286876 | 286876 | 2020-06-29 | Spotsylvania | Virginia | 51177 | 985 | 29 |
283730 | 283730 | 2020-06-28 | Spotsylvania | Virginia | 51177 | 981 | 29 |
280584 | 280584 | 2020-06-27 | Spotsylvania | Virginia | 51177 | 975 | 29 |
277436 | 277436 | 2020-06-26 | Spotsylvania | Virginia | 51177 | 945 | 28 |
274288 | 274288 | 2020-06-25 | Spotsylvania | Virginia | 51177 | 931 | 26 |
271148 | 271148 | 2020-06-24 | Spotsylvania | Virginia | 51177 | 924 | 26 |
268014 | 268014 | 2020-06-23 | Spotsylvania | Virginia | 51177 | 917 | 24 |
264885 | 264885 | 2020-06-22 | Spotsylvania | Virginia | 51177 | 909 | 21 |
261756 | 261756 | 2020-06-21 | Spotsylvania | Virginia | 51177 | 902 | 20 |
258629 | 258629 | 2020-06-20 | Spotsylvania | Virginia | 51177 | 891 | 20 |
255502 | 255502 | 2020-06-19 | Spotsylvania | Virginia | 51177 | 874 | 19 |
252383 | 252383 | 2020-06-18 | Spotsylvania | Virginia | 51177 | 862 | 17 |
249268 | 249268 | 2020-06-17 | Spotsylvania | Virginia | 51177 | 858 | 17 |
246156 | 246156 | 2020-06-16 | Spotsylvania | Virginia | 51177 | 849 | 17 |
243043 | 243043 | 2020-06-15 | Spotsylvania | Virginia | 51177 | 837 | 16 |
239932 | 239932 | 2020-06-14 | Spotsylvania | Virginia | 51177 | 813 | 15 |
236824 | 236824 | 2020-06-13 | Spotsylvania | Virginia | 51177 | 752 | 13 |
233717 | 233717 | 2020-06-12 | Spotsylvania | Virginia | 51177 | 739 | 12 |
230612 | 230612 | 2020-06-11 | Spotsylvania | Virginia | 51177 | 729 | 11 |
227508 | 227508 | 2020-06-10 | Spotsylvania | Virginia | 51177 | 723 | 10 |
224408 | 224408 | 2020-06-09 | Spotsylvania | Virginia | 51177 | 712 | 9 |
221312 | 221312 | 2020-06-08 | Spotsylvania | Virginia | 51177 | 707 | 7 |
218220 | 218220 | 2020-06-07 | Spotsylvania | Virginia | 51177 | 695 | 7 |
215130 | 215130 | 2020-06-06 | Spotsylvania | Virginia | 51177 | 634 | 7 |
212043 | 212043 | 2020-06-05 | Spotsylvania | Virginia | 51177 | 615 | 7 |
208958 | 208958 | 2020-06-04 | Spotsylvania | Virginia | 51177 | 593 | 7 |
205876 | 205876 | 2020-06-03 | Spotsylvania | Virginia | 51177 | 590 | 7 |
202797 | 202797 | 2020-06-02 | Spotsylvania | Virginia | 51177 | 586 | 7 |
199721 | 199721 | 2020-06-01 | Spotsylvania | Virginia | 51177 | 571 | 7 |
196648 | 196648 | 2020-05-31 | Spotsylvania | Virginia | 51177 | 556 | 7 |
193578 | 193578 | 2020-05-30 | Spotsylvania | Virginia | 51177 | 524 | 7 |
190512 | 190512 | 2020-05-29 | Spotsylvania | Virginia | 51177 | 500 | 7 |
187448 | 187448 | 2020-05-28 | Spotsylvania | Virginia | 51177 | 487 | 6 |
184391 | 184391 | 2020-05-27 | Spotsylvania | Virginia | 51177 | 474 | 6 |
181340 | 181340 | 2020-05-26 | Spotsylvania | Virginia | 51177 | 463 | 6 |
178296 | 178296 | 2020-05-25 | Spotsylvania | Virginia | 51177 | 422 | 6 |
175251 | 175251 | 2020-05-24 | Spotsylvania | Virginia | 51177 | 401 | 5 |
172208 | 172208 | 2020-05-23 | Spotsylvania | Virginia | 51177 | 386 | 4 |
169167 | 169167 | 2020-05-22 | Spotsylvania | Virginia | 51177 | 373 | 4 |
166131 | 166131 | 2020-05-21 | Spotsylvania | Virginia | 51177 | 366 | 4 |
163102 | 163102 | 2020-05-20 | Spotsylvania | Virginia | 51177 | 351 | 4 |
160074 | 160074 | 2020-05-19 | Spotsylvania | Virginia | 51177 | 339 | 4 |
157050 | 157050 | 2020-05-18 | Spotsylvania | Virginia | 51177 | 319 | 4 |
154033 | 154033 | 2020-05-17 | Spotsylvania | Virginia | 51177 | 312 | 4 |
151022 | 151022 | 2020-05-16 | Spotsylvania | Virginia | 51177 | 304 | 4 |
148013 | 148013 | 2020-05-15 | Spotsylvania | Virginia | 51177 | 291 | 4 |
145010 | 145010 | 2020-05-14 | Spotsylvania | Virginia | 51177 | 282 | 4 |
142013 | 142013 | 2020-05-13 | Spotsylvania | Virginia | 51177 | 270 | 4 |
139017 | 139017 | 2020-05-12 | Spotsylvania | Virginia | 51177 | 261 | 4 |
136026 | 136026 | 2020-05-11 | Spotsylvania | Virginia | 51177 | 257 | 4 |
133036 | 133036 | 2020-05-10 | Spotsylvania | Virginia | 51177 | 248 | 4 |
130046 | 130046 | 2020-05-09 | Spotsylvania | Virginia | 51177 | 239 | 4 |
127056 | 127056 | 2020-05-08 | Spotsylvania | Virginia | 51177 | 233 | 4 |
124071 | 124071 | 2020-05-07 | Spotsylvania | Virginia | 51177 | 230 | 4 |
121090 | 121090 | 2020-05-06 | Spotsylvania | Virginia | 51177 | 206 | 4 |
118126 | 118126 | 2020-05-05 | Spotsylvania | Virginia | 51177 | 206 | 4 |
115167 | 115167 | 2020-05-04 | Spotsylvania | Virginia | 51177 | 195 | 4 |
112284 | 112284 | 2020-05-03 | Spotsylvania | Virginia | 51177 | 186 | 4 |
109410 | 109410 | 2020-05-02 | Spotsylvania | Virginia | 51177 | 174 | 4 |
106541 | 106541 | 2020-05-01 | Spotsylvania | Virginia | 51177 | 155 | 4 |
103677 | 103677 | 2020-04-30 | Spotsylvania | Virginia | 51177 | 143 | 3 |
100822 | 100822 | 2020-04-29 | Spotsylvania | Virginia | 51177 | 131 | 3 |
97972 | 97972 | 2020-04-28 | Spotsylvania | Virginia | 51177 | 126 | 3 |
95128 | 95128 | 2020-04-27 | Spotsylvania | Virginia | 51177 | 119 | 3 |
92299 | 92299 | 2020-04-26 | Spotsylvania | Virginia | 51177 | 107 | 3 |
89482 | 89482 | 2020-04-25 | Spotsylvania | Virginia | 51177 | 101 | 3 |
86667 | 86667 | 2020-04-24 | Spotsylvania | Virginia | 51177 | 97 | 3 |
83860 | 83860 | 2020-04-23 | Spotsylvania | Virginia | 51177 | 94 | 3 |
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);