ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Prince William" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388933 | 388933 | 2020-07-31 | Prince William | Virginia | 51153 | 8838 | 170 |
385716 | 385716 | 2020-07-30 | Prince William | Virginia | 51153 | 8784 | 169 |
382498 | 382498 | 2020-07-29 | Prince William | Virginia | 51153 | 8724 | 168 |
379281 | 379281 | 2020-07-28 | Prince William | Virginia | 51153 | 8663 | 167 |
376065 | 376065 | 2020-07-27 | Prince William | Virginia | 51153 | 8580 | 167 |
372851 | 372851 | 2020-07-26 | Prince William | Virginia | 51153 | 8458 | 167 |
369639 | 369639 | 2020-07-25 | Prince William | Virginia | 51153 | 8417 | 167 |
366430 | 366430 | 2020-07-24 | Prince William | Virginia | 51153 | 8370 | 167 |
363224 | 363224 | 2020-07-23 | Prince William | Virginia | 51153 | 8321 | 165 |
360018 | 360018 | 2020-07-22 | Prince William | Virginia | 51153 | 8265 | 165 |
356813 | 356813 | 2020-07-21 | Prince William | Virginia | 51153 | 8240 | 164 |
353610 | 353610 | 2020-07-20 | Prince William | Virginia | 51153 | 8190 | 162 |
350408 | 350408 | 2020-07-19 | Prince William | Virginia | 51153 | 8152 | 162 |
347207 | 347207 | 2020-07-18 | Prince William | Virginia | 51153 | 8104 | 161 |
344007 | 344007 | 2020-07-17 | Prince William | Virginia | 51153 | 8034 | 161 |
340808 | 340808 | 2020-07-16 | Prince William | Virginia | 51153 | 7978 | 160 |
337612 | 337612 | 2020-07-15 | Prince William | Virginia | 51153 | 7947 | 160 |
334417 | 334417 | 2020-07-14 | Prince William | Virginia | 51153 | 7890 | 157 |
331224 | 331224 | 2020-07-13 | Prince William | Virginia | 51153 | 7847 | 157 |
328038 | 328038 | 2020-07-12 | Prince William | Virginia | 51153 | 7809 | 157 |
324853 | 324853 | 2020-07-11 | Prince William | Virginia | 51153 | 7769 | 156 |
321672 | 321672 | 2020-07-10 | Prince William | Virginia | 51153 | 7742 | 156 |
318493 | 318493 | 2020-07-09 | Prince William | Virginia | 51153 | 7687 | 155 |
315320 | 315320 | 2020-07-08 | Prince William | Virginia | 51153 | 7664 | 151 |
312145 | 312145 | 2020-07-07 | Prince William | Virginia | 51153 | 7638 | 148 |
308976 | 308976 | 2020-07-06 | Prince William | Virginia | 51153 | 7582 | 147 |
305808 | 305808 | 2020-07-05 | Prince William | Virginia | 51153 | 7570 | 147 |
302644 | 302644 | 2020-07-04 | Prince William | Virginia | 51153 | 7484 | 147 |
299480 | 299480 | 2020-07-03 | Prince William | Virginia | 51153 | 7442 | 146 |
296318 | 296318 | 2020-07-02 | Prince William | Virginia | 51153 | 7390 | 143 |
293163 | 293163 | 2020-07-01 | Prince William | Virginia | 51153 | 7331 | 144 |
290010 | 290010 | 2020-06-30 | Prince William | Virginia | 51153 | 7285 | 144 |
286860 | 286860 | 2020-06-29 | Prince William | Virginia | 51153 | 7210 | 139 |
283714 | 283714 | 2020-06-28 | Prince William | Virginia | 51153 | 7204 | 139 |
280568 | 280568 | 2020-06-27 | Prince William | Virginia | 51153 | 7166 | 139 |
277420 | 277420 | 2020-06-26 | Prince William | Virginia | 51153 | 7107 | 138 |
274272 | 274272 | 2020-06-25 | Prince William | Virginia | 51153 | 7064 | 137 |
271132 | 271132 | 2020-06-24 | Prince William | Virginia | 51153 | 7038 | 136 |
267998 | 267998 | 2020-06-23 | Prince William | Virginia | 51153 | 6962 | 134 |
264869 | 264869 | 2020-06-22 | Prince William | Virginia | 51153 | 6904 | 133 |
261740 | 261740 | 2020-06-21 | Prince William | Virginia | 51153 | 6879 | 133 |
258613 | 258613 | 2020-06-20 | Prince William | Virginia | 51153 | 6807 | 131 |
255486 | 255486 | 2020-06-19 | Prince William | Virginia | 51153 | 6756 | 131 |
252367 | 252367 | 2020-06-18 | Prince William | Virginia | 51153 | 6684 | 127 |
249252 | 249252 | 2020-06-17 | Prince William | Virginia | 51153 | 6654 | 127 |
246140 | 246140 | 2020-06-16 | Prince William | Virginia | 51153 | 6621 | 127 |
243027 | 243027 | 2020-06-15 | Prince William | Virginia | 51153 | 6608 | 122 |
239916 | 239916 | 2020-06-14 | Prince William | Virginia | 51153 | 6580 | 120 |
236808 | 236808 | 2020-06-13 | Prince William | Virginia | 51153 | 6509 | 120 |
233701 | 233701 | 2020-06-12 | Prince William | Virginia | 51153 | 6439 | 120 |
230596 | 230596 | 2020-06-11 | Prince William | Virginia | 51153 | 6396 | 118 |
227492 | 227492 | 2020-06-10 | Prince William | Virginia | 51153 | 6376 | 118 |
224392 | 224392 | 2020-06-09 | Prince William | Virginia | 51153 | 6336 | 119 |
221296 | 221296 | 2020-06-08 | Prince William | Virginia | 51153 | 6278 | 118 |
218204 | 218204 | 2020-06-07 | Prince William | Virginia | 51153 | 6207 | 118 |
215114 | 215114 | 2020-06-06 | Prince William | Virginia | 51153 | 6121 | 110 |
212027 | 212027 | 2020-06-05 | Prince William | Virginia | 51153 | 6030 | 110 |
208942 | 208942 | 2020-06-04 | Prince William | Virginia | 51153 | 5932 | 110 |
205860 | 205860 | 2020-06-03 | Prince William | Virginia | 51153 | 5837 | 109 |
202781 | 202781 | 2020-06-02 | Prince William | Virginia | 51153 | 5724 | 104 |
199705 | 199705 | 2020-06-01 | Prince William | Virginia | 51153 | 5663 | 104 |
196632 | 196632 | 2020-05-31 | Prince William | Virginia | 51153 | 5533 | 104 |
193562 | 193562 | 2020-05-30 | Prince William | Virginia | 51153 | 5412 | 104 |
190496 | 190496 | 2020-05-29 | Prince William | Virginia | 51153 | 5270 | 101 |
187432 | 187432 | 2020-05-28 | Prince William | Virginia | 51153 | 5157 | 101 |
184375 | 184375 | 2020-05-27 | Prince William | Virginia | 51153 | 5074 | 99 |
181324 | 181324 | 2020-05-26 | Prince William | Virginia | 51153 | 4992 | 96 |
178280 | 178280 | 2020-05-25 | Prince William | Virginia | 51153 | 4702 | 94 |
175235 | 175235 | 2020-05-24 | Prince William | Virginia | 51153 | 4468 | 84 |
172192 | 172192 | 2020-05-23 | Prince William | Virginia | 51153 | 4408 | 84 |
169151 | 169151 | 2020-05-22 | Prince William | Virginia | 51153 | 4315 | 80 |
166115 | 166115 | 2020-05-21 | Prince William | Virginia | 51153 | 4183 | 79 |
163086 | 163086 | 2020-05-20 | Prince William | Virginia | 51153 | 4054 | 79 |
160058 | 160058 | 2020-05-19 | Prince William | Virginia | 51153 | 3934 | 73 |
157034 | 157034 | 2020-05-18 | Prince William | Virginia | 51153 | 3759 | 70 |
154017 | 154017 | 2020-05-17 | Prince William | Virginia | 51153 | 3666 | 70 |
151006 | 151006 | 2020-05-16 | Prince William | Virginia | 51153 | 3563 | 69 |
147997 | 147997 | 2020-05-15 | Prince William | Virginia | 51153 | 3421 | 67 |
144994 | 144994 | 2020-05-14 | Prince William | Virginia | 51153 | 3351 | 66 |
141997 | 141997 | 2020-05-13 | Prince William | Virginia | 51153 | 3181 | 65 |
139001 | 139001 | 2020-05-12 | Prince William | Virginia | 51153 | 3078 | 58 |
136010 | 136010 | 2020-05-11 | Prince William | Virginia | 51153 | 2991 | 53 |
133020 | 133020 | 2020-05-10 | Prince William | Virginia | 51153 | 2740 | 48 |
130030 | 130030 | 2020-05-09 | Prince William | Virginia | 51153 | 2548 | 47 |
127040 | 127040 | 2020-05-08 | Prince William | Virginia | 51153 | 2474 | 46 |
124055 | 124055 | 2020-05-07 | Prince William | Virginia | 51153 | 2398 | 39 |
121074 | 121074 | 2020-05-06 | Prince William | Virginia | 51153 | 2223 | 33 |
118110 | 118110 | 2020-05-05 | Prince William | Virginia | 51153 | 2223 | 33 |
115151 | 115151 | 2020-05-04 | Prince William | Virginia | 51153 | 2146 | 32 |
112268 | 112268 | 2020-05-03 | Prince William | Virginia | 51153 | 2026 | 30 |
109394 | 109394 | 2020-05-02 | Prince William | Virginia | 51153 | 1900 | 29 |
106525 | 106525 | 2020-05-01 | Prince William | Virginia | 51153 | 1781 | 28 |
103661 | 103661 | 2020-04-30 | Prince William | Virginia | 51153 | 1645 | 24 |
100806 | 100806 | 2020-04-29 | Prince William | Virginia | 51153 | 1527 | 22 |
97956 | 97956 | 2020-04-28 | Prince William | Virginia | 51153 | 1449 | 20 |
95112 | 95112 | 2020-04-27 | Prince William | Virginia | 51153 | 1353 | 20 |
92283 | 92283 | 2020-04-26 | Prince William | Virginia | 51153 | 1265 | 19 |
89466 | 89466 | 2020-04-25 | Prince William | Virginia | 51153 | 1184 | 19 |
86651 | 86651 | 2020-04-24 | Prince William | Virginia | 51153 | 1110 | 18 |
83844 | 83844 | 2020-04-23 | Prince William | Virginia | 51153 | 1027 | 18 |
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);