ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51153 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 |
---|---|---|---|---|---|---|---|
1596 | 1596 | 2020-03-12 | Prince William | Virginia | 51153 | 1 | 0 |
1906 | 1906 | 2020-03-13 | Prince William | Virginia | 51153 | 2 | 0 |
2278 | 2278 | 2020-03-14 | Prince William | Virginia | 51153 | 2 | 0 |
2705 | 2705 | 2020-03-15 | Prince William | Virginia | 51153 | 3 | 0 |
3177 | 3177 | 2020-03-16 | Prince William | Virginia | 51153 | 3 | 0 |
3716 | 3716 | 2020-03-17 | Prince William | Virginia | 51153 | 4 | 0 |
4349 | 4349 | 2020-03-18 | Prince William | Virginia | 51153 | 4 | 0 |
5105 | 5105 | 2020-03-19 | Prince William | Virginia | 51153 | 12 | 0 |
6006 | 6006 | 2020-03-20 | Prince William | Virginia | 51153 | 12 | 0 |
7036 | 7036 | 2020-03-21 | Prince William | Virginia | 51153 | 14 | 0 |
8172 | 8172 | 2020-03-22 | Prince William | Virginia | 51153 | 18 | 0 |
9394 | 9394 | 2020-03-23 | Prince William | Virginia | 51153 | 18 | 0 |
10742 | 10742 | 2020-03-24 | Prince William | Virginia | 51153 | 23 | 0 |
12262 | 12262 | 2020-03-25 | Prince William | Virginia | 51153 | 32 | 0 |
13908 | 13908 | 2020-03-26 | Prince William | Virginia | 51153 | 44 | 0 |
15676 | 15676 | 2020-03-27 | Prince William | Virginia | 51153 | 44 | 0 |
17556 | 17556 | 2020-03-28 | Prince William | Virginia | 51153 | 56 | 0 |
19518 | 19518 | 2020-03-29 | Prince William | Virginia | 51153 | 72 | 0 |
21584 | 21584 | 2020-03-30 | Prince William | Virginia | 51153 | 79 | 0 |
23731 | 23731 | 2020-03-31 | Prince William | Virginia | 51153 | 94 | 0 |
25947 | 25947 | 2020-04-01 | Prince William | Virginia | 51153 | 106 | 1 |
28237 | 28237 | 2020-04-02 | Prince William | Virginia | 51153 | 117 | 1 |
30584 | 30584 | 2020-04-03 | Prince William | Virginia | 51153 | 131 | 1 |
32983 | 32983 | 2020-04-04 | Prince William | Virginia | 51153 | 159 | 1 |
35421 | 35421 | 2020-04-05 | Prince William | Virginia | 51153 | 175 | 1 |
37904 | 37904 | 2020-04-06 | Prince William | Virginia | 51153 | 193 | 1 |
40438 | 40438 | 2020-04-07 | Prince William | Virginia | 51153 | 236 | 1 |
43007 | 43007 | 2020-04-08 | Prince William | Virginia | 51153 | 263 | 1 |
45603 | 45603 | 2020-04-09 | Prince William | Virginia | 51153 | 299 | 1 |
48229 | 48229 | 2020-04-10 | Prince William | Virginia | 51153 | 337 | 1 |
50887 | 50887 | 2020-04-11 | Prince William | Virginia | 51153 | 390 | 1 |
53562 | 53562 | 2020-04-12 | Prince William | Virginia | 51153 | 389 | 1 |
56252 | 56252 | 2020-04-13 | Prince William | Virginia | 51153 | 434 | 1 |
58958 | 58958 | 2020-04-14 | Prince William | Virginia | 51153 | 508 | 1 |
61677 | 61677 | 2020-04-15 | Prince William | Virginia | 51153 | 536 | 1 |
64410 | 64410 | 2020-04-16 | Prince William | Virginia | 51153 | 582 | 1 |
67158 | 67158 | 2020-04-17 | Prince William | Virginia | 51153 | 644 | 1 |
69920 | 69920 | 2020-04-18 | Prince William | Virginia | 51153 | 700 | 1 |
72690 | 72690 | 2020-04-19 | Prince William | Virginia | 51153 | 742 | 1 |
75466 | 75466 | 2020-04-20 | Prince William | Virginia | 51153 | 793 | 1 |
78250 | 78250 | 2020-04-21 | Prince William | Virginia | 51153 | 867 | 16 |
81043 | 81043 | 2020-04-22 | Prince William | Virginia | 51153 | 924 | 17 |
83844 | 83844 | 2020-04-23 | Prince William | Virginia | 51153 | 1027 | 18 |
86651 | 86651 | 2020-04-24 | Prince William | Virginia | 51153 | 1110 | 18 |
89466 | 89466 | 2020-04-25 | Prince William | Virginia | 51153 | 1184 | 19 |
92283 | 92283 | 2020-04-26 | Prince William | Virginia | 51153 | 1265 | 19 |
95112 | 95112 | 2020-04-27 | Prince William | Virginia | 51153 | 1353 | 20 |
97956 | 97956 | 2020-04-28 | Prince William | Virginia | 51153 | 1449 | 20 |
100806 | 100806 | 2020-04-29 | Prince William | Virginia | 51153 | 1527 | 22 |
103661 | 103661 | 2020-04-30 | Prince William | Virginia | 51153 | 1645 | 24 |
106525 | 106525 | 2020-05-01 | Prince William | Virginia | 51153 | 1781 | 28 |
109394 | 109394 | 2020-05-02 | Prince William | Virginia | 51153 | 1900 | 29 |
112268 | 112268 | 2020-05-03 | Prince William | Virginia | 51153 | 2026 | 30 |
115151 | 115151 | 2020-05-04 | Prince William | Virginia | 51153 | 2146 | 32 |
118110 | 118110 | 2020-05-05 | Prince William | Virginia | 51153 | 2223 | 33 |
121074 | 121074 | 2020-05-06 | Prince William | Virginia | 51153 | 2223 | 33 |
124055 | 124055 | 2020-05-07 | Prince William | Virginia | 51153 | 2398 | 39 |
127040 | 127040 | 2020-05-08 | Prince William | Virginia | 51153 | 2474 | 46 |
130030 | 130030 | 2020-05-09 | Prince William | Virginia | 51153 | 2548 | 47 |
133020 | 133020 | 2020-05-10 | Prince William | Virginia | 51153 | 2740 | 48 |
136010 | 136010 | 2020-05-11 | Prince William | Virginia | 51153 | 2991 | 53 |
139001 | 139001 | 2020-05-12 | Prince William | Virginia | 51153 | 3078 | 58 |
141997 | 141997 | 2020-05-13 | Prince William | Virginia | 51153 | 3181 | 65 |
144994 | 144994 | 2020-05-14 | Prince William | Virginia | 51153 | 3351 | 66 |
147997 | 147997 | 2020-05-15 | Prince William | Virginia | 51153 | 3421 | 67 |
151006 | 151006 | 2020-05-16 | Prince William | Virginia | 51153 | 3563 | 69 |
154017 | 154017 | 2020-05-17 | Prince William | Virginia | 51153 | 3666 | 70 |
157034 | 157034 | 2020-05-18 | Prince William | Virginia | 51153 | 3759 | 70 |
160058 | 160058 | 2020-05-19 | Prince William | Virginia | 51153 | 3934 | 73 |
163086 | 163086 | 2020-05-20 | Prince William | Virginia | 51153 | 4054 | 79 |
166115 | 166115 | 2020-05-21 | Prince William | Virginia | 51153 | 4183 | 79 |
169151 | 169151 | 2020-05-22 | Prince William | Virginia | 51153 | 4315 | 80 |
172192 | 172192 | 2020-05-23 | Prince William | Virginia | 51153 | 4408 | 84 |
175235 | 175235 | 2020-05-24 | Prince William | Virginia | 51153 | 4468 | 84 |
178280 | 178280 | 2020-05-25 | Prince William | Virginia | 51153 | 4702 | 94 |
181324 | 181324 | 2020-05-26 | Prince William | Virginia | 51153 | 4992 | 96 |
184375 | 184375 | 2020-05-27 | Prince William | Virginia | 51153 | 5074 | 99 |
187432 | 187432 | 2020-05-28 | Prince William | Virginia | 51153 | 5157 | 101 |
190496 | 190496 | 2020-05-29 | Prince William | Virginia | 51153 | 5270 | 101 |
193562 | 193562 | 2020-05-30 | Prince William | Virginia | 51153 | 5412 | 104 |
196632 | 196632 | 2020-05-31 | Prince William | Virginia | 51153 | 5533 | 104 |
199705 | 199705 | 2020-06-01 | Prince William | Virginia | 51153 | 5663 | 104 |
202781 | 202781 | 2020-06-02 | Prince William | Virginia | 51153 | 5724 | 104 |
205860 | 205860 | 2020-06-03 | Prince William | Virginia | 51153 | 5837 | 109 |
208942 | 208942 | 2020-06-04 | Prince William | Virginia | 51153 | 5932 | 110 |
212027 | 212027 | 2020-06-05 | Prince William | Virginia | 51153 | 6030 | 110 |
215114 | 215114 | 2020-06-06 | Prince William | Virginia | 51153 | 6121 | 110 |
218204 | 218204 | 2020-06-07 | Prince William | Virginia | 51153 | 6207 | 118 |
221296 | 221296 | 2020-06-08 | Prince William | Virginia | 51153 | 6278 | 118 |
224392 | 224392 | 2020-06-09 | Prince William | Virginia | 51153 | 6336 | 119 |
227492 | 227492 | 2020-06-10 | Prince William | Virginia | 51153 | 6376 | 118 |
230596 | 230596 | 2020-06-11 | Prince William | Virginia | 51153 | 6396 | 118 |
233701 | 233701 | 2020-06-12 | Prince William | Virginia | 51153 | 6439 | 120 |
236808 | 236808 | 2020-06-13 | Prince William | Virginia | 51153 | 6509 | 120 |
239916 | 239916 | 2020-06-14 | Prince William | Virginia | 51153 | 6580 | 120 |
243027 | 243027 | 2020-06-15 | Prince William | Virginia | 51153 | 6608 | 122 |
246140 | 246140 | 2020-06-16 | Prince William | Virginia | 51153 | 6621 | 127 |
249252 | 249252 | 2020-06-17 | Prince William | Virginia | 51153 | 6654 | 127 |
252367 | 252367 | 2020-06-18 | Prince William | Virginia | 51153 | 6684 | 127 |
255486 | 255486 | 2020-06-19 | Prince William | Virginia | 51153 | 6756 | 131 |
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);