ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,532 rows where date = "2020-03-25" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state >30
- Georgia 97
- Texas 85
- Mississippi 60
- North Carolina 56
- Indiana 55
- Ohio 55
- New York 53
- Tennessee 53
- Virginia 53
- Louisiana 49
- Florida 47
- Michigan 47
- California 44
- Pennsylvania 44
- Alabama 41
- Missouri 40
- Arkansas 39
- South Carolina 39
- Colorado 37
- Illinois 36
- Kentucky 36
- Minnesota 34
- Wisconsin 34
- Washington 33
- Iowa 31
- Oklahoma 27
- Kansas 23
- Maryland 22
- New Jersey 22
- Oregon 20
- …
fips >30
county >30
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10836 | 10836 | 2020-03-25 | Autauga | Alabama | 1001 | 4 | 0 |
10837 | 10837 | 2020-03-25 | Baldwin | Alabama | 1003 | 4 | 0 |
10838 | 10838 | 2020-03-25 | Blount | Alabama | 1009 | 1 | 0 |
10839 | 10839 | 2020-03-25 | Butler | Alabama | 1013 | 1 | 0 |
10840 | 10840 | 2020-03-25 | Calhoun | Alabama | 1015 | 2 | 0 |
10841 | 10841 | 2020-03-25 | Chambers | Alabama | 1017 | 10 | 0 |
10842 | 10842 | 2020-03-25 | Cherokee | Alabama | 1019 | 1 | 0 |
10843 | 10843 | 2020-03-25 | Chilton | Alabama | 1021 | 1 | 0 |
10844 | 10844 | 2020-03-25 | Clay | Alabama | 1027 | 1 | 0 |
10845 | 10845 | 2020-03-25 | Cleburne | Alabama | 1029 | 1 | 0 |
10846 | 10846 | 2020-03-25 | Colbert | Alabama | 1033 | 1 | 0 |
10847 | 10847 | 2020-03-25 | Cullman | Alabama | 1043 | 4 | 0 |
10848 | 10848 | 2020-03-25 | Dallas | Alabama | 1047 | 2 | 0 |
10849 | 10849 | 2020-03-25 | Elmore | Alabama | 1051 | 9 | 0 |
10850 | 10850 | 2020-03-25 | Etowah | Alabama | 1055 | 3 | 0 |
10851 | 10851 | 2020-03-25 | Franklin | Alabama | 1059 | 2 | 0 |
10852 | 10852 | 2020-03-25 | Houston | Alabama | 1069 | 2 | 0 |
10853 | 10853 | 2020-03-25 | Jackson | Alabama | 1071 | 2 | 1 |
10854 | 10854 | 2020-03-25 | Jefferson | Alabama | 1073 | 129 | 0 |
10855 | 10855 | 2020-03-25 | Lamar | Alabama | 1075 | 1 | 0 |
10856 | 10856 | 2020-03-25 | Lauderdale | Alabama | 1077 | 7 | 0 |
10857 | 10857 | 2020-03-25 | Lawrence | Alabama | 1079 | 1 | 0 |
10858 | 10858 | 2020-03-25 | Lee | Alabama | 1081 | 40 | 0 |
10859 | 10859 | 2020-03-25 | Limestone | Alabama | 1083 | 6 | 0 |
10860 | 10860 | 2020-03-25 | Madison | Alabama | 1089 | 35 | 0 |
10861 | 10861 | 2020-03-25 | Marion | Alabama | 1093 | 3 | 0 |
10862 | 10862 | 2020-03-25 | Marshall | Alabama | 1095 | 1 | 0 |
10863 | 10863 | 2020-03-25 | Mobile | Alabama | 1097 | 10 | 0 |
10864 | 10864 | 2020-03-25 | Montgomery | Alabama | 1101 | 13 | 0 |
10865 | 10865 | 2020-03-25 | Morgan | Alabama | 1103 | 5 | 0 |
10866 | 10866 | 2020-03-25 | Pickens | Alabama | 1107 | 1 | 0 |
10867 | 10867 | 2020-03-25 | Pike | Alabama | 1109 | 1 | 0 |
10868 | 10868 | 2020-03-25 | Russell | Alabama | 1113 | 1 | 0 |
10869 | 10869 | 2020-03-25 | Shelby | Alabama | 1117 | 42 | 0 |
10870 | 10870 | 2020-03-25 | St. Clair | Alabama | 1115 | 6 | 0 |
10871 | 10871 | 2020-03-25 | Talladega | Alabama | 1121 | 3 | 0 |
10872 | 10872 | 2020-03-25 | Tallapoosa | Alabama | 1123 | 4 | 0 |
10873 | 10873 | 2020-03-25 | Tuscaloosa | Alabama | 1125 | 15 | 0 |
10874 | 10874 | 2020-03-25 | Walker | Alabama | 1127 | 9 | 0 |
10875 | 10875 | 2020-03-25 | Washington | Alabama | 1129 | 1 | 0 |
10876 | 10876 | 2020-03-25 | Wilcox | Alabama | 1131 | 1 | 0 |
10877 | 10877 | 2020-03-25 | Anchorage | Alaska | 2020 | 28 | 0 |
10878 | 10878 | 2020-03-25 | Fairbanks North Star Borough | Alaska | 2090 | 11 | 0 |
10879 | 10879 | 2020-03-25 | Juneau City and Borough | Alaska | 2110 | 2 | 0 |
10880 | 10880 | 2020-03-25 | Kenai Peninsula Borough | Alaska | 2122 | 5 | 0 |
10881 | 10881 | 2020-03-25 | Ketchikan Gateway Borough | Alaska | 2130 | 11 | 0 |
10882 | 10882 | 2020-03-25 | Matanuska-Susitna Borough | Alaska | 2170 | 2 | 0 |
10883 | 10883 | 2020-03-25 | Apache | Arizona | 4001 | 7 | 0 |
10884 | 10884 | 2020-03-25 | Cochise | Arizona | 4003 | 1 | 0 |
10885 | 10885 | 2020-03-25 | Coconino | Arizona | 4005 | 23 | 1 |
10886 | 10886 | 2020-03-25 | Graham | Arizona | 4009 | 2 | 0 |
10887 | 10887 | 2020-03-25 | Maricopa | Arizona | 4013 | 251 | 2 |
10888 | 10888 | 2020-03-25 | Navajo | Arizona | 4017 | 37 | 0 |
10889 | 10889 | 2020-03-25 | Pima | Arizona | 4019 | 49 | 0 |
10890 | 10890 | 2020-03-25 | Pinal | Arizona | 4021 | 23 | 0 |
10891 | 10891 | 2020-03-25 | Santa Cruz | Arizona | 4023 | 2 | 0 |
10892 | 10892 | 2020-03-25 | Unknown | Arizona | 0 | 3 | |
10893 | 10893 | 2020-03-25 | Yavapai | Arizona | 4025 | 4 | 0 |
10894 | 10894 | 2020-03-25 | Yuma | Arizona | 4027 | 3 | 0 |
10895 | 10895 | 2020-03-25 | Benton | Arkansas | 5007 | 18 | 0 |
10896 | 10896 | 2020-03-25 | Boone | Arkansas | 5009 | 1 | 0 |
10897 | 10897 | 2020-03-25 | Bradley | Arkansas | 5011 | 4 | 0 |
10898 | 10898 | 2020-03-25 | Clark | Arkansas | 5019 | 13 | 0 |
10899 | 10899 | 2020-03-25 | Cleburne | Arkansas | 5023 | 41 | 1 |
10900 | 10900 | 2020-03-25 | Cleveland | Arkansas | 5025 | 4 | 0 |
10901 | 10901 | 2020-03-25 | Columbia | Arkansas | 5027 | 1 | 0 |
10902 | 10902 | 2020-03-25 | Conway | Arkansas | 5029 | 2 | 0 |
10903 | 10903 | 2020-03-25 | Craighead | Arkansas | 5031 | 4 | 0 |
10904 | 10904 | 2020-03-25 | Crawford | Arkansas | 5033 | 1 | 0 |
10905 | 10905 | 2020-03-25 | Crittenden | Arkansas | 5035 | 7 | 0 |
10906 | 10906 | 2020-03-25 | Cross | Arkansas | 5037 | 1 | 0 |
10907 | 10907 | 2020-03-25 | Desha | Arkansas | 5041 | 2 | 0 |
10908 | 10908 | 2020-03-25 | Drew | Arkansas | 5043 | 1 | 0 |
10909 | 10909 | 2020-03-25 | Faulkner | Arkansas | 5045 | 23 | 0 |
10910 | 10910 | 2020-03-25 | Garland | Arkansas | 5051 | 18 | 0 |
10911 | 10911 | 2020-03-25 | Grant | Arkansas | 5053 | 3 | 0 |
10912 | 10912 | 2020-03-25 | Greene | Arkansas | 5055 | 3 | 0 |
10913 | 10913 | 2020-03-25 | Hot Spring | Arkansas | 5059 | 1 | 0 |
10914 | 10914 | 2020-03-25 | Independence | Arkansas | 5063 | 3 | 0 |
10915 | 10915 | 2020-03-25 | Jefferson | Arkansas | 5069 | 22 | 0 |
10916 | 10916 | 2020-03-25 | Lawrence | Arkansas | 5075 | 1 | 0 |
10917 | 10917 | 2020-03-25 | Lincoln | Arkansas | 5079 | 4 | 0 |
10918 | 10918 | 2020-03-25 | Pike | Arkansas | 5109 | 2 | 0 |
10919 | 10919 | 2020-03-25 | Poinsett | Arkansas | 5111 | 3 | 0 |
10920 | 10920 | 2020-03-25 | Polk | Arkansas | 5113 | 2 | 0 |
10921 | 10921 | 2020-03-25 | Pope | Arkansas | 5115 | 3 | 0 |
10922 | 10922 | 2020-03-25 | Pulaski | Arkansas | 5119 | 79 | 1 |
10923 | 10923 | 2020-03-25 | Saline | Arkansas | 5125 | 4 | 0 |
10924 | 10924 | 2020-03-25 | Searcy | Arkansas | 5129 | 2 | 0 |
10925 | 10925 | 2020-03-25 | Sebastian | Arkansas | 5131 | 1 | 0 |
10926 | 10926 | 2020-03-25 | Sevier | Arkansas | 5133 | 1 | 0 |
10927 | 10927 | 2020-03-25 | Stone | Arkansas | 5137 | 3 | 0 |
10928 | 10928 | 2020-03-25 | Union | Arkansas | 5139 | 2 | 0 |
10929 | 10929 | 2020-03-25 | Unknown | Arkansas | 2 | 0 | |
10930 | 10930 | 2020-03-25 | Van Buren | Arkansas | 5141 | 10 | 0 |
10931 | 10931 | 2020-03-25 | Washington | Arkansas | 5143 | 10 | 0 |
10932 | 10932 | 2020-03-25 | White | Arkansas | 5145 | 4 | 0 |
10933 | 10933 | 2020-03-25 | Woodruff | Arkansas | 5147 | 1 | 0 |
10934 | 10934 | 2020-03-25 | Alameda | California | 6001 | 156 | 2 |
10935 | 10935 | 2020-03-25 | Amador | California | 6005 | 1 | 0 |
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);