us-counties

Table actions

Data source: Big Local News · About: big-local-datasette

570,096 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▲ date county state fips cases deaths
569896 569896 2020-09-25 Virginia Beach city Virginia 51810 6776 88
569895 569895 2020-09-25 Tazewell Virginia 51185 284 2
569894 569894 2020-09-25 Sussex Virginia 51183 462 11
569893 569893 2020-09-25 Surry Virginia 51181 118 3
569892 569892 2020-09-25 Suffolk city Virginia 51800 1963 72
569891 569891 2020-09-25 Staunton city Virginia 51790 251 0
569890 569890 2020-09-25 Stafford Virginia 51179 1998 17
569889 569889 2020-09-25 Spotsylvania Virginia 51177 2121 44
569888 569888 2020-09-25 Southampton Virginia 51175 748 23
569887 569887 2020-09-25 Smyth Virginia 51173 457 10
569886 569886 2020-09-25 Shenandoah Virginia 51171 805 58
569885 569885 2020-09-25 Scott Virginia 51169 184 4
569884 569884 2020-09-25 Salem city Virginia 51775 264 5
569883 569883 2020-09-25 Russell Virginia 51167 254 5
569882 569882 2020-09-25 Rockingham Virginia 51165 1414 21
569881 569881 2020-09-25 Rockbridge Virginia 51163 108 2
569880 569880 2020-09-25 Roanoke city Virginia 51770 1656 23
569879 569879 2020-09-25 Roanoke Virginia 51161 842 7
569878 569878 2020-09-25 Richmond city Virginia 51760 4595 61
569877 569877 2020-09-25 Richmond Virginia 51159 346 4
569876 569876 2020-09-25 Rappahannock Virginia 51157 64 2
569875 569875 2020-09-25 Radford city Virginia 51750 734 1
569874 569874 2020-09-25 Pulaski Virginia 51155 225 5
569873 569873 2020-09-25 Prince William Virginia 51153 12318 202
569872 569872 2020-09-25 Prince George Virginia 51149 791 5
569871 569871 2020-09-25 Prince Edward Virginia 51147 577 12
569870 569870 2020-09-25 Powhatan Virginia 51145 219 5
569869 569869 2020-09-25 Portsmouth city Virginia 51740 2547 58
569868 569868 2020-09-25 Poquoson city Virginia 51735 74 2
569867 569867 2020-09-25 Pittsylvania Virginia 51143 985 9
569866 569866 2020-09-25 Petersburg city Virginia 51730 734 29
569865 569865 2020-09-25 Patrick Virginia 51141 276 24
569864 569864 2020-09-25 Page Virginia 51139 390 29
569863 569863 2020-09-25 Orange Virginia 51137 320 4
569862 569862 2020-09-25 Nottoway Virginia 51135 257 18
569861 569861 2020-09-25 Norton city Virginia 51720 33 0
569860 569860 2020-09-25 Northumberland Virginia 51133 152 6
569859 569859 2020-09-25 Northampton Virginia 51131 305 31
569858 569858 2020-09-25 Norfolk city Virginia 51710 4800 78
569857 569857 2020-09-25 Newport News city Virginia 51700 2715 38
569856 569856 2020-09-25 New Kent Virginia 51127 188 3
569855 569855 2020-09-25 Nelson Virginia 51125 100 2
569854 569854 2020-09-25 Montgomery Virginia 51121 1880 4
569853 569853 2020-09-25 Middlesex Virginia 51119 113 10
569852 569852 2020-09-25 Mecklenburg Virginia 51117 711 33
569851 569851 2020-09-25 Mathews Virginia 51115 49 0
569850 569850 2020-09-25 Martinsville city Virginia 51690 380 16
569849 569849 2020-09-25 Manassas city Virginia 51683 1918 25
569848 569848 2020-09-25 Manassas Park city Virginia 51685 610 8
569847 569847 2020-09-25 Madison Virginia 51113 106 3
569846 569846 2020-09-25 Lynchburg city Virginia 51680 1374 13
569845 569845 2020-09-25 Lunenburg Virginia 51111 116 3
569844 569844 2020-09-25 Louisa Virginia 51109 287 6
569843 569843 2020-09-25 Loudoun Virginia 51107 6774 124
569842 569842 2020-09-25 Lexington city Virginia 51678 73 1
569841 569841 2020-09-25 Lee Virginia 51105 266 7
569840 569840 2020-09-25 Lancaster Virginia 51103 142 0
569839 569839 2020-09-25 King and Queen Virginia 51097 72 1
569838 569838 2020-09-25 King William Virginia 51101 157 2
569837 569837 2020-09-25 King George Virginia 51099 228 4
569836 569836 2020-09-25 James City Virginia 51095 842 20
569835 569835 2020-09-25 Isle of Wight Virginia 51093 723 19
569834 569834 2020-09-25 Hopewell city Virginia 51670 390 7
569833 569833 2020-09-25 Highland Virginia 51091 7 0
569832 569832 2020-09-25 Henry Virginia 51089 1042 20
569831 569831 2020-09-25 Henrico Virginia 51087 5399 211
569830 569830 2020-09-25 Harrisonburg city Virginia 51660 2578 34
569829 569829 2020-09-25 Hanover Virginia 51085 1286 37
569828 569828 2020-09-25 Hampton city Virginia 51650 1803 24
569827 569827 2020-09-25 Halifax Virginia 51083 342 6
569826 569826 2020-09-25 Greensville Virginia 51081 782 11
569825 569825 2020-09-25 Greene Virginia 51079 216 3
569824 569824 2020-09-25 Grayson Virginia 51077 308 12
569823 569823 2020-09-25 Goochland Virginia 51075 266 7
569822 569822 2020-09-25 Gloucester Virginia 51073 235 2
569821 569821 2020-09-25 Giles Virginia 51071 88 0
569820 569820 2020-09-25 Galax city Virginia 51640 413 30
569819 569819 2020-09-25 Fredericksburg city Virginia 51630 535 5
569818 569818 2020-09-25 Frederick Virginia 51069 873 13
569817 569817 2020-09-25 Franklin city Virginia 51620 413 9
569816 569816 2020-09-25 Franklin Virginia 51067 333 3
569815 569815 2020-09-25 Fluvanna Virginia 51065 375 9
569814 569814 2020-09-25 Floyd Virginia 51063 201 9
569813 569813 2020-09-25 Fauquier Virginia 51061 925 25
569812 569812 2020-09-25 Falls Church city Virginia 51610 70 6
569811 569811 2020-09-25 Fairfax city Virginia 51600 135 8
569810 569810 2020-09-25 Fairfax Virginia 51059 20627 586
569809 569809 2020-09-25 Essex Virginia 51057 176 2
569808 569808 2020-09-25 Emporia city Virginia 51595 255 26
569807 569807 2020-09-25 Dinwiddie Virginia 51053 376 11
569806 569806 2020-09-25 Dickenson Virginia 51051 99 1
569805 569805 2020-09-25 Danville city Virginia 51590 860 27
569804 569804 2020-09-25 Cumberland Virginia 51049 104 2
569803 569803 2020-09-25 Culpeper Virginia 51047 1190 17
569802 569802 2020-09-25 Craig Virginia 51045 29 0
569801 569801 2020-09-25 Covington city Virginia 51580 32 0
569800 569800 2020-09-25 Colonial Heights city Virginia 51570 253 25
569799 569799 2020-09-25 Clarke Virginia 51043 94 0
569798 569798 2020-09-25 Chesterfield Virginia 51041 5916 94
569797 569797 2020-09-25 Chesapeake city Virginia 51550 4271 71

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);