ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Stafford" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388950 | 388950 | 2020-07-31 | Stafford | Virginia | 51179 | 1243 | 7 |
385733 | 385733 | 2020-07-30 | Stafford | Virginia | 51179 | 1237 | 7 |
382515 | 382515 | 2020-07-29 | Stafford | Virginia | 51179 | 1227 | 7 |
379298 | 379298 | 2020-07-28 | Stafford | Virginia | 51179 | 1214 | 7 |
376082 | 376082 | 2020-07-27 | Stafford | Virginia | 51179 | 1202 | 7 |
372868 | 372868 | 2020-07-26 | Stafford | Virginia | 51179 | 1185 | 7 |
369656 | 369656 | 2020-07-25 | Stafford | Virginia | 51179 | 1176 | 7 |
366447 | 366447 | 2020-07-24 | Stafford | Virginia | 51179 | 1169 | 7 |
363241 | 363241 | 2020-07-23 | Stafford | Virginia | 51179 | 1163 | 7 |
360035 | 360035 | 2020-07-22 | Stafford | Virginia | 51179 | 1151 | 6 |
356830 | 356830 | 2020-07-21 | Stafford | Virginia | 51179 | 1140 | 6 |
353627 | 353627 | 2020-07-20 | Stafford | Virginia | 51179 | 1128 | 6 |
350425 | 350425 | 2020-07-19 | Stafford | Virginia | 51179 | 1119 | 6 |
347224 | 347224 | 2020-07-18 | Stafford | Virginia | 51179 | 1112 | 6 |
344024 | 344024 | 2020-07-17 | Stafford | Virginia | 51179 | 1101 | 6 |
340825 | 340825 | 2020-07-16 | Stafford | Virginia | 51179 | 1096 | 6 |
337629 | 337629 | 2020-07-15 | Stafford | Virginia | 51179 | 1085 | 6 |
334434 | 334434 | 2020-07-14 | Stafford | Virginia | 51179 | 1075 | 6 |
331241 | 331241 | 2020-07-13 | Stafford | Virginia | 51179 | 1065 | 6 |
328055 | 328055 | 2020-07-12 | Stafford | Virginia | 51179 | 1060 | 6 |
324870 | 324870 | 2020-07-11 | Stafford | Virginia | 51179 | 1056 | 6 |
321689 | 321689 | 2020-07-10 | Stafford | Virginia | 51179 | 1048 | 6 |
318510 | 318510 | 2020-07-09 | Stafford | Virginia | 51179 | 1038 | 6 |
315337 | 315337 | 2020-07-08 | Stafford | Virginia | 51179 | 1029 | 5 |
312162 | 312162 | 2020-07-07 | Stafford | Virginia | 51179 | 1022 | 5 |
308993 | 308993 | 2020-07-06 | Stafford | Virginia | 51179 | 1012 | 5 |
305825 | 305825 | 2020-07-05 | Stafford | Virginia | 51179 | 1011 | 5 |
302661 | 302661 | 2020-07-04 | Stafford | Virginia | 51179 | 1008 | 5 |
299497 | 299497 | 2020-07-03 | Stafford | Virginia | 51179 | 998 | 5 |
296335 | 296335 | 2020-07-02 | Stafford | Virginia | 51179 | 1000 | 5 |
293180 | 293180 | 2020-07-01 | Stafford | Virginia | 51179 | 990 | 5 |
290027 | 290027 | 2020-06-30 | Stafford | Virginia | 51179 | 988 | 5 |
286877 | 286877 | 2020-06-29 | Stafford | Virginia | 51179 | 985 | 5 |
283731 | 283731 | 2020-06-28 | Stafford | Virginia | 51179 | 983 | 5 |
280585 | 280585 | 2020-06-27 | Stafford | Virginia | 51179 | 974 | 5 |
277437 | 277437 | 2020-06-26 | Stafford | Virginia | 51179 | 965 | 5 |
274289 | 274289 | 2020-06-25 | Stafford | Virginia | 51179 | 954 | 5 |
271149 | 271149 | 2020-06-24 | Stafford | Virginia | 51179 | 949 | 5 |
268015 | 268015 | 2020-06-23 | Stafford | Virginia | 51179 | 936 | 5 |
264886 | 264886 | 2020-06-22 | Stafford | Virginia | 51179 | 930 | 5 |
261757 | 261757 | 2020-06-21 | Stafford | Virginia | 51179 | 924 | 5 |
258630 | 258630 | 2020-06-20 | Stafford | Virginia | 51179 | 920 | 5 |
255503 | 255503 | 2020-06-19 | Stafford | Virginia | 51179 | 921 | 5 |
252384 | 252384 | 2020-06-18 | Stafford | Virginia | 51179 | 917 | 5 |
249269 | 249269 | 2020-06-17 | Stafford | Virginia | 51179 | 906 | 5 |
246157 | 246157 | 2020-06-16 | Stafford | Virginia | 51179 | 900 | 5 |
243044 | 243044 | 2020-06-15 | Stafford | Virginia | 51179 | 893 | 5 |
239933 | 239933 | 2020-06-14 | Stafford | Virginia | 51179 | 887 | 5 |
236825 | 236825 | 2020-06-13 | Stafford | Virginia | 51179 | 877 | 5 |
233718 | 233718 | 2020-06-12 | Stafford | Virginia | 51179 | 862 | 5 |
230613 | 230613 | 2020-06-11 | Stafford | Virginia | 51179 | 841 | 5 |
227509 | 227509 | 2020-06-10 | Stafford | Virginia | 51179 | 831 | 5 |
224409 | 224409 | 2020-06-09 | Stafford | Virginia | 51179 | 824 | 5 |
221313 | 221313 | 2020-06-08 | Stafford | Virginia | 51179 | 815 | 5 |
218221 | 218221 | 2020-06-07 | Stafford | Virginia | 51179 | 803 | 5 |
215131 | 215131 | 2020-06-06 | Stafford | Virginia | 51179 | 765 | 5 |
212044 | 212044 | 2020-06-05 | Stafford | Virginia | 51179 | 750 | 5 |
208959 | 208959 | 2020-06-04 | Stafford | Virginia | 51179 | 742 | 5 |
205877 | 205877 | 2020-06-03 | Stafford | Virginia | 51179 | 738 | 5 |
202798 | 202798 | 2020-06-02 | Stafford | Virginia | 51179 | 733 | 5 |
199722 | 199722 | 2020-06-01 | Stafford | Virginia | 51179 | 722 | 5 |
196649 | 196649 | 2020-05-31 | Stafford | Virginia | 51179 | 713 | 4 |
193579 | 193579 | 2020-05-30 | Stafford | Virginia | 51179 | 702 | 4 |
190513 | 190513 | 2020-05-29 | Stafford | Virginia | 51179 | 681 | 4 |
187449 | 187449 | 2020-05-28 | Stafford | Virginia | 51179 | 672 | 4 |
184392 | 184392 | 2020-05-27 | Stafford | Virginia | 51179 | 657 | 4 |
181341 | 181341 | 2020-05-26 | Stafford | Virginia | 51179 | 642 | 4 |
178297 | 178297 | 2020-05-25 | Stafford | Virginia | 51179 | 599 | 4 |
175252 | 175252 | 2020-05-24 | Stafford | Virginia | 51179 | 581 | 4 |
172209 | 172209 | 2020-05-23 | Stafford | Virginia | 51179 | 569 | 4 |
169168 | 169168 | 2020-05-22 | Stafford | Virginia | 51179 | 552 | 4 |
166132 | 166132 | 2020-05-21 | Stafford | Virginia | 51179 | 540 | 4 |
163103 | 163103 | 2020-05-20 | Stafford | Virginia | 51179 | 514 | 4 |
160075 | 160075 | 2020-05-19 | Stafford | Virginia | 51179 | 501 | 4 |
157051 | 157051 | 2020-05-18 | Stafford | Virginia | 51179 | 484 | 4 |
154034 | 154034 | 2020-05-17 | Stafford | Virginia | 51179 | 467 | 4 |
151023 | 151023 | 2020-05-16 | Stafford | Virginia | 51179 | 458 | 4 |
148014 | 148014 | 2020-05-15 | Stafford | Virginia | 51179 | 442 | 4 |
145011 | 145011 | 2020-05-14 | Stafford | Virginia | 51179 | 426 | 4 |
142014 | 142014 | 2020-05-13 | Stafford | Virginia | 51179 | 413 | 4 |
139018 | 139018 | 2020-05-12 | Stafford | Virginia | 51179 | 396 | 4 |
136027 | 136027 | 2020-05-11 | Stafford | Virginia | 51179 | 384 | 2 |
133037 | 133037 | 2020-05-10 | Stafford | Virginia | 51179 | 374 | 2 |
130047 | 130047 | 2020-05-09 | Stafford | Virginia | 51179 | 354 | 2 |
127057 | 127057 | 2020-05-08 | Stafford | Virginia | 51179 | 344 | 2 |
124072 | 124072 | 2020-05-07 | Stafford | Virginia | 51179 | 334 | 2 |
121091 | 121091 | 2020-05-06 | Stafford | Virginia | 51179 | 308 | 2 |
118127 | 118127 | 2020-05-05 | Stafford | Virginia | 51179 | 308 | 2 |
115168 | 115168 | 2020-05-04 | Stafford | Virginia | 51179 | 288 | 2 |
112285 | 112285 | 2020-05-03 | Stafford | Virginia | 51179 | 271 | 2 |
109411 | 109411 | 2020-05-02 | Stafford | Virginia | 51179 | 262 | 2 |
106542 | 106542 | 2020-05-01 | Stafford | Virginia | 51179 | 251 | 2 |
103678 | 103678 | 2020-04-30 | Stafford | Virginia | 51179 | 240 | 2 |
100823 | 100823 | 2020-04-29 | Stafford | Virginia | 51179 | 225 | 2 |
97973 | 97973 | 2020-04-28 | Stafford | Virginia | 51179 | 221 | 2 |
95129 | 95129 | 2020-04-27 | Stafford | Virginia | 51179 | 218 | 2 |
92300 | 92300 | 2020-04-26 | Stafford | Virginia | 51179 | 213 | 2 |
89483 | 89483 | 2020-04-25 | Stafford | Virginia | 51179 | 198 | 2 |
86668 | 86668 | 2020-04-24 | Stafford | Virginia | 51179 | 193 | 2 |
83861 | 83861 | 2020-04-23 | Stafford | Virginia | 51179 | 180 | 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);