ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Manassas city" and state = "Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12252 | 12252 | 2020-03-25 | Manassas city | Virginia | 51683 | 2 | 0 |
13894 | 13894 | 2020-03-26 | Manassas city | Virginia | 51683 | 3 | 0 |
15662 | 15662 | 2020-03-27 | Manassas city | Virginia | 51683 | 3 | 0 |
17538 | 17538 | 2020-03-28 | Manassas city | Virginia | 51683 | 4 | 0 |
19500 | 19500 | 2020-03-29 | Manassas city | Virginia | 51683 | 5 | 0 |
21565 | 21565 | 2020-03-30 | Manassas city | Virginia | 51683 | 7 | 0 |
23711 | 23711 | 2020-03-31 | Manassas city | Virginia | 51683 | 8 | 0 |
25927 | 25927 | 2020-04-01 | Manassas city | Virginia | 51683 | 9 | 0 |
28217 | 28217 | 2020-04-02 | Manassas city | Virginia | 51683 | 12 | 0 |
30564 | 30564 | 2020-04-03 | Manassas city | Virginia | 51683 | 13 | 0 |
32963 | 32963 | 2020-04-04 | Manassas city | Virginia | 51683 | 14 | 0 |
35401 | 35401 | 2020-04-05 | Manassas city | Virginia | 51683 | 14 | 0 |
37884 | 37884 | 2020-04-06 | Manassas city | Virginia | 51683 | 17 | 0 |
40418 | 40418 | 2020-04-07 | Manassas city | Virginia | 51683 | 20 | 0 |
42987 | 42987 | 2020-04-08 | Manassas city | Virginia | 51683 | 20 | 0 |
45582 | 45582 | 2020-04-09 | Manassas city | Virginia | 51683 | 25 | 0 |
48208 | 48208 | 2020-04-10 | Manassas city | Virginia | 51683 | 29 | 0 |
50866 | 50866 | 2020-04-11 | Manassas city | Virginia | 51683 | 34 | 0 |
53541 | 53541 | 2020-04-12 | Manassas city | Virginia | 51683 | 34 | 0 |
56231 | 56231 | 2020-04-13 | Manassas city | Virginia | 51683 | 41 | 0 |
58937 | 58937 | 2020-04-14 | Manassas city | Virginia | 51683 | 49 | 0 |
61656 | 61656 | 2020-04-15 | Manassas city | Virginia | 51683 | 53 | 0 |
64389 | 64389 | 2020-04-16 | Manassas city | Virginia | 51683 | 62 | 0 |
67137 | 67137 | 2020-04-17 | Manassas city | Virginia | 51683 | 72 | 0 |
69899 | 69899 | 2020-04-18 | Manassas city | Virginia | 51683 | 82 | 0 |
72669 | 72669 | 2020-04-19 | Manassas city | Virginia | 51683 | 93 | 0 |
75445 | 75445 | 2020-04-20 | Manassas city | Virginia | 51683 | 96 | 0 |
78227 | 78227 | 2020-04-21 | Manassas city | Virginia | 51683 | 110 | 0 |
81020 | 81020 | 2020-04-22 | Manassas city | Virginia | 51683 | 117 | 0 |
83821 | 83821 | 2020-04-23 | Manassas city | Virginia | 51683 | 127 | 1 |
86628 | 86628 | 2020-04-24 | Manassas city | Virginia | 51683 | 137 | 1 |
89443 | 89443 | 2020-04-25 | Manassas city | Virginia | 51683 | 154 | 1 |
92260 | 92260 | 2020-04-26 | Manassas city | Virginia | 51683 | 158 | 2 |
95089 | 95089 | 2020-04-27 | Manassas city | Virginia | 51683 | 165 | 2 |
97932 | 97932 | 2020-04-28 | Manassas city | Virginia | 51683 | 175 | 2 |
100782 | 100782 | 2020-04-29 | Manassas city | Virginia | 51683 | 196 | 3 |
103637 | 103637 | 2020-04-30 | Manassas city | Virginia | 51683 | 216 | 2 |
106501 | 106501 | 2020-05-01 | Manassas city | Virginia | 51683 | 222 | 2 |
109370 | 109370 | 2020-05-02 | Manassas city | Virginia | 51683 | 258 | 2 |
112244 | 112244 | 2020-05-03 | Manassas city | Virginia | 51683 | 266 | 1 |
115127 | 115127 | 2020-05-04 | Manassas city | Virginia | 51683 | 273 | 1 |
118086 | 118086 | 2020-05-05 | Manassas city | Virginia | 51683 | 289 | 1 |
121050 | 121050 | 2020-05-06 | Manassas city | Virginia | 51683 | 289 | 1 |
124031 | 124031 | 2020-05-07 | Manassas city | Virginia | 51683 | 332 | 1 |
127016 | 127016 | 2020-05-08 | Manassas city | Virginia | 51683 | 355 | 2 |
130006 | 130006 | 2020-05-09 | Manassas city | Virginia | 51683 | 358 | 2 |
132996 | 132996 | 2020-05-10 | Manassas city | Virginia | 51683 | 381 | 2 |
135986 | 135986 | 2020-05-11 | Manassas city | Virginia | 51683 | 428 | 3 |
138977 | 138977 | 2020-05-12 | Manassas city | Virginia | 51683 | 430 | 3 |
141973 | 141973 | 2020-05-13 | Manassas city | Virginia | 51683 | 459 | 4 |
144970 | 144970 | 2020-05-14 | Manassas city | Virginia | 51683 | 515 | 5 |
147973 | 147973 | 2020-05-15 | Manassas city | Virginia | 51683 | 533 | 5 |
150982 | 150982 | 2020-05-16 | Manassas city | Virginia | 51683 | 574 | 5 |
153993 | 153993 | 2020-05-17 | Manassas city | Virginia | 51683 | 594 | 5 |
157010 | 157010 | 2020-05-18 | Manassas city | Virginia | 51683 | 628 | 5 |
160034 | 160034 | 2020-05-19 | Manassas city | Virginia | 51683 | 680 | 5 |
163062 | 163062 | 2020-05-20 | Manassas city | Virginia | 51683 | 699 | 6 |
166091 | 166091 | 2020-05-21 | Manassas city | Virginia | 51683 | 743 | 6 |
169127 | 169127 | 2020-05-22 | Manassas city | Virginia | 51683 | 764 | 7 |
172168 | 172168 | 2020-05-23 | Manassas city | Virginia | 51683 | 792 | 7 |
175211 | 175211 | 2020-05-24 | Manassas city | Virginia | 51683 | 806 | 7 |
178256 | 178256 | 2020-05-25 | Manassas city | Virginia | 51683 | 849 | 9 |
181300 | 181300 | 2020-05-26 | Manassas city | Virginia | 51683 | 956 | 9 |
184351 | 184351 | 2020-05-27 | Manassas city | Virginia | 51683 | 966 | 10 |
187408 | 187408 | 2020-05-28 | Manassas city | Virginia | 51683 | 971 | 10 |
190472 | 190472 | 2020-05-29 | Manassas city | Virginia | 51683 | 1004 | 10 |
193538 | 193538 | 2020-05-30 | Manassas city | Virginia | 51683 | 1046 | 10 |
196608 | 196608 | 2020-05-31 | Manassas city | Virginia | 51683 | 1092 | 10 |
199681 | 199681 | 2020-06-01 | Manassas city | Virginia | 51683 | 1105 | 11 |
202757 | 202757 | 2020-06-02 | Manassas city | Virginia | 51683 | 1135 | 11 |
205836 | 205836 | 2020-06-03 | Manassas city | Virginia | 51683 | 1154 | 12 |
208918 | 208918 | 2020-06-04 | Manassas city | Virginia | 51683 | 1166 | 12 |
212003 | 212003 | 2020-06-05 | Manassas city | Virginia | 51683 | 1190 | 12 |
215090 | 215090 | 2020-06-06 | Manassas city | Virginia | 51683 | 1214 | 12 |
218180 | 218180 | 2020-06-07 | Manassas city | Virginia | 51683 | 1228 | 11 |
221272 | 221272 | 2020-06-08 | Manassas city | Virginia | 51683 | 1248 | 11 |
224368 | 224368 | 2020-06-09 | Manassas city | Virginia | 51683 | 1254 | 11 |
227468 | 227468 | 2020-06-10 | Manassas city | Virginia | 51683 | 1262 | 12 |
230572 | 230572 | 2020-06-11 | Manassas city | Virginia | 51683 | 1271 | 12 |
233677 | 233677 | 2020-06-12 | Manassas city | Virginia | 51683 | 1282 | 12 |
236784 | 236784 | 2020-06-13 | Manassas city | Virginia | 51683 | 1299 | 12 |
239892 | 239892 | 2020-06-14 | Manassas city | Virginia | 51683 | 1309 | 12 |
243003 | 243003 | 2020-06-15 | Manassas city | Virginia | 51683 | 1314 | 13 |
246116 | 246116 | 2020-06-16 | Manassas city | Virginia | 51683 | 1317 | 14 |
249228 | 249228 | 2020-06-17 | Manassas city | Virginia | 51683 | 1320 | 14 |
252343 | 252343 | 2020-06-18 | Manassas city | Virginia | 51683 | 1337 | 14 |
255462 | 255462 | 2020-06-19 | Manassas city | Virginia | 51683 | 1352 | 16 |
258589 | 258589 | 2020-06-20 | Manassas city | Virginia | 51683 | 1353 | 16 |
261716 | 261716 | 2020-06-21 | Manassas city | Virginia | 51683 | 1363 | 16 |
264845 | 264845 | 2020-06-22 | Manassas city | Virginia | 51683 | 1366 | 16 |
267974 | 267974 | 2020-06-23 | Manassas city | Virginia | 51683 | 1367 | 16 |
271108 | 271108 | 2020-06-24 | Manassas city | Virginia | 51683 | 1370 | 16 |
274248 | 274248 | 2020-06-25 | Manassas city | Virginia | 51683 | 1374 | 16 |
277396 | 277396 | 2020-06-26 | Manassas city | Virginia | 51683 | 1379 | 16 |
280544 | 280544 | 2020-06-27 | Manassas city | Virginia | 51683 | 1382 | 16 |
283690 | 283690 | 2020-06-28 | Manassas city | Virginia | 51683 | 1387 | 16 |
286836 | 286836 | 2020-06-29 | Manassas city | Virginia | 51683 | 1385 | 16 |
289986 | 289986 | 2020-06-30 | Manassas city | Virginia | 51683 | 1397 | 16 |
293139 | 293139 | 2020-07-01 | Manassas city | Virginia | 51683 | 1414 | 18 |
296294 | 296294 | 2020-07-02 | Manassas city | Virginia | 51683 | 1417 | 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);