ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Norfolk 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 |
---|---|---|---|---|---|---|---|
388918 | 388918 | 2020-07-31 | Norfolk city | Virginia | 51710 | 3180 | 24 |
385701 | 385701 | 2020-07-30 | Norfolk city | Virginia | 51710 | 3080 | 22 |
382483 | 382483 | 2020-07-29 | Norfolk city | Virginia | 51710 | 2937 | 22 |
379266 | 379266 | 2020-07-28 | Norfolk city | Virginia | 51710 | 2814 | 20 |
376050 | 376050 | 2020-07-27 | Norfolk city | Virginia | 51710 | 2779 | 20 |
372836 | 372836 | 2020-07-26 | Norfolk city | Virginia | 51710 | 2771 | 20 |
369624 | 369624 | 2020-07-25 | Norfolk city | Virginia | 51710 | 2661 | 20 |
366415 | 366415 | 2020-07-24 | Norfolk city | Virginia | 51710 | 2582 | 20 |
363209 | 363209 | 2020-07-23 | Norfolk city | Virginia | 51710 | 2489 | 20 |
360003 | 360003 | 2020-07-22 | Norfolk city | Virginia | 51710 | 2389 | 20 |
356798 | 356798 | 2020-07-21 | Norfolk city | Virginia | 51710 | 2329 | 21 |
353595 | 353595 | 2020-07-20 | Norfolk city | Virginia | 51710 | 2214 | 20 |
350393 | 350393 | 2020-07-19 | Norfolk city | Virginia | 51710 | 2155 | 19 |
347192 | 347192 | 2020-07-18 | Norfolk city | Virginia | 51710 | 2134 | 19 |
343992 | 343992 | 2020-07-17 | Norfolk city | Virginia | 51710 | 2020 | 19 |
340793 | 340793 | 2020-07-16 | Norfolk city | Virginia | 51710 | 1888 | 19 |
337597 | 337597 | 2020-07-15 | Norfolk city | Virginia | 51710 | 1742 | 18 |
334402 | 334402 | 2020-07-14 | Norfolk city | Virginia | 51710 | 1606 | 16 |
331209 | 331209 | 2020-07-13 | Norfolk city | Virginia | 51710 | 1588 | 16 |
328023 | 328023 | 2020-07-12 | Norfolk city | Virginia | 51710 | 1548 | 16 |
324838 | 324838 | 2020-07-11 | Norfolk city | Virginia | 51710 | 1448 | 15 |
321657 | 321657 | 2020-07-10 | Norfolk city | Virginia | 51710 | 1360 | 15 |
318478 | 318478 | 2020-07-09 | Norfolk city | Virginia | 51710 | 1289 | 14 |
315305 | 315305 | 2020-07-08 | Norfolk city | Virginia | 51710 | 1194 | 14 |
312130 | 312130 | 2020-07-07 | Norfolk city | Virginia | 51710 | 1162 | 12 |
308961 | 308961 | 2020-07-06 | Norfolk city | Virginia | 51710 | 1105 | 12 |
305793 | 305793 | 2020-07-05 | Norfolk city | Virginia | 51710 | 1072 | 12 |
302629 | 302629 | 2020-07-04 | Norfolk city | Virginia | 51710 | 1067 | 12 |
299465 | 299465 | 2020-07-03 | Norfolk city | Virginia | 51710 | 1000 | 11 |
296303 | 296303 | 2020-07-02 | Norfolk city | Virginia | 51710 | 987 | 11 |
293148 | 293148 | 2020-07-01 | Norfolk city | Virginia | 51710 | 934 | 10 |
289995 | 289995 | 2020-06-30 | Norfolk city | Virginia | 51710 | 915 | 9 |
286845 | 286845 | 2020-06-29 | Norfolk city | Virginia | 51710 | 889 | 9 |
283699 | 283699 | 2020-06-28 | Norfolk city | Virginia | 51710 | 855 | 9 |
280553 | 280553 | 2020-06-27 | Norfolk city | Virginia | 51710 | 842 | 9 |
277405 | 277405 | 2020-06-26 | Norfolk city | Virginia | 51710 | 822 | 8 |
274257 | 274257 | 2020-06-25 | Norfolk city | Virginia | 51710 | 795 | 8 |
271117 | 271117 | 2020-06-24 | Norfolk city | Virginia | 51710 | 771 | 7 |
267983 | 267983 | 2020-06-23 | Norfolk city | Virginia | 51710 | 747 | 7 |
264854 | 264854 | 2020-06-22 | Norfolk city | Virginia | 51710 | 746 | 7 |
261725 | 261725 | 2020-06-21 | Norfolk city | Virginia | 51710 | 737 | 7 |
258598 | 258598 | 2020-06-20 | Norfolk city | Virginia | 51710 | 723 | 7 |
255471 | 255471 | 2020-06-19 | Norfolk city | Virginia | 51710 | 707 | 7 |
252352 | 252352 | 2020-06-18 | Norfolk city | Virginia | 51710 | 704 | 7 |
249237 | 249237 | 2020-06-17 | Norfolk city | Virginia | 51710 | 698 | 7 |
246125 | 246125 | 2020-06-16 | Norfolk city | Virginia | 51710 | 681 | 7 |
243012 | 243012 | 2020-06-15 | Norfolk city | Virginia | 51710 | 668 | 7 |
239901 | 239901 | 2020-06-14 | Norfolk city | Virginia | 51710 | 660 | 7 |
236793 | 236793 | 2020-06-13 | Norfolk city | Virginia | 51710 | 643 | 7 |
233686 | 233686 | 2020-06-12 | Norfolk city | Virginia | 51710 | 630 | 7 |
230581 | 230581 | 2020-06-11 | Norfolk city | Virginia | 51710 | 619 | 7 |
227477 | 227477 | 2020-06-10 | Norfolk city | Virginia | 51710 | 605 | 7 |
224377 | 224377 | 2020-06-09 | Norfolk city | Virginia | 51710 | 596 | 7 |
221281 | 221281 | 2020-06-08 | Norfolk city | Virginia | 51710 | 589 | 7 |
218189 | 218189 | 2020-06-07 | Norfolk city | Virginia | 51710 | 583 | 7 |
215099 | 215099 | 2020-06-06 | Norfolk city | Virginia | 51710 | 562 | 7 |
212012 | 212012 | 2020-06-05 | Norfolk city | Virginia | 51710 | 560 | 6 |
208927 | 208927 | 2020-06-04 | Norfolk city | Virginia | 51710 | 552 | 6 |
205845 | 205845 | 2020-06-03 | Norfolk city | Virginia | 51710 | 539 | 6 |
202766 | 202766 | 2020-06-02 | Norfolk city | Virginia | 51710 | 530 | 6 |
199690 | 199690 | 2020-06-01 | Norfolk city | Virginia | 51710 | 521 | 6 |
196617 | 196617 | 2020-05-31 | Norfolk city | Virginia | 51710 | 503 | 6 |
193547 | 193547 | 2020-05-30 | Norfolk city | Virginia | 51710 | 490 | 6 |
190481 | 190481 | 2020-05-29 | Norfolk city | Virginia | 51710 | 470 | 6 |
187417 | 187417 | 2020-05-28 | Norfolk city | Virginia | 51710 | 452 | 6 |
184360 | 184360 | 2020-05-27 | Norfolk city | Virginia | 51710 | 451 | 6 |
181309 | 181309 | 2020-05-26 | Norfolk city | Virginia | 51710 | 450 | 6 |
178265 | 178265 | 2020-05-25 | Norfolk city | Virginia | 51710 | 432 | 6 |
175220 | 175220 | 2020-05-24 | Norfolk city | Virginia | 51710 | 399 | 6 |
172177 | 172177 | 2020-05-23 | Norfolk city | Virginia | 51710 | 393 | 6 |
169136 | 169136 | 2020-05-22 | Norfolk city | Virginia | 51710 | 388 | 6 |
166100 | 166100 | 2020-05-21 | Norfolk city | Virginia | 51710 | 377 | 6 |
163071 | 163071 | 2020-05-20 | Norfolk city | Virginia | 51710 | 370 | 6 |
160043 | 160043 | 2020-05-19 | Norfolk city | Virginia | 51710 | 370 | 6 |
157019 | 157019 | 2020-05-18 | Norfolk city | Virginia | 51710 | 361 | 5 |
154002 | 154002 | 2020-05-17 | Norfolk city | Virginia | 51710 | 350 | 5 |
150991 | 150991 | 2020-05-16 | Norfolk city | Virginia | 51710 | 350 | 5 |
147982 | 147982 | 2020-05-15 | Norfolk city | Virginia | 51710 | 349 | 5 |
144979 | 144979 | 2020-05-14 | Norfolk city | Virginia | 51710 | 338 | 5 |
141982 | 141982 | 2020-05-13 | Norfolk city | Virginia | 51710 | 327 | 5 |
138986 | 138986 | 2020-05-12 | Norfolk city | Virginia | 51710 | 319 | 5 |
135995 | 135995 | 2020-05-11 | Norfolk city | Virginia | 51710 | 308 | 5 |
133005 | 133005 | 2020-05-10 | Norfolk city | Virginia | 51710 | 304 | 5 |
130015 | 130015 | 2020-05-09 | Norfolk city | Virginia | 51710 | 290 | 5 |
127025 | 127025 | 2020-05-08 | Norfolk city | Virginia | 51710 | 274 | 5 |
124040 | 124040 | 2020-05-07 | Norfolk city | Virginia | 51710 | 270 | 5 |
121059 | 121059 | 2020-05-06 | Norfolk city | Virginia | 51710 | 251 | 4 |
118095 | 118095 | 2020-05-05 | Norfolk city | Virginia | 51710 | 251 | 4 |
115136 | 115136 | 2020-05-04 | Norfolk city | Virginia | 51710 | 239 | 4 |
112253 | 112253 | 2020-05-03 | Norfolk city | Virginia | 51710 | 221 | 4 |
109379 | 109379 | 2020-05-02 | Norfolk city | Virginia | 51710 | 211 | 3 |
106510 | 106510 | 2020-05-01 | Norfolk city | Virginia | 51710 | 204 | 3 |
103646 | 103646 | 2020-04-30 | Norfolk city | Virginia | 51710 | 198 | 3 |
100791 | 100791 | 2020-04-29 | Norfolk city | Virginia | 51710 | 192 | 3 |
97941 | 97941 | 2020-04-28 | Norfolk city | Virginia | 51710 | 188 | 3 |
95097 | 95097 | 2020-04-27 | Norfolk city | Virginia | 51710 | 184 | 3 |
92268 | 92268 | 2020-04-26 | Norfolk city | Virginia | 51710 | 179 | 3 |
89451 | 89451 | 2020-04-25 | Norfolk city | Virginia | 51710 | 169 | 3 |
86636 | 86636 | 2020-04-24 | Norfolk city | Virginia | 51710 | 141 | 3 |
83829 | 83829 | 2020-04-23 | Norfolk city | Virginia | 51710 | 136 | 3 |
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);