ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 51540 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537359 | 537359 | 2020-09-15 | Charlottesville city | Virginia | 51540 | 923 | 25 |
534123 | 534123 | 2020-09-14 | Charlottesville city | Virginia | 51540 | 922 | 24 |
530888 | 530888 | 2020-09-13 | Charlottesville city | Virginia | 51540 | 908 | 24 |
527651 | 527651 | 2020-09-12 | Charlottesville city | Virginia | 51540 | 899 | 24 |
524415 | 524415 | 2020-09-11 | Charlottesville city | Virginia | 51540 | 867 | 24 |
521179 | 521179 | 2020-09-10 | Charlottesville city | Virginia | 51540 | 833 | 24 |
517942 | 517942 | 2020-09-09 | Charlottesville city | Virginia | 51540 | 819 | 24 |
514707 | 514707 | 2020-09-08 | Charlottesville city | Virginia | 51540 | 797 | 23 |
511474 | 511474 | 2020-09-07 | Charlottesville city | Virginia | 51540 | 789 | 23 |
508241 | 508241 | 2020-09-06 | Charlottesville city | Virginia | 51540 | 787 | 23 |
505009 | 505009 | 2020-09-05 | Charlottesville city | Virginia | 51540 | 768 | 23 |
501775 | 501775 | 2020-09-04 | Charlottesville city | Virginia | 51540 | 758 | 23 |
498541 | 498541 | 2020-09-03 | Charlottesville city | Virginia | 51540 | 732 | 22 |
495308 | 495308 | 2020-09-02 | Charlottesville city | Virginia | 51540 | 699 | 20 |
492074 | 492074 | 2020-09-01 | Charlottesville city | Virginia | 51540 | 686 | 18 |
488841 | 488841 | 2020-08-31 | Charlottesville city | Virginia | 51540 | 681 | 18 |
485608 | 485608 | 2020-08-30 | Charlottesville city | Virginia | 51540 | 674 | 18 |
482373 | 482373 | 2020-08-29 | Charlottesville city | Virginia | 51540 | 648 | 18 |
479139 | 479139 | 2020-08-28 | Charlottesville city | Virginia | 51540 | 623 | 17 |
475906 | 475906 | 2020-08-27 | Charlottesville city | Virginia | 51540 | 604 | 17 |
472673 | 472673 | 2020-08-26 | Charlottesville city | Virginia | 51540 | 595 | 17 |
469441 | 469441 | 2020-08-25 | Charlottesville city | Virginia | 51540 | 592 | 17 |
466212 | 466212 | 2020-08-24 | Charlottesville city | Virginia | 51540 | 589 | 16 |
462983 | 462983 | 2020-08-23 | Charlottesville city | Virginia | 51540 | 588 | 16 |
459754 | 459754 | 2020-08-22 | Charlottesville city | Virginia | 51540 | 584 | 14 |
456527 | 456527 | 2020-08-21 | Charlottesville city | Virginia | 51540 | 575 | 14 |
453299 | 453299 | 2020-08-20 | Charlottesville city | Virginia | 51540 | 570 | 14 |
450071 | 450071 | 2020-08-19 | Charlottesville city | Virginia | 51540 | 566 | 14 |
446843 | 446843 | 2020-08-18 | Charlottesville city | Virginia | 51540 | 561 | 15 |
443616 | 443616 | 2020-08-17 | Charlottesville city | Virginia | 51540 | 560 | 15 |
440390 | 440390 | 2020-08-16 | Charlottesville city | Virginia | 51540 | 560 | 15 |
437164 | 437164 | 2020-08-15 | Charlottesville city | Virginia | 51540 | 558 | 15 |
433938 | 433938 | 2020-08-14 | Charlottesville city | Virginia | 51540 | 555 | 15 |
430713 | 430713 | 2020-08-13 | Charlottesville city | Virginia | 51540 | 554 | 15 |
427485 | 427485 | 2020-08-12 | Charlottesville city | Virginia | 51540 | 550 | 15 |
424261 | 424261 | 2020-08-11 | Charlottesville city | Virginia | 51540 | 546 | 15 |
421040 | 421040 | 2020-08-10 | Charlottesville city | Virginia | 51540 | 543 | 15 |
417819 | 417819 | 2020-08-09 | Charlottesville city | Virginia | 51540 | 542 | 15 |
414598 | 414598 | 2020-08-08 | Charlottesville city | Virginia | 51540 | 537 | 15 |
411378 | 411378 | 2020-08-07 | Charlottesville city | Virginia | 51540 | 520 | 15 |
408159 | 408159 | 2020-08-06 | Charlottesville city | Virginia | 51540 | 505 | 15 |
404939 | 404939 | 2020-08-05 | Charlottesville city | Virginia | 51540 | 504 | 13 |
401721 | 401721 | 2020-08-04 | Charlottesville city | Virginia | 51540 | 504 | 13 |
398505 | 398505 | 2020-08-03 | Charlottesville city | Virginia | 51540 | 495 | 13 |
395289 | 395289 | 2020-08-02 | Charlottesville city | Virginia | 51540 | 479 | 13 |
392073 | 392073 | 2020-08-01 | Charlottesville city | Virginia | 51540 | 471 | 13 |
388856 | 388856 | 2020-07-31 | Charlottesville city | Virginia | 51540 | 466 | 11 |
385639 | 385639 | 2020-07-30 | Charlottesville city | Virginia | 51540 | 451 | 9 |
382421 | 382421 | 2020-07-29 | Charlottesville city | Virginia | 51540 | 443 | 8 |
379204 | 379204 | 2020-07-28 | Charlottesville city | Virginia | 51540 | 441 | 8 |
375988 | 375988 | 2020-07-27 | Charlottesville city | Virginia | 51540 | 433 | 8 |
372774 | 372774 | 2020-07-26 | Charlottesville city | Virginia | 51540 | 420 | 8 |
369562 | 369562 | 2020-07-25 | Charlottesville city | Virginia | 51540 | 412 | 8 |
366353 | 366353 | 2020-07-24 | Charlottesville city | Virginia | 51540 | 405 | 8 |
363147 | 363147 | 2020-07-23 | Charlottesville city | Virginia | 51540 | 385 | 8 |
359941 | 359941 | 2020-07-22 | Charlottesville city | Virginia | 51540 | 371 | 8 |
356736 | 356736 | 2020-07-21 | Charlottesville city | Virginia | 51540 | 367 | 8 |
353533 | 353533 | 2020-07-20 | Charlottesville city | Virginia | 51540 | 361 | 7 |
350331 | 350331 | 2020-07-19 | Charlottesville city | Virginia | 51540 | 343 | 7 |
347130 | 347130 | 2020-07-18 | Charlottesville city | Virginia | 51540 | 341 | 7 |
343930 | 343930 | 2020-07-17 | Charlottesville city | Virginia | 51540 | 333 | 7 |
340731 | 340731 | 2020-07-16 | Charlottesville city | Virginia | 51540 | 318 | 7 |
337535 | 337535 | 2020-07-15 | Charlottesville city | Virginia | 51540 | 318 | 7 |
334340 | 334340 | 2020-07-14 | Charlottesville city | Virginia | 51540 | 310 | 7 |
331147 | 331147 | 2020-07-13 | Charlottesville city | Virginia | 51540 | 285 | 7 |
327961 | 327961 | 2020-07-12 | Charlottesville city | Virginia | 51540 | 276 | 7 |
324776 | 324776 | 2020-07-11 | Charlottesville city | Virginia | 51540 | 270 | 7 |
321595 | 321595 | 2020-07-10 | Charlottesville city | Virginia | 51540 | 260 | 7 |
318416 | 318416 | 2020-07-09 | Charlottesville city | Virginia | 51540 | 251 | 7 |
315243 | 315243 | 2020-07-08 | Charlottesville city | Virginia | 51540 | 241 | 7 |
312068 | 312068 | 2020-07-07 | Charlottesville city | Virginia | 51540 | 239 | 7 |
308899 | 308899 | 2020-07-06 | Charlottesville city | Virginia | 51540 | 237 | 6 |
305731 | 305731 | 2020-07-05 | Charlottesville city | Virginia | 51540 | 237 | 6 |
302567 | 302567 | 2020-07-04 | Charlottesville city | Virginia | 51540 | 230 | 6 |
299403 | 299403 | 2020-07-03 | Charlottesville city | Virginia | 51540 | 220 | 6 |
296241 | 296241 | 2020-07-02 | Charlottesville city | Virginia | 51540 | 218 | 5 |
293086 | 293086 | 2020-07-01 | Charlottesville city | Virginia | 51540 | 216 | 4 |
289933 | 289933 | 2020-06-30 | Charlottesville city | Virginia | 51540 | 212 | 3 |
286783 | 286783 | 2020-06-29 | Charlottesville city | Virginia | 51540 | 211 | 3 |
283637 | 283637 | 2020-06-28 | Charlottesville city | Virginia | 51540 | 209 | 3 |
280491 | 280491 | 2020-06-27 | Charlottesville city | Virginia | 51540 | 200 | 3 |
277343 | 277343 | 2020-06-26 | Charlottesville city | Virginia | 51540 | 196 | 3 |
274195 | 274195 | 2020-06-25 | Charlottesville city | Virginia | 51540 | 193 | 3 |
271055 | 271055 | 2020-06-24 | Charlottesville city | Virginia | 51540 | 182 | 3 |
267921 | 267921 | 2020-06-23 | Charlottesville city | Virginia | 51540 | 176 | 3 |
264792 | 264792 | 2020-06-22 | Charlottesville city | Virginia | 51540 | 172 | 3 |
261663 | 261663 | 2020-06-21 | Charlottesville city | Virginia | 51540 | 169 | 3 |
258536 | 258536 | 2020-06-20 | Charlottesville city | Virginia | 51540 | 166 | 3 |
255409 | 255409 | 2020-06-19 | Charlottesville city | Virginia | 51540 | 164 | 3 |
252290 | 252290 | 2020-06-18 | Charlottesville city | Virginia | 51540 | 164 | 3 |
249175 | 249175 | 2020-06-17 | Charlottesville city | Virginia | 51540 | 161 | 3 |
246063 | 246063 | 2020-06-16 | Charlottesville city | Virginia | 51540 | 160 | 3 |
242951 | 242951 | 2020-06-15 | Charlottesville city | Virginia | 51540 | 154 | 3 |
239840 | 239840 | 2020-06-14 | Charlottesville city | Virginia | 51540 | 152 | 3 |
236732 | 236732 | 2020-06-13 | Charlottesville city | Virginia | 51540 | 148 | 3 |
233625 | 233625 | 2020-06-12 | Charlottesville city | Virginia | 51540 | 146 | 3 |
230520 | 230520 | 2020-06-11 | Charlottesville city | Virginia | 51540 | 144 | 3 |
227416 | 227416 | 2020-06-10 | Charlottesville city | Virginia | 51540 | 142 | 3 |
224316 | 224316 | 2020-06-09 | Charlottesville city | Virginia | 51540 | 141 | 3 |
221220 | 221220 | 2020-06-08 | Charlottesville city | Virginia | 51540 | 139 | 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);