ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Williamsburg city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388961 | 388961 | 2020-07-31 | Williamsburg city | Virginia | 51830 | 107 | 6 |
385744 | 385744 | 2020-07-30 | Williamsburg city | Virginia | 51830 | 106 | 6 |
382526 | 382526 | 2020-07-29 | Williamsburg city | Virginia | 51830 | 105 | 6 |
379309 | 379309 | 2020-07-28 | Williamsburg city | Virginia | 51830 | 105 | 6 |
376093 | 376093 | 2020-07-27 | Williamsburg city | Virginia | 51830 | 105 | 6 |
372879 | 372879 | 2020-07-26 | Williamsburg city | Virginia | 51830 | 102 | 6 |
369667 | 369667 | 2020-07-25 | Williamsburg city | Virginia | 51830 | 101 | 6 |
366458 | 366458 | 2020-07-24 | Williamsburg city | Virginia | 51830 | 100 | 6 |
363252 | 363252 | 2020-07-23 | Williamsburg city | Virginia | 51830 | 99 | 6 |
360046 | 360046 | 2020-07-22 | Williamsburg city | Virginia | 51830 | 97 | 6 |
356841 | 356841 | 2020-07-21 | Williamsburg city | Virginia | 51830 | 96 | 6 |
353638 | 353638 | 2020-07-20 | Williamsburg city | Virginia | 51830 | 94 | 6 |
350436 | 350436 | 2020-07-19 | Williamsburg city | Virginia | 51830 | 94 | 6 |
347235 | 347235 | 2020-07-18 | Williamsburg city | Virginia | 51830 | 91 | 6 |
344035 | 344035 | 2020-07-17 | Williamsburg city | Virginia | 51830 | 91 | 6 |
340836 | 340836 | 2020-07-16 | Williamsburg city | Virginia | 51830 | 88 | 6 |
337640 | 337640 | 2020-07-15 | Williamsburg city | Virginia | 51830 | 87 | 6 |
334445 | 334445 | 2020-07-14 | Williamsburg city | Virginia | 51830 | 85 | 6 |
331252 | 331252 | 2020-07-13 | Williamsburg city | Virginia | 51830 | 82 | 6 |
328066 | 328066 | 2020-07-12 | Williamsburg city | Virginia | 51830 | 78 | 6 |
324881 | 324881 | 2020-07-11 | Williamsburg city | Virginia | 51830 | 78 | 6 |
321700 | 321700 | 2020-07-10 | Williamsburg city | Virginia | 51830 | 78 | 6 |
318521 | 318521 | 2020-07-09 | Williamsburg city | Virginia | 51830 | 78 | 6 |
315348 | 315348 | 2020-07-08 | Williamsburg city | Virginia | 51830 | 77 | 6 |
312173 | 312173 | 2020-07-07 | Williamsburg city | Virginia | 51830 | 75 | 6 |
309004 | 309004 | 2020-07-06 | Williamsburg city | Virginia | 51830 | 74 | 6 |
305836 | 305836 | 2020-07-05 | Williamsburg city | Virginia | 51830 | 72 | 6 |
302672 | 302672 | 2020-07-04 | Williamsburg city | Virginia | 51830 | 64 | 6 |
299508 | 299508 | 2020-07-03 | Williamsburg city | Virginia | 51830 | 61 | 6 |
296346 | 296346 | 2020-07-02 | Williamsburg city | Virginia | 51830 | 61 | 6 |
293191 | 293191 | 2020-07-01 | Williamsburg city | Virginia | 51830 | 61 | 6 |
290038 | 290038 | 2020-06-30 | Williamsburg city | Virginia | 51830 | 60 | 6 |
286888 | 286888 | 2020-06-29 | Williamsburg city | Virginia | 51830 | 56 | 6 |
283742 | 283742 | 2020-06-28 | Williamsburg city | Virginia | 51830 | 55 | 6 |
280596 | 280596 | 2020-06-27 | Williamsburg city | Virginia | 51830 | 55 | 6 |
277448 | 277448 | 2020-06-26 | Williamsburg city | Virginia | 51830 | 55 | 6 |
274300 | 274300 | 2020-06-25 | Williamsburg city | Virginia | 51830 | 55 | 6 |
271160 | 271160 | 2020-06-24 | Williamsburg city | Virginia | 51830 | 54 | 5 |
268026 | 268026 | 2020-06-23 | Williamsburg city | Virginia | 51830 | 54 | 5 |
264897 | 264897 | 2020-06-22 | Williamsburg city | Virginia | 51830 | 54 | 5 |
261768 | 261768 | 2020-06-21 | Williamsburg city | Virginia | 51830 | 54 | 5 |
258641 | 258641 | 2020-06-20 | Williamsburg city | Virginia | 51830 | 54 | 5 |
255514 | 255514 | 2020-06-19 | Williamsburg city | Virginia | 51830 | 54 | 5 |
252395 | 252395 | 2020-06-18 | Williamsburg city | Virginia | 51830 | 54 | 5 |
249280 | 249280 | 2020-06-17 | Williamsburg city | Virginia | 51830 | 54 | 5 |
246168 | 246168 | 2020-06-16 | Williamsburg city | Virginia | 51830 | 53 | 5 |
243055 | 243055 | 2020-06-15 | Williamsburg city | Virginia | 51830 | 50 | 5 |
239944 | 239944 | 2020-06-14 | Williamsburg city | Virginia | 51830 | 50 | 5 |
236836 | 236836 | 2020-06-13 | Williamsburg city | Virginia | 51830 | 49 | 5 |
233729 | 233729 | 2020-06-12 | Williamsburg city | Virginia | 51830 | 49 | 5 |
230624 | 230624 | 2020-06-11 | Williamsburg city | Virginia | 51830 | 49 | 5 |
227520 | 227520 | 2020-06-10 | Williamsburg city | Virginia | 51830 | 48 | 5 |
224420 | 224420 | 2020-06-09 | Williamsburg city | Virginia | 51830 | 48 | 5 |
221324 | 221324 | 2020-06-08 | Williamsburg city | Virginia | 51830 | 46 | 5 |
218232 | 218232 | 2020-06-07 | Williamsburg city | Virginia | 51830 | 46 | 5 |
215142 | 215142 | 2020-06-06 | Williamsburg city | Virginia | 51830 | 45 | 5 |
212055 | 212055 | 2020-06-05 | Williamsburg city | Virginia | 51830 | 45 | 5 |
208970 | 208970 | 2020-06-04 | Williamsburg city | Virginia | 51830 | 45 | 5 |
205888 | 205888 | 2020-06-03 | Williamsburg city | Virginia | 51830 | 45 | 4 |
202809 | 202809 | 2020-06-02 | Williamsburg city | Virginia | 51830 | 44 | 4 |
199733 | 199733 | 2020-06-01 | Williamsburg city | Virginia | 51830 | 44 | 4 |
196660 | 196660 | 2020-05-31 | Williamsburg city | Virginia | 51830 | 44 | 4 |
193590 | 193590 | 2020-05-30 | Williamsburg city | Virginia | 51830 | 44 | 4 |
190524 | 190524 | 2020-05-29 | Williamsburg city | Virginia | 51830 | 44 | 4 |
187460 | 187460 | 2020-05-28 | Williamsburg city | Virginia | 51830 | 44 | 4 |
184403 | 184403 | 2020-05-27 | Williamsburg city | Virginia | 51830 | 43 | 3 |
181352 | 181352 | 2020-05-26 | Williamsburg city | Virginia | 51830 | 43 | 3 |
178308 | 178308 | 2020-05-25 | Williamsburg city | Virginia | 51830 | 43 | 3 |
175263 | 175263 | 2020-05-24 | Williamsburg city | Virginia | 51830 | 43 | 3 |
172220 | 172220 | 2020-05-23 | Williamsburg city | Virginia | 51830 | 43 | 3 |
169179 | 169179 | 2020-05-22 | Williamsburg city | Virginia | 51830 | 43 | 3 |
166143 | 166143 | 2020-05-21 | Williamsburg city | Virginia | 51830 | 43 | 3 |
163114 | 163114 | 2020-05-20 | Williamsburg city | Virginia | 51830 | 43 | 3 |
160086 | 160086 | 2020-05-19 | Williamsburg city | Virginia | 51830 | 43 | 3 |
157062 | 157062 | 2020-05-18 | Williamsburg city | Virginia | 51830 | 43 | 3 |
154045 | 154045 | 2020-05-17 | Williamsburg city | Virginia | 51830 | 43 | 3 |
151034 | 151034 | 2020-05-16 | Williamsburg city | Virginia | 51830 | 43 | 3 |
148025 | 148025 | 2020-05-15 | Williamsburg city | Virginia | 51830 | 42 | 3 |
145022 | 145022 | 2020-05-14 | Williamsburg city | Virginia | 51830 | 42 | 3 |
142025 | 142025 | 2020-05-13 | Williamsburg city | Virginia | 51830 | 42 | 3 |
139029 | 139029 | 2020-05-12 | Williamsburg city | Virginia | 51830 | 42 | 3 |
136038 | 136038 | 2020-05-11 | Williamsburg city | Virginia | 51830 | 42 | 3 |
133048 | 133048 | 2020-05-10 | Williamsburg city | Virginia | 51830 | 39 | 2 |
130058 | 130058 | 2020-05-09 | Williamsburg city | Virginia | 51830 | 31 | 2 |
127068 | 127068 | 2020-05-08 | Williamsburg city | Virginia | 51830 | 31 | 2 |
124083 | 124083 | 2020-05-07 | Williamsburg city | Virginia | 51830 | 29 | 2 |
121103 | 121103 | 2020-05-06 | Williamsburg city | Virginia | 51830 | 27 | 2 |
118139 | 118139 | 2020-05-05 | Williamsburg city | Virginia | 51830 | 27 | 2 |
115180 | 115180 | 2020-05-04 | Williamsburg city | Virginia | 51830 | 23 | 2 |
112297 | 112297 | 2020-05-03 | Williamsburg city | Virginia | 51830 | 22 | 2 |
109423 | 109423 | 2020-05-02 | Williamsburg city | Virginia | 51830 | 21 | 2 |
106554 | 106554 | 2020-05-01 | Williamsburg city | Virginia | 51830 | 20 | 1 |
103690 | 103690 | 2020-04-30 | Williamsburg city | Virginia | 51830 | 18 | 1 |
100835 | 100835 | 2020-04-29 | Williamsburg city | Virginia | 51830 | 18 | 1 |
97985 | 97985 | 2020-04-28 | Williamsburg city | Virginia | 51830 | 18 | 1 |
95140 | 95140 | 2020-04-27 | Williamsburg city | Virginia | 51830 | 15 | 1 |
92311 | 92311 | 2020-04-26 | Williamsburg city | Virginia | 51830 | 15 | 1 |
89494 | 89494 | 2020-04-25 | Williamsburg city | Virginia | 51830 | 15 | 1 |
86679 | 86679 | 2020-04-24 | Williamsburg city | Virginia | 51830 | 15 | 1 |
83872 | 83872 | 2020-04-23 | Williamsburg city | Virginia | 51830 | 15 | 1 |
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);