ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51700 and state = "Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6002 | 6002 | 2020-03-20 | Newport News city | Virginia | 51700 | 1 | 0 |
7032 | 7032 | 2020-03-21 | Newport News city | Virginia | 51700 | 2 | 0 |
8168 | 8168 | 2020-03-22 | Newport News city | Virginia | 51700 | 2 | 1 |
9390 | 9390 | 2020-03-23 | Newport News city | Virginia | 51700 | 2 | 1 |
10738 | 10738 | 2020-03-24 | Newport News city | Virginia | 51700 | 3 | 1 |
12256 | 12256 | 2020-03-25 | Newport News city | Virginia | 51700 | 4 | 1 |
13898 | 13898 | 2020-03-26 | Newport News city | Virginia | 51700 | 8 | 1 |
15666 | 15666 | 2020-03-27 | Newport News city | Virginia | 51700 | 12 | 1 |
17544 | 17544 | 2020-03-28 | Newport News city | Virginia | 51700 | 13 | 1 |
19506 | 19506 | 2020-03-29 | Newport News city | Virginia | 51700 | 17 | 1 |
21571 | 21571 | 2020-03-30 | Newport News city | Virginia | 51700 | 18 | 1 |
23717 | 23717 | 2020-03-31 | Newport News city | Virginia | 51700 | 23 | 1 |
25933 | 25933 | 2020-04-01 | Newport News city | Virginia | 51700 | 29 | 1 |
28223 | 28223 | 2020-04-02 | Newport News city | Virginia | 51700 | 33 | 1 |
30570 | 30570 | 2020-04-03 | Newport News city | Virginia | 51700 | 37 | 1 |
32969 | 32969 | 2020-04-04 | Newport News city | Virginia | 51700 | 48 | 1 |
35407 | 35407 | 2020-04-05 | Newport News city | Virginia | 51700 | 51 | 1 |
37890 | 37890 | 2020-04-06 | Newport News city | Virginia | 51700 | 54 | 1 |
40424 | 40424 | 2020-04-07 | Newport News city | Virginia | 51700 | 57 | 1 |
42993 | 42993 | 2020-04-08 | Newport News city | Virginia | 51700 | 60 | 1 |
45589 | 45589 | 2020-04-09 | Newport News city | Virginia | 51700 | 64 | 1 |
48215 | 48215 | 2020-04-10 | Newport News city | Virginia | 51700 | 68 | 1 |
50873 | 50873 | 2020-04-11 | Newport News city | Virginia | 51700 | 75 | 1 |
53548 | 53548 | 2020-04-12 | Newport News city | Virginia | 51700 | 78 | 1 |
56238 | 56238 | 2020-04-13 | Newport News city | Virginia | 51700 | 88 | 1 |
58944 | 58944 | 2020-04-14 | Newport News city | Virginia | 51700 | 93 | 1 |
61663 | 61663 | 2020-04-15 | Newport News city | Virginia | 51700 | 95 | 1 |
64396 | 64396 | 2020-04-16 | Newport News city | Virginia | 51700 | 97 | 1 |
67144 | 67144 | 2020-04-17 | Newport News city | Virginia | 51700 | 100 | 1 |
69906 | 69906 | 2020-04-18 | Newport News city | Virginia | 51700 | 102 | 1 |
72676 | 72676 | 2020-04-19 | Newport News city | Virginia | 51700 | 101 | 1 |
75452 | 75452 | 2020-04-20 | Newport News city | Virginia | 51700 | 102 | 1 |
78234 | 78234 | 2020-04-21 | Newport News city | Virginia | 51700 | 101 | 6 |
81027 | 81027 | 2020-04-22 | Newport News city | Virginia | 51700 | 101 | 6 |
83828 | 83828 | 2020-04-23 | Newport News city | Virginia | 51700 | 105 | 6 |
86635 | 86635 | 2020-04-24 | Newport News city | Virginia | 51700 | 107 | 6 |
89450 | 89450 | 2020-04-25 | Newport News city | Virginia | 51700 | 109 | 6 |
92267 | 92267 | 2020-04-26 | Newport News city | Virginia | 51700 | 111 | 6 |
95096 | 95096 | 2020-04-27 | Newport News city | Virginia | 51700 | 112 | 7 |
97940 | 97940 | 2020-04-28 | Newport News city | Virginia | 51700 | 112 | 7 |
100790 | 100790 | 2020-04-29 | Newport News city | Virginia | 51700 | 114 | 7 |
103645 | 103645 | 2020-04-30 | Newport News city | Virginia | 51700 | 118 | 7 |
106509 | 106509 | 2020-05-01 | Newport News city | Virginia | 51700 | 120 | 9 |
109378 | 109378 | 2020-05-02 | Newport News city | Virginia | 51700 | 123 | 9 |
112252 | 112252 | 2020-05-03 | Newport News city | Virginia | 51700 | 125 | 9 |
115135 | 115135 | 2020-05-04 | Newport News city | Virginia | 51700 | 132 | 9 |
118094 | 118094 | 2020-05-05 | Newport News city | Virginia | 51700 | 133 | 9 |
121058 | 121058 | 2020-05-06 | Newport News city | Virginia | 51700 | 133 | 9 |
124039 | 124039 | 2020-05-07 | Newport News city | Virginia | 51700 | 137 | 10 |
127024 | 127024 | 2020-05-08 | Newport News city | Virginia | 51700 | 144 | 10 |
130014 | 130014 | 2020-05-09 | Newport News city | Virginia | 51700 | 152 | 10 |
133004 | 133004 | 2020-05-10 | Newport News city | Virginia | 51700 | 159 | 10 |
135994 | 135994 | 2020-05-11 | Newport News city | Virginia | 51700 | 164 | 10 |
138985 | 138985 | 2020-05-12 | Newport News city | Virginia | 51700 | 166 | 10 |
141981 | 141981 | 2020-05-13 | Newport News city | Virginia | 51700 | 171 | 10 |
144978 | 144978 | 2020-05-14 | Newport News city | Virginia | 51700 | 179 | 10 |
147981 | 147981 | 2020-05-15 | Newport News city | Virginia | 51700 | 184 | 10 |
150990 | 150990 | 2020-05-16 | Newport News city | Virginia | 51700 | 187 | 10 |
154001 | 154001 | 2020-05-17 | Newport News city | Virginia | 51700 | 193 | 10 |
157018 | 157018 | 2020-05-18 | Newport News city | Virginia | 51700 | 206 | 10 |
160042 | 160042 | 2020-05-19 | Newport News city | Virginia | 51700 | 209 | 10 |
163070 | 163070 | 2020-05-20 | Newport News city | Virginia | 51700 | 211 | 10 |
166099 | 166099 | 2020-05-21 | Newport News city | Virginia | 51700 | 215 | 10 |
169135 | 169135 | 2020-05-22 | Newport News city | Virginia | 51700 | 224 | 10 |
172176 | 172176 | 2020-05-23 | Newport News city | Virginia | 51700 | 234 | 10 |
175219 | 175219 | 2020-05-24 | Newport News city | Virginia | 51700 | 237 | 10 |
178264 | 178264 | 2020-05-25 | Newport News city | Virginia | 51700 | 245 | 10 |
181308 | 181308 | 2020-05-26 | Newport News city | Virginia | 51700 | 250 | 10 |
184359 | 184359 | 2020-05-27 | Newport News city | Virginia | 51700 | 254 | 10 |
187416 | 187416 | 2020-05-28 | Newport News city | Virginia | 51700 | 257 | 10 |
190480 | 190480 | 2020-05-29 | Newport News city | Virginia | 51700 | 257 | 10 |
193546 | 193546 | 2020-05-30 | Newport News city | Virginia | 51700 | 258 | 10 |
196616 | 196616 | 2020-05-31 | Newport News city | Virginia | 51700 | 273 | 10 |
199689 | 199689 | 2020-06-01 | Newport News city | Virginia | 51700 | 282 | 10 |
202765 | 202765 | 2020-06-02 | Newport News city | Virginia | 51700 | 291 | 10 |
205844 | 205844 | 2020-06-03 | Newport News city | Virginia | 51700 | 292 | 10 |
208926 | 208926 | 2020-06-04 | Newport News city | Virginia | 51700 | 299 | 10 |
212011 | 212011 | 2020-06-05 | Newport News city | Virginia | 51700 | 309 | 10 |
215098 | 215098 | 2020-06-06 | Newport News city | Virginia | 51700 | 314 | 10 |
218188 | 218188 | 2020-06-07 | Newport News city | Virginia | 51700 | 320 | 10 |
221280 | 221280 | 2020-06-08 | Newport News city | Virginia | 51700 | 322 | 10 |
224376 | 224376 | 2020-06-09 | Newport News city | Virginia | 51700 | 323 | 10 |
227476 | 227476 | 2020-06-10 | Newport News city | Virginia | 51700 | 328 | 10 |
230580 | 230580 | 2020-06-11 | Newport News city | Virginia | 51700 | 337 | 10 |
233685 | 233685 | 2020-06-12 | Newport News city | Virginia | 51700 | 351 | 10 |
236792 | 236792 | 2020-06-13 | Newport News city | Virginia | 51700 | 357 | 10 |
239900 | 239900 | 2020-06-14 | Newport News city | Virginia | 51700 | 371 | 10 |
243011 | 243011 | 2020-06-15 | Newport News city | Virginia | 51700 | 381 | 10 |
246124 | 246124 | 2020-06-16 | Newport News city | Virginia | 51700 | 390 | 10 |
249236 | 249236 | 2020-06-17 | Newport News city | Virginia | 51700 | 399 | 10 |
252351 | 252351 | 2020-06-18 | Newport News city | Virginia | 51700 | 402 | 10 |
255470 | 255470 | 2020-06-19 | Newport News city | Virginia | 51700 | 410 | 10 |
258597 | 258597 | 2020-06-20 | Newport News city | Virginia | 51700 | 430 | 10 |
261724 | 261724 | 2020-06-21 | Newport News city | Virginia | 51700 | 438 | 10 |
264853 | 264853 | 2020-06-22 | Newport News city | Virginia | 51700 | 447 | 10 |
267982 | 267982 | 2020-06-23 | Newport News city | Virginia | 51700 | 452 | 10 |
271116 | 271116 | 2020-06-24 | Newport News city | Virginia | 51700 | 463 | 10 |
274256 | 274256 | 2020-06-25 | Newport News city | Virginia | 51700 | 466 | 10 |
277404 | 277404 | 2020-06-26 | Newport News city | Virginia | 51700 | 474 | 10 |
280552 | 280552 | 2020-06-27 | Newport News city | Virginia | 51700 | 490 | 10 |
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);