ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Fairfax" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 409 ✖
- 1178 15
- 0 14
- 1125 13
- 1177 12
- 1210 11
- 1 9
- 605 9
- 1124 8
- 1126 8
- 1176 8
- 606 7
- 1105 7
- 1217 7
- 599 6
- 1128 6
- 1451 6
- 1452 6
- 5 5
- 529 5
- 562 5
- 586 5
- 610 5
- 1040 5
- 1113 5
- 1158 5
- 1183 5
- 16 4
- 495 4
- 508 4
- 590 4
- 614 4
- 623 4
- 1067 4
- 1073 4
- 1116 4
- 1119 4
- 1127 4
- 1139 4
- 1141 4
- 1152 4
- 1218 4
- 1227 4
- 1438 4
- 1453 4
- 37 3
- 423 3
- 500 3
- 519 3
- 530 3
- 539 3
- 568 3
- 583 3
- 602 3
- 604 3
- 624 3
- 626 3
- 641 3
- 671 3
- 707 3
- 732 3
- 784 3
- 807 3
- 834 3
- 1034 3
- 1038 3
- 1074 3
- 1077 3
- 1080 3
- 1081 3
- 1103 3
- 1108 3
- 1115 3
- 1133 3
- 1140 3
- 1148 3
- 1150 3
- 1151 3
- 1168 3
- 1170 3
- 1172 3
- 1187 3
- 1189 3
- 1193 3
- 1263 3
- 1299 3
- 1331 3
- 1355 3
- 1382 3
- 1401 3
- 1417 3
- 1425 3
- 1434 3
- 1439 3
- 1441 3
- 1444 3
- 1445 3
- 2 2
- 9 2
- 20 2
- 201 2
- 383 2
- 414 2
- 435 2
- 488 2
- 510 2
- 515 2
- 523 2
- 533 2
- 549 2
- 555 2
- 566 2
- 581 2
- 588 2
- 595 2
- 609 2
- 654 2
- 679 2
- 685 2
- 752 2
- 829 2
- 985 2
- 1027 2
- 1032 2
- 1033 2
- 1035 2
- 1036 2
- 1049 2
- 1059 2
- 1070 2
- 1075 2
- 1076 2
- 1088 2
- 1097 2
- 1104 2
- 1107 2
- 1109 2
- 1111 2
- 1117 2
- 1131 2
- 1137 2
- 1143 2
- 1146 2
- 1147 2
- 1165 2
- 1166 2
- 1171 2
- 1173 2
- 1179 2
- 1181 2
- 1208 2
- 1223 2
- 1414 2
- 1418 2
- 1431 2
- 1432 2
- 1447 2
- 6 1
- 29 1
- 30 1
- 59 1
- 64 1
- 66 1
- 76 1
- 85 1
- 90 1
- 95 1
- 100 1
- 114 1
- 124 1
- 134 1
- 137 1
- 153 1
- 184 1
- 198 1
- 211 1
- 227 1
- 230 1
- 239 1
- 243 1
- 253 1
- 262 1
- 267 1
- 273 1
- 278 1
- 282 1
- 284 1
- 292 1
- 302 1
- 309 1
- 321 1
- 326 1
- 327 1
- 331 1
- 340 1
- 364 1
- 371 1
- 378 1
- 387 1
- 391 1
- 396 1
- 403 1
- 410 1
- 413 1
- 416 1
- 418 1
- 421 1
- 422 1
- 428 1
- 429 1
- 431 1
- 432 1
- 438 1
- 445 1
- 450 1
- 457 1
- 463 1
- 468 1
- 473 1
- 478 1
- 492 1
- 494 1
- 496 1
- 497 1
- 498 1
- 499 1
- 502 1
- 509 1
- 511 1
- 513 1
- 517 1
- 520 1
- 522 1
- 527 1
- 528 1
- 531 1
- 535 1
- 537 1
- 538 1
- 542 1
- 543 1
- 547 1
- 550 1
- 558 1
- 560 1
- 561 1
- 563 1
- 567 1
- 569 1
- 572 1
- 573 1
- 574 1
- 579 1
- 592 1
- 594 1
- 598 1
- 600 1
- 601 1
- 607 1
- 611 1
- 612 1
- 617 1
- 620 1
- 622 1
- 625 1
- 628 1
- 629 1
- 632 1
- 633 1
- 647 1
- 648 1
- 649 1
- 651 1
- 653 1
- 660 1
- 663 1
- 666 1
- 670 1
- 675 1
- 683 1
- 687 1
- 689 1
- 691 1
- 697 1
- 699 1
- 715 1
- 720 1
- 725 1
- 730 1
- 733 1
- 738 1
- 742 1
- 749 1
- 753 1
- 760 1
- 762 1
- 772 1
- 782 1
- 788 1
- 792 1
- 798 1
- 803 1
- 816 1
- 821 1
- 826 1
- 827 1
- 828 1
- 830 1
- 841 1
- 851 1
- 859 1
- 870 1
- 880 1
- 889 1
- 908 1
- 920 1
- 930 1
- 949 1
- 956 1
- 990 1
- 995 1
- 1005 1
- 1012 1
- 1025 1
- 1029 1
- 1031 1
- 1037 1
- 1039 1
- 1041 1
- 1045 1
- 1048 1
- 1051 1
- 1052 1
- 1053 1
- 1054 1
- 1055 1
- 1056 1
- 1058 1
- 1061 1
- 1063 1
- 1064 1
- 1065 1
- 1068 1
- 1072 1
- 1079 1
- 1082 1
- 1087 1
- 1091 1
- 1092 1
- 1098 1
- 1099 1
- 1100 1
- 1102 1
- 1106 1
- 1118 1
- 1122 1
- 1123 1
- 1129 1
- 1130 1
- 1138 1
- 1145 1
- 1149 1
- 1153 1
- 1154 1
- 1155 1
- 1175 1
- 1180 1
- 1182 1
- 1184 1
- 1185 1
- 1192 1
- 1194 1
- 1209 1
- 1213 1
- 1215 1
- 1222 1
- 1230 1
- 1234 1
- 1242 1
- 1257 1
- 1280 1
- 1286 1
- 1291 1
- 1295 1
- 1310 1
- 1316 1
- 1321 1
- 1324 1
- 1338 1
- 1345 1
- 1346 1
- 1349 1
- 1370 1
- 1375 1
- 1378 1
- 1381 1
- 1384 1
- 1393 1
- 1395 1
- 1398 1
- 1411 1
- 1416 1
- 1420 1
- 1423 1
- 1427 1
- 1433 1
- 1435 1
- 1436 1
- 1442 1
- 1449 1
state 1
- Virginia 798
fips 1
- 51059 798
county 1
- Fairfax · 798 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502547 | 2502547 | 2022-05-13 | Fairfax | Virginia | 51059 | 188156 | 1453 |
2499289 | 2499289 | 2022-05-12 | Fairfax | Virginia | 51059 | 187548 | 1452 |
2496031 | 2496031 | 2022-05-11 | Fairfax | Virginia | 51059 | 186977 | 1452 |
2492773 | 2492773 | 2022-05-10 | Fairfax | Virginia | 51059 | 186366 | 1453 |
2489515 | 2489515 | 2022-05-09 | Fairfax | Virginia | 51059 | 185890 | 1452 |
2486258 | 2486258 | 2022-05-08 | Fairfax | Virginia | 51059 | 184736 | 1452 |
2483000 | 2483000 | 2022-05-07 | Fairfax | Virginia | 51059 | 184736 | 1452 |
2479742 | 2479742 | 2022-05-06 | Fairfax | Virginia | 51059 | 184736 | 1452 |
2476484 | 2476484 | 2022-05-05 | Fairfax | Virginia | 51059 | 184210 | 1453 |
2473226 | 2473226 | 2022-05-04 | Fairfax | Virginia | 51059 | 183706 | 1453 |
2469970 | 2469970 | 2022-05-03 | Fairfax | Virginia | 51059 | 183119 | 1451 |
2466714 | 2466714 | 2022-05-02 | Fairfax | Virginia | 51059 | 182828 | 1451 |
2463459 | 2463459 | 2022-05-01 | Fairfax | Virginia | 51059 | 182039 | 1451 |
2460203 | 2460203 | 2022-04-30 | Fairfax | Virginia | 51059 | 182039 | 1451 |
2456947 | 2456947 | 2022-04-29 | Fairfax | Virginia | 51059 | 182039 | 1451 |
2453691 | 2453691 | 2022-04-28 | Fairfax | Virginia | 51059 | 181703 | 1451 |
2450435 | 2450435 | 2022-04-27 | Fairfax | Virginia | 51059 | 181295 | 1449 |
2447178 | 2447178 | 2022-04-26 | Fairfax | Virginia | 51059 | 180989 | 1447 |
2443923 | 2443923 | 2022-04-25 | Fairfax | Virginia | 51059 | 180720 | 1447 |
2440667 | 2440667 | 2022-04-24 | Fairfax | Virginia | 51059 | 180026 | 1445 |
2437411 | 2437411 | 2022-04-23 | Fairfax | Virginia | 51059 | 180026 | 1445 |
2434155 | 2434155 | 2022-04-22 | Fairfax | Virginia | 51059 | 180026 | 1445 |
2430899 | 2430899 | 2022-04-21 | Fairfax | Virginia | 51059 | 179636 | 1444 |
2427643 | 2427643 | 2022-04-20 | Fairfax | Virginia | 51059 | 179307 | 1444 |
2424387 | 2424387 | 2022-04-19 | Fairfax | Virginia | 51059 | 179076 | 1444 |
2421131 | 2421131 | 2022-04-18 | Fairfax | Virginia | 51059 | 178867 | 1442 |
2417875 | 2417875 | 2022-04-17 | Fairfax | Virginia | 51059 | 178336 | 1441 |
2414619 | 2414619 | 2022-04-16 | Fairfax | Virginia | 51059 | 178336 | 1441 |
2411363 | 2411363 | 2022-04-15 | Fairfax | Virginia | 51059 | 178336 | 1441 |
2408107 | 2408107 | 2022-04-14 | Fairfax | Virginia | 51059 | 178036 | 1439 |
2404851 | 2404851 | 2022-04-13 | Fairfax | Virginia | 51059 | 177780 | 1438 |
2401596 | 2401596 | 2022-04-12 | Fairfax | Virginia | 51059 | 177581 | 1439 |
2398341 | 2398341 | 2022-04-11 | Fairfax | Virginia | 51059 | 177378 | 1439 |
2395086 | 2395086 | 2022-04-10 | Fairfax | Virginia | 51059 | 176962 | 1438 |
2391830 | 2391830 | 2022-04-09 | Fairfax | Virginia | 51059 | 176962 | 1438 |
2388574 | 2388574 | 2022-04-08 | Fairfax | Virginia | 51059 | 176962 | 1438 |
2385319 | 2385319 | 2022-04-07 | Fairfax | Virginia | 51059 | 176776 | 1436 |
2382064 | 2382064 | 2022-04-06 | Fairfax | Virginia | 51059 | 176598 | 1435 |
2378809 | 2378809 | 2022-04-05 | Fairfax | Virginia | 51059 | 176431 | 1433 |
2375555 | 2375555 | 2022-04-04 | Fairfax | Virginia | 51059 | 176256 | 1432 |
2372303 | 2372303 | 2022-04-03 | Fairfax | Virginia | 51059 | 175984 | 1434 |
2369050 | 2369050 | 2022-04-02 | Fairfax | Virginia | 51059 | 175984 | 1434 |
2365797 | 2365797 | 2022-04-01 | Fairfax | Virginia | 51059 | 175984 | 1434 |
2362544 | 2362544 | 2022-03-31 | Fairfax | Virginia | 51059 | 175885 | 1432 |
2359290 | 2359290 | 2022-03-30 | Fairfax | Virginia | 51059 | 175772 | 1431 |
2356036 | 2356036 | 2022-03-29 | Fairfax | Virginia | 51059 | 175664 | 1431 |
2352783 | 2352783 | 2022-03-28 | Fairfax | Virginia | 51059 | 175498 | 1427 |
2349531 | 2349531 | 2022-03-27 | Fairfax | Virginia | 51059 | 175257 | 1425 |
2346278 | 2346278 | 2022-03-26 | Fairfax | Virginia | 51059 | 175257 | 1425 |
2343025 | 2343025 | 2022-03-25 | Fairfax | Virginia | 51059 | 175257 | 1425 |
2339772 | 2339772 | 2022-03-24 | Fairfax | Virginia | 51059 | 175107 | 1423 |
2336518 | 2336518 | 2022-03-23 | Fairfax | Virginia | 51059 | 175010 | 1420 |
2333264 | 2333264 | 2022-03-22 | Fairfax | Virginia | 51059 | 174814 | 1418 |
2330011 | 2330011 | 2022-03-21 | Fairfax | Virginia | 51059 | 174814 | 1418 |
2326759 | 2326759 | 2022-03-20 | Fairfax | Virginia | 51059 | 174638 | 1417 |
2323506 | 2323506 | 2022-03-19 | Fairfax | Virginia | 51059 | 174638 | 1417 |
2320252 | 2320252 | 2022-03-18 | Fairfax | Virginia | 51059 | 174638 | 1417 |
2316998 | 2316998 | 2022-03-17 | Fairfax | Virginia | 51059 | 174491 | 1416 |
2313745 | 2313745 | 2022-03-16 | Fairfax | Virginia | 51059 | 174407 | 1414 |
2310492 | 2310492 | 2022-03-15 | Fairfax | Virginia | 51059 | 174337 | 1414 |
2307239 | 2307239 | 2022-03-14 | Fairfax | Virginia | 51059 | 174218 | 1411 |
2303988 | 2303988 | 2022-03-13 | Fairfax | Virginia | 51059 | 173981 | 1401 |
2300736 | 2300736 | 2022-03-12 | Fairfax | Virginia | 51059 | 173981 | 1401 |
2297484 | 2297484 | 2022-03-11 | Fairfax | Virginia | 51059 | 173981 | 1401 |
2294232 | 2294232 | 2022-03-10 | Fairfax | Virginia | 51059 | 173856 | 1398 |
2290980 | 2290980 | 2022-03-09 | Fairfax | Virginia | 51059 | 173759 | 1395 |
2287728 | 2287728 | 2022-03-08 | Fairfax | Virginia | 51059 | 173584 | 1393 |
2284476 | 2284476 | 2022-03-07 | Fairfax | Virginia | 51059 | 173437 | 1384 |
2281224 | 2281224 | 2022-03-06 | Fairfax | Virginia | 51059 | 173225 | 1382 |
2277971 | 2277971 | 2022-03-05 | Fairfax | Virginia | 51059 | 173225 | 1382 |
2274718 | 2274718 | 2022-03-04 | Fairfax | Virginia | 51059 | 173225 | 1382 |
2271465 | 2271465 | 2022-03-03 | Fairfax | Virginia | 51059 | 173087 | 1381 |
2268213 | 2268213 | 2022-03-02 | Fairfax | Virginia | 51059 | 172919 | 1378 |
2264960 | 2264960 | 2022-03-01 | Fairfax | Virginia | 51059 | 172780 | 1375 |
2261710 | 2261710 | 2022-02-28 | Fairfax | Virginia | 51059 | 172659 | 1370 |
2258459 | 2258459 | 2022-02-27 | Fairfax | Virginia | 51059 | 172256 | 1355 |
2255208 | 2255208 | 2022-02-26 | Fairfax | Virginia | 51059 | 172256 | 1355 |
2251957 | 2251957 | 2022-02-25 | Fairfax | Virginia | 51059 | 172256 | 1355 |
2248706 | 2248706 | 2022-02-24 | Fairfax | Virginia | 51059 | 172124 | 1349 |
2245455 | 2245455 | 2022-02-23 | Fairfax | Virginia | 51059 | 172045 | 1346 |
2242204 | 2242204 | 2022-02-22 | Fairfax | Virginia | 51059 | 171883 | 1345 |
2238953 | 2238953 | 2022-02-21 | Fairfax | Virginia | 51059 | 171799 | 1338 |
2235702 | 2235702 | 2022-02-20 | Fairfax | Virginia | 51059 | 171344 | 1331 |
2232451 | 2232451 | 2022-02-19 | Fairfax | Virginia | 51059 | 171344 | 1331 |
2229200 | 2229200 | 2022-02-18 | Fairfax | Virginia | 51059 | 171344 | 1331 |
2225949 | 2225949 | 2022-02-17 | Fairfax | Virginia | 51059 | 171227 | 1324 |
2222698 | 2222698 | 2022-02-16 | Fairfax | Virginia | 51059 | 171079 | 1321 |
2219447 | 2219447 | 2022-02-15 | Fairfax | Virginia | 51059 | 170965 | 1316 |
2216197 | 2216197 | 2022-02-14 | Fairfax | Virginia | 51059 | 170760 | 1310 |
2212946 | 2212946 | 2022-02-13 | Fairfax | Virginia | 51059 | 170207 | 1299 |
2209693 | 2209693 | 2022-02-12 | Fairfax | Virginia | 51059 | 170207 | 1299 |
2206440 | 2206440 | 2022-02-11 | Fairfax | Virginia | 51059 | 170207 | 1299 |
2203187 | 2203187 | 2022-02-10 | Fairfax | Virginia | 51059 | 169905 | 1295 |
2199933 | 2199933 | 2022-02-09 | Fairfax | Virginia | 51059 | 169609 | 1291 |
2196679 | 2196679 | 2022-02-08 | Fairfax | Virginia | 51059 | 169343 | 1286 |
2193424 | 2193424 | 2022-02-07 | Fairfax | Virginia | 51059 | 168980 | 1280 |
2190171 | 2190171 | 2022-02-06 | Fairfax | Virginia | 51059 | 168027 | 1263 |
2186918 | 2186918 | 2022-02-05 | Fairfax | Virginia | 51059 | 168027 | 1263 |
2183665 | 2183665 | 2022-02-04 | Fairfax | Virginia | 51059 | 168027 | 1263 |
2180413 | 2180413 | 2022-02-03 | Fairfax | Virginia | 51059 | 167576 | 1257 |
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);