ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Loudoun" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 687 ✖
- 5 6
- 33175 4
- 2 3
- 28207 3
- 28376 3
- 28600 3
- 28909 3
- 29316 3
- 29644 3
- 30125 3
- 30641 3
- 31101 3
- 31654 3
- 32308 3
- 32793 3
- 33536 3
- 33870 3
- 34176 3
- 34455 3
- 34782 3
- 35260 3
- 35699 3
- 36292 3
- 37054 3
- 38086 3
- 40503 3
- 44607 3
- 50276 3
- 55773 3
- 59462 3
- 61667 3
- 63102 3
- 64052 3
- 64804 3
- 65174 3
- 65804 3
- 66362 3
- 66930 3
- 67604 3
- 67866 3
- 68196 3
- 68599 3
- 69110 3
- 69736 3
- 70633 3
- 15 2
- 43 2
- 61 2
- 998 2
- 8048 2
- 27922 2
- 27923 2
- 28015 2
- 28037 2
- 28095 2
- 28097 2
- 28102 2
- 66038 2
- 67182 2
- 3 1
- 9 1
- 14 1
- 18 1
- 20 1
- 54 1
- 87 1
- 105 1
- 121 1
- 130 1
- 150 1
- 167 1
- 188 1
- 209 1
- 238 1
- 258 1
- 274 1
- 296 1
- 309 1
- 324 1
- 344 1
- 367 1
- 378 1
- 385 1
- 413 1
- 425 1
- 446 1
- 468 1
- 475 1
- 498 1
- 529 1
- 564 1
- 596 1
- 628 1
- 688 1
- 727 1
- 746 1
- 832 1
- 881 1
- 931 1
- 961 1
- 1043 1
- 1070 1
- 1127 1
- 1159 1
- 1195 1
- 1210 1
- 1283 1
- 1339 1
- 1374 1
- 1430 1
- 1446 1
- 1486 1
- 1527 1
- 1579 1
- 1700 1
- 1807 1
- 1821 1
- 1831 1
- 2047 1
- 2186 1
- 2274 1
- 2318 1
- 2429 1
- 2529 1
- 2575 1
- 2611 1
- 2636 1
- 2659 1
- 2794 1
- 2837 1
- 2939 1
- 3094 1
- 3147 1
- 3174 1
- 3180 1
- 3229 1
- 3280 1
- 3321 1
- 3384 1
- 3404 1
- 3439 1
- 3458 1
- 3499 1
- 3504 1
- 3543 1
- 3585 1
- 3612 1
- 3632 1
- 3683 1
- 3739 1
- 3806 1
- 3890 1
- 3932 1
- 3968 1
- 4000 1
- 4047 1
- 4083 1
- 4113 1
- 4175 1
- 4207 1
- 4216 1
- 4252 1
- 4282 1
- 4319 1
- 4349 1
- 4373 1
- 4407 1
- 4431 1
- 4458 1
- 4519 1
- 4557 1
- 4576 1
- 4596 1
- 4647 1
- 4670 1
- 4695 1
- 4738 1
- 4758 1
- 4769 1
- 4796 1
- 4820 1
- 4914 1
- 4939 1
- 4965 1
- 4985 1
- 4995 1
- 5014 1
- 5034 1
- 5059 1
- 5093 1
- 5117 1
- 5150 1
- 5196 1
- 5254 1
- 5280 1
- 5306 1
- 5346 1
- 5372 1
- 5403 1
- 5441 1
- 5482 1
- 5511 1
- 5528 1
- 5552 1
- 5580 1
- 5614 1
- 5647 1
- 5684 1
- 5712 1
- 5735 1
- 5769 1
- 5787 1
- 5825 1
- 5878 1
- 5924 1
- 5945 1
- 5979 1
- 6008 1
- 6053 1
- 6077 1
- 6146 1
- 6166 1
- 6198 1
- 6223 1
- 6263 1
- 6273 1
- 6327 1
- 6377 1
- 6409 1
- 6443 1
- 6449 1
- 6489 1
- 6523 1
- 6567 1
- 6615 1
- 6633 1
- 6656 1
- 6678 1
- 6698 1
- 6720 1
- 6747 1
- 6774 1
- 6792 1
- 6816 1
- 6830 1
- 6851 1
- 6887 1
- 6889 1
- 6916 1
- 6954 1
- 6985 1
- 6987 1
- 7026 1
- 7042 1
- 7110 1
- 7137 1
- 7181 1
- 7217 1
- 7259 1
- 7301 1
- 7303 1
- 7417 1
- 7454 1
- 7505 1
- 7558 1
- 7576 1
- 7599 1
- 7634 1
- 7680 1
- 7704 1
- 7730 1
- 7736 1
- 7784 1
- 7817 1
- 7876 1
- 7908 1
- 7946 1
- 7981 1
- 8105 1
- 8143 1
- 8175 1
- 8225 1
- 8313 1
- 8336 1
- 8413 1
- 8486 1
- 8560 1
- 8622 1
- 8642 1
- 8706 1
- 8810 1
- 8894 1
- 8954 1
- 9020 1
- 9046 1
- 9149 1
- 9216 1
- 9265 1
- 9345 1
- 9512 1
- 9717 1
- 9817 1
- 9872 1
- 9980 1
- 10021 1
- 10049 1
- 10232 1
- 10302 1
- 10376 1
- 10469 1
- 10557 1
- 10635 1
- 10832 1
- 11005 1
- 11270 1
- 11420 1
- 11545 1
- 11709 1
- 11788 1
- 11937 1
- 12029 1
- 12193 1
- 12297 1
- 12386 1
- 12503 1
- 12682 1
- 12861 1
- 12925 1
- 13082 1
- 13171 1
- 13280 1
- 13441 1
- 13600 1
- 13683 1
- 13848 1
- 13996 1
- 14169 1
- 14352 1
- 14481 1
- 14518 1
- 14569 1
- 14786 1
- 14973 1
- 15095 1
- 15219 1
- 15286 1
- 15368 1
- 15443 1
- 15604 1
- 15711 1
- 15876 1
- 16035 1
- 16245 1
- 16637 1
- 17014 1
- 17236 1
- 17389 1
- 17571 1
- 17809 1
- 18151 1
- 18381 1
- 18848 1
- 19161 1
- 19508 1
- 19821 1
- 20077 1
- 20277 1
- 20384 1
- 20484 1
- 20618 1
- 20791 1
- 21015 1
- 21261 1
- 21492 1
- 21552 1
- 21564 1
- 21723 1
- 21808 1
- 21897 1
- 22007 1
- 22102 1
- 22186 1
- 22246 1
- 22310 1
- 22351 1
- 22405 1
- 22486 1
- 22557 1
- 22654 1
- 22704 1
- 22762 1
- 22816 1
- 22873 1
- 22939 1
- 22997 1
- 23076 1
- 23126 1
- 23183 1
- 23221 1
- 23272 1
- 23352 1
- 23418 1
- 23472 1
- 23533 1
- 23589 1
- 23641 1
- 23708 1
- 23782 1
- 23848 1
- 23928 1
- 23986 1
- 24060 1
- 24197 1
- 24345 1
- 24434 1
- 24491 1
- 24552 1
- 24603 1
- 24659 1
- 24706 1
- 24794 1
- 24924 1
- 25011 1
- 25089 1
- 25136 1
- 25221 1
- 25251 1
- 25391 1
- 25452 1
- 25517 1
- 25572 1
- 25623 1
- 25693 1
- 25794 1
- 25897 1
- 26012 1
- 26116 1
- 26169 1
- 26243 1
- 26379 1
- 26430 1
- 26488 1
- 26569 1
- 26645 1
- 26694 1
- 26736 1
- 26795 1
- 26849 1
- 26928 1
- 26997 1
- 27043 1
- 27077 1
- 27104 1
- 27159 1
- 27202 1
- 27259 1
- 27309 1
- 27358 1
- 27391 1
- 27411 1
- 27442 1
- 27483 1
- 27539 1
- 27589 1
- 27614 1
- 27635 1
- 27655 1
- 27686 1
- 27716 1
- 27729 1
- 27740 1
- 27772 1
- 27783 1
- 27799 1
- 27811 1
- 27817 1
- 27833 1
- 27846 1
- 27860 1
- 27862 1
- 27864 1
- 27873 1
- 27889 1
- 27902 1
- 27916 1
- 27940 1
- 27954 1
- 27956 1
- 27966 1
- 27969 1
- 27975 1
- 27986 1
- 27991 1
- 28007 1
- 28008 1
- 28014 1
- 28019 1
- 28031 1
- 28033 1
- 28036 1
- 28045 1
- 28051 1
- 28065 1
- 28084 1
- 28085 1
- 28091 1
- 28093 1
- 28094 1
- 28099 1
- 28105 1
- 28110 1
- 28114 1
- 28121 1
- 28128 1
- 28134 1
- 28141 1
- 28151 1
- 28168 1
- 28188 1
- 28233 1
- 28292 1
- 28315 1
- 28337 1
- 28441 1
- 28478 1
- 28530 1
- 28554 1
- 28728 1
- 28757 1
- 28814 1
- 28859 1
- 29048 1
- 29109 1
- 29179 1
- 29247 1
- 29414 1
- 29459 1
- 29529 1
- 29581 1
- 29833 1
- 29902 1
- 29995 1
- 30060 1
- 30311 1
- 30375 1
- 30441 1
- 30485 1
- 30863 1
- 30903 1
- 31051 1
- 31073 1
- 31342 1
- 31407 1
- 31478 1
- 31553 1
- 31910 1
- 32012 1
- 32122 1
- 32220 1
- 32529 1
- 32604 1
- 32662 1
- 32745 1
- 32954 1
- 33017 1
- 33084 1
- 33122 1
- 33350 1
- 33414 1
- 33482 1
- 33659 1
- 33715 1
- 33766 1
- 33816 1
- 34005 1
- 34035 1
- 34074 1
- 34125 1
- 34266 1
- 34300 1
- 34355 1
- 34408 1
- 34544 1
- 34594 1
- 34655 1
- 34732 1
- 34928 1
- 34980 1
- 35094 1
- 35191 1
- 35455 1
- 35514 1
- 35585 1
- 35641 1
- 35847 1
- 35934 1
- 36064 1
- 36186 1
- 36571 1
- 36677 1
- 36816 1
- 36928 1
- 37384 1
- 37530 1
- 37708 1
- 37893 1
- 38699 1
- 39045 1
- 39481 1
- 39898 1
- 41565 1
- 42080 1
- 42751 1
- 43392 1
- 46772 1
- 47513 1
- 48419 1
- 49295 1
- 52772 1
- 53685 1
- 54613 1
- 55231 1
- 57390 1
- 57869 1
- 58410 1
- 58949 1
- 60267 1
- 60750 1
- 61102 1
- 61419 1
- 62253 1
- 62390 1
- 62621 1
- 62886 1
- 63454 1
- 63614 1
- 63736 1
- 63874 1
- 64324 1
- 64466 1
- 64610 1
- 64718 1
- 64964 1
- 64992 1
- 65064 1
- 65131 1
- 65331 1
- 65434 1
- 65650 1
- 65796 1
- 65969 1
- 66232 1
- 66492 1
- 66547 1
- 66655 1
- 66790 1
- 67416 1
- 67560 1
- 67679 1
- 67727 1
- 67743 1
- 67806 1
- 67950 1
- 68009 1
- 68075 1
- 68124 1
- 68338 1
- 68406 1
- 68477 1
- 68519 1
- 68782 1
- 68841 1
- 68910 1
- 69008 1
- 69344 1
- 69428 1
- 69527 1
- 69639 1
- 70039 1
- 70118 1
- 70314 1
- 70465 1
- 71059 1
- 71271 1
- 71463 1
- 71687 1
- 71890 1
state 1
- Virginia · 795 ✖
fips 1
- 51107 795
county 1
- Loudoun · 795 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502580 | 2502580 | 2022-05-13 | Loudoun | Virginia | 51107 | 71890 | 383 |
2499322 | 2499322 | 2022-05-12 | Loudoun | Virginia | 51107 | 71687 | 383 |
2496064 | 2496064 | 2022-05-11 | Loudoun | Virginia | 51107 | 71463 | 383 |
2492806 | 2492806 | 2022-05-10 | Loudoun | Virginia | 51107 | 71271 | 384 |
2489548 | 2489548 | 2022-05-09 | Loudoun | Virginia | 51107 | 71059 | 384 |
2486291 | 2486291 | 2022-05-08 | Loudoun | Virginia | 51107 | 70633 | 384 |
2483033 | 2483033 | 2022-05-07 | Loudoun | Virginia | 51107 | 70633 | 384 |
2479775 | 2479775 | 2022-05-06 | Loudoun | Virginia | 51107 | 70633 | 384 |
2476517 | 2476517 | 2022-05-05 | Loudoun | Virginia | 51107 | 70465 | 383 |
2473259 | 2473259 | 2022-05-04 | Loudoun | Virginia | 51107 | 70314 | 383 |
2470003 | 2470003 | 2022-05-03 | Loudoun | Virginia | 51107 | 70118 | 383 |
2466747 | 2466747 | 2022-05-02 | Loudoun | Virginia | 51107 | 70039 | 383 |
2463492 | 2463492 | 2022-05-01 | Loudoun | Virginia | 51107 | 69736 | 384 |
2460236 | 2460236 | 2022-04-30 | Loudoun | Virginia | 51107 | 69736 | 384 |
2456980 | 2456980 | 2022-04-29 | Loudoun | Virginia | 51107 | 69736 | 384 |
2453724 | 2453724 | 2022-04-28 | Loudoun | Virginia | 51107 | 69639 | 382 |
2450468 | 2450468 | 2022-04-27 | Loudoun | Virginia | 51107 | 69527 | 382 |
2447211 | 2447211 | 2022-04-26 | Loudoun | Virginia | 51107 | 69428 | 382 |
2443956 | 2443956 | 2022-04-25 | Loudoun | Virginia | 51107 | 69344 | 382 |
2440700 | 2440700 | 2022-04-24 | Loudoun | Virginia | 51107 | 69110 | 382 |
2437444 | 2437444 | 2022-04-23 | Loudoun | Virginia | 51107 | 69110 | 382 |
2434188 | 2434188 | 2022-04-22 | Loudoun | Virginia | 51107 | 69110 | 382 |
2430932 | 2430932 | 2022-04-21 | Loudoun | Virginia | 51107 | 69008 | 381 |
2427676 | 2427676 | 2022-04-20 | Loudoun | Virginia | 51107 | 68910 | 381 |
2424420 | 2424420 | 2022-04-19 | Loudoun | Virginia | 51107 | 68841 | 380 |
2421164 | 2421164 | 2022-04-18 | Loudoun | Virginia | 51107 | 68782 | 379 |
2417908 | 2417908 | 2022-04-17 | Loudoun | Virginia | 51107 | 68599 | 379 |
2414652 | 2414652 | 2022-04-16 | Loudoun | Virginia | 51107 | 68599 | 379 |
2411396 | 2411396 | 2022-04-15 | Loudoun | Virginia | 51107 | 68599 | 379 |
2408140 | 2408140 | 2022-04-14 | Loudoun | Virginia | 51107 | 68519 | 379 |
2404884 | 2404884 | 2022-04-13 | Loudoun | Virginia | 51107 | 68477 | 378 |
2401629 | 2401629 | 2022-04-12 | Loudoun | Virginia | 51107 | 68406 | 376 |
2398374 | 2398374 | 2022-04-11 | Loudoun | Virginia | 51107 | 68338 | 376 |
2395119 | 2395119 | 2022-04-10 | Loudoun | Virginia | 51107 | 68196 | 376 |
2391863 | 2391863 | 2022-04-09 | Loudoun | Virginia | 51107 | 68196 | 376 |
2388607 | 2388607 | 2022-04-08 | Loudoun | Virginia | 51107 | 68196 | 376 |
2385352 | 2385352 | 2022-04-07 | Loudoun | Virginia | 51107 | 68124 | 375 |
2382097 | 2382097 | 2022-04-06 | Loudoun | Virginia | 51107 | 68075 | 374 |
2378842 | 2378842 | 2022-04-05 | Loudoun | Virginia | 51107 | 68009 | 374 |
2375588 | 2375588 | 2022-04-04 | Loudoun | Virginia | 51107 | 67950 | 374 |
2372336 | 2372336 | 2022-04-03 | Loudoun | Virginia | 51107 | 67866 | 374 |
2369083 | 2369083 | 2022-04-02 | Loudoun | Virginia | 51107 | 67866 | 374 |
2365830 | 2365830 | 2022-04-01 | Loudoun | Virginia | 51107 | 67866 | 374 |
2362577 | 2362577 | 2022-03-31 | Loudoun | Virginia | 51107 | 67806 | 373 |
2359323 | 2359323 | 2022-03-30 | Loudoun | Virginia | 51107 | 67743 | 373 |
2356069 | 2356069 | 2022-03-29 | Loudoun | Virginia | 51107 | 67727 | 373 |
2352816 | 2352816 | 2022-03-28 | Loudoun | Virginia | 51107 | 67679 | 373 |
2349564 | 2349564 | 2022-03-27 | Loudoun | Virginia | 51107 | 67604 | 373 |
2346311 | 2346311 | 2022-03-26 | Loudoun | Virginia | 51107 | 67604 | 373 |
2343058 | 2343058 | 2022-03-25 | Loudoun | Virginia | 51107 | 67604 | 373 |
2339805 | 2339805 | 2022-03-24 | Loudoun | Virginia | 51107 | 67560 | 373 |
2336551 | 2336551 | 2022-03-23 | Loudoun | Virginia | 51107 | 67416 | 373 |
2333297 | 2333297 | 2022-03-22 | Loudoun | Virginia | 51107 | 67182 | 373 |
2330044 | 2330044 | 2022-03-21 | Loudoun | Virginia | 51107 | 67182 | 373 |
2326792 | 2326792 | 2022-03-20 | Loudoun | Virginia | 51107 | 66930 | 373 |
2323539 | 2323539 | 2022-03-19 | Loudoun | Virginia | 51107 | 66930 | 373 |
2320285 | 2320285 | 2022-03-18 | Loudoun | Virginia | 51107 | 66930 | 373 |
2317031 | 2317031 | 2022-03-17 | Loudoun | Virginia | 51107 | 66790 | 370 |
2313778 | 2313778 | 2022-03-16 | Loudoun | Virginia | 51107 | 66655 | 370 |
2310525 | 2310525 | 2022-03-15 | Loudoun | Virginia | 51107 | 66547 | 370 |
2307272 | 2307272 | 2022-03-14 | Loudoun | Virginia | 51107 | 66492 | 368 |
2304021 | 2304021 | 2022-03-13 | Loudoun | Virginia | 51107 | 66362 | 368 |
2300769 | 2300769 | 2022-03-12 | Loudoun | Virginia | 51107 | 66362 | 368 |
2297517 | 2297517 | 2022-03-11 | Loudoun | Virginia | 51107 | 66362 | 368 |
2294265 | 2294265 | 2022-03-10 | Loudoun | Virginia | 51107 | 66232 | 368 |
2291013 | 2291013 | 2022-03-09 | Loudoun | Virginia | 51107 | 66038 | 368 |
2287761 | 2287761 | 2022-03-08 | Loudoun | Virginia | 51107 | 66038 | 368 |
2284509 | 2284509 | 2022-03-07 | Loudoun | Virginia | 51107 | 65969 | 367 |
2281257 | 2281257 | 2022-03-06 | Loudoun | Virginia | 51107 | 65804 | 364 |
2278004 | 2278004 | 2022-03-05 | Loudoun | Virginia | 51107 | 65804 | 364 |
2274751 | 2274751 | 2022-03-04 | Loudoun | Virginia | 51107 | 65804 | 364 |
2271498 | 2271498 | 2022-03-03 | Loudoun | Virginia | 51107 | 65796 | 363 |
2268246 | 2268246 | 2022-03-02 | Loudoun | Virginia | 51107 | 65650 | 363 |
2264993 | 2264993 | 2022-03-01 | Loudoun | Virginia | 51107 | 65434 | 360 |
2261743 | 2261743 | 2022-02-28 | Loudoun | Virginia | 51107 | 65331 | 359 |
2258492 | 2258492 | 2022-02-27 | Loudoun | Virginia | 51107 | 65174 | 356 |
2255241 | 2255241 | 2022-02-26 | Loudoun | Virginia | 51107 | 65174 | 356 |
2251990 | 2251990 | 2022-02-25 | Loudoun | Virginia | 51107 | 65174 | 356 |
2248739 | 2248739 | 2022-02-24 | Loudoun | Virginia | 51107 | 65131 | 356 |
2245488 | 2245488 | 2022-02-23 | Loudoun | Virginia | 51107 | 65064 | 354 |
2242237 | 2242237 | 2022-02-22 | Loudoun | Virginia | 51107 | 64992 | 352 |
2238986 | 2238986 | 2022-02-21 | Loudoun | Virginia | 51107 | 64964 | 349 |
2235735 | 2235735 | 2022-02-20 | Loudoun | Virginia | 51107 | 64804 | 349 |
2232484 | 2232484 | 2022-02-19 | Loudoun | Virginia | 51107 | 64804 | 349 |
2229233 | 2229233 | 2022-02-18 | Loudoun | Virginia | 51107 | 64804 | 349 |
2225982 | 2225982 | 2022-02-17 | Loudoun | Virginia | 51107 | 64718 | 348 |
2222731 | 2222731 | 2022-02-16 | Loudoun | Virginia | 51107 | 64610 | 347 |
2219480 | 2219480 | 2022-02-15 | Loudoun | Virginia | 51107 | 64466 | 346 |
2216230 | 2216230 | 2022-02-14 | Loudoun | Virginia | 51107 | 64324 | 345 |
2212979 | 2212979 | 2022-02-13 | Loudoun | Virginia | 51107 | 64052 | 339 |
2209726 | 2209726 | 2022-02-12 | Loudoun | Virginia | 51107 | 64052 | 339 |
2206473 | 2206473 | 2022-02-11 | Loudoun | Virginia | 51107 | 64052 | 339 |
2203220 | 2203220 | 2022-02-10 | Loudoun | Virginia | 51107 | 63874 | 338 |
2199966 | 2199966 | 2022-02-09 | Loudoun | Virginia | 51107 | 63736 | 336 |
2196712 | 2196712 | 2022-02-08 | Loudoun | Virginia | 51107 | 63614 | 336 |
2193457 | 2193457 | 2022-02-07 | Loudoun | Virginia | 51107 | 63454 | 331 |
2190204 | 2190204 | 2022-02-06 | Loudoun | Virginia | 51107 | 63102 | 323 |
2186951 | 2186951 | 2022-02-05 | Loudoun | Virginia | 51107 | 63102 | 323 |
2183698 | 2183698 | 2022-02-04 | Loudoun | Virginia | 51107 | 63102 | 323 |
2180446 | 2180446 | 2022-02-03 | Loudoun | Virginia | 51107 | 62886 | 321 |
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);