ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
132 rows where date = "2020-03-09" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
state >30
- California 21
- Washington 10
- Florida 8
- Georgia 8
- Colorado 7
- New York 7
- New Jersey 6
- Massachusetts 5
- Oregon 5
- Pennsylvania 4
- Texas 4
- Arizona 3
- Indiana 3
- Kentucky 3
- Maryland 3
- South Carolina 3
- Tennessee 3
- Utah 3
- Iowa 2
- Minnesota 2
- Nevada 2
- New Hampshire 2
- North Carolina 2
- Virginia 2
- Wisconsin 2
- Connecticut 1
- District of Columbia 1
- Hawaii 1
- Illinois 1
- Kansas 1
- …
fips >30
county >30
- Jefferson 4
- Douglas 3
- Clark 2
- Fayette 2
- Johnson 2
- Marion 2
- Montgomery 2
- Pierce 2
- Suffolk 2
- Washington 2
- Alameda 1
- Arapahoe 1
- Bennington 1
- Bergen 1
- Berkshire 1
- Bexar 1
- Broward 1
- Camden 1
- Carver 1
- Charleston 1
- Charlotte 1
- Chatham 1
- Chelan 1
- Cherokee 1
- Cobb 1
- Collin 1
- Contra Costa 1
- Cook 1
- Cuyahoga 1
- Dane 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
864 | 864 | 2020-03-09 | Maricopa | Arizona | 4013 | 2 | 0 |
865 | 865 | 2020-03-09 | Pima | Arizona | 4019 | 1 | 0 |
866 | 866 | 2020-03-09 | Pinal | Arizona | 4021 | 3 | 0 |
867 | 867 | 2020-03-09 | Alameda | California | 6001 | 24 | 0 |
868 | 868 | 2020-03-09 | Contra Costa | California | 6013 | 9 | 0 |
869 | 869 | 2020-03-09 | Fresno | California | 6019 | 1 | 0 |
870 | 870 | 2020-03-09 | Humboldt | California | 6023 | 1 | 0 |
871 | 871 | 2020-03-09 | Los Angeles | California | 6037 | 19 | 0 |
872 | 872 | 2020-03-09 | Madera | California | 6039 | 1 | 0 |
873 | 873 | 2020-03-09 | Marin | California | 6041 | 2 | 0 |
874 | 874 | 2020-03-09 | Napa | California | 6055 | 1 | 0 |
875 | 875 | 2020-03-09 | Orange | California | 6059 | 5 | 0 |
876 | 876 | 2020-03-09 | Placer | California | 6061 | 7 | 1 |
877 | 877 | 2020-03-09 | Riverside | California | 6065 | 4 | 0 |
878 | 878 | 2020-03-09 | Sacramento | California | 6067 | 9 | 0 |
879 | 879 | 2020-03-09 | San Diego | California | 6073 | 2 | 0 |
880 | 880 | 2020-03-09 | San Francisco | California | 6075 | 16 | 0 |
881 | 881 | 2020-03-09 | San Mateo | California | 6081 | 9 | 0 |
882 | 882 | 2020-03-09 | Santa Clara | California | 6085 | 43 | 1 |
883 | 883 | 2020-03-09 | Santa Cruz | California | 6087 | 2 | 0 |
884 | 884 | 2020-03-09 | Shasta | California | 6089 | 1 | 0 |
885 | 885 | 2020-03-09 | Solano | California | 6095 | 12 | 0 |
886 | 886 | 2020-03-09 | Sonoma | California | 6097 | 3 | 0 |
887 | 887 | 2020-03-09 | Yolo | California | 6113 | 1 | 0 |
888 | 888 | 2020-03-09 | Arapahoe | Colorado | 8005 | 1 | 0 |
889 | 889 | 2020-03-09 | Denver | Colorado | 8031 | 3 | 0 |
890 | 890 | 2020-03-09 | Douglas | Colorado | 8035 | 3 | 0 |
891 | 891 | 2020-03-09 | Eagle | Colorado | 8037 | 2 | 0 |
892 | 892 | 2020-03-09 | El Paso | Colorado | 8041 | 1 | 0 |
893 | 893 | 2020-03-09 | Jefferson | Colorado | 8059 | 1 | 0 |
894 | 894 | 2020-03-09 | Larimer | Colorado | 8069 | 1 | 0 |
895 | 895 | 2020-03-09 | Fairfield | Connecticut | 9001 | 2 | 0 |
896 | 896 | 2020-03-09 | District of Columbia | District of Columbia | 11001 | 4 | 0 |
897 | 897 | 2020-03-09 | Broward | Florida | 12011 | 3 | 0 |
898 | 898 | 2020-03-09 | Charlotte | Florida | 12015 | 1 | 0 |
899 | 899 | 2020-03-09 | Hillsborough | Florida | 12057 | 2 | 0 |
900 | 900 | 2020-03-09 | Lee | Florida | 12071 | 2 | 1 |
901 | 901 | 2020-03-09 | Manatee | Florida | 12081 | 2 | 0 |
902 | 902 | 2020-03-09 | Okaloosa | Florida | 12091 | 1 | 0 |
903 | 903 | 2020-03-09 | Santa Rosa | Florida | 12113 | 1 | 1 |
904 | 904 | 2020-03-09 | Volusia | Florida | 12127 | 2 | 0 |
905 | 905 | 2020-03-09 | Cherokee | Georgia | 13057 | 1 | 0 |
906 | 906 | 2020-03-09 | Cobb | Georgia | 13067 | 4 | 0 |
907 | 907 | 2020-03-09 | DeKalb | Georgia | 13089 | 2 | 0 |
908 | 908 | 2020-03-09 | Fayette | Georgia | 13113 | 1 | 0 |
909 | 909 | 2020-03-09 | Floyd | Georgia | 13115 | 1 | 0 |
910 | 910 | 2020-03-09 | Fulton | Georgia | 13121 | 5 | 0 |
911 | 911 | 2020-03-09 | Gwinnett | Georgia | 13135 | 2 | 0 |
912 | 912 | 2020-03-09 | Polk | Georgia | 13233 | 1 | 0 |
913 | 913 | 2020-03-09 | Honolulu | Hawaii | 15003 | 2 | 0 |
914 | 914 | 2020-03-09 | Cook | Illinois | 17031 | 11 | 0 |
915 | 915 | 2020-03-09 | Hendricks | Indiana | 18063 | 2 | 0 |
916 | 916 | 2020-03-09 | Marion | Indiana | 18097 | 1 | 0 |
917 | 917 | 2020-03-09 | Noble | Indiana | 18113 | 1 | 0 |
918 | 918 | 2020-03-09 | Johnson | Iowa | 19103 | 7 | 0 |
919 | 919 | 2020-03-09 | Pottawattamie | Iowa | 19155 | 1 | 0 |
920 | 920 | 2020-03-09 | Johnson | Kansas | 20091 | 1 | 0 |
921 | 921 | 2020-03-09 | Fayette | Kentucky | 21067 | 3 | 0 |
922 | 922 | 2020-03-09 | Harrison | Kentucky | 21097 | 1 | 0 |
923 | 923 | 2020-03-09 | Jefferson | Kentucky | 21111 | 1 | 0 |
924 | 924 | 2020-03-09 | Jefferson | Louisiana | 22051 | 1 | 0 |
925 | 925 | 2020-03-09 | Harford | Maryland | 24025 | 1 | 0 |
926 | 926 | 2020-03-09 | Montgomery | Maryland | 24031 | 4 | 0 |
927 | 927 | 2020-03-09 | Prince George's | Maryland | 24033 | 1 | 0 |
928 | 928 | 2020-03-09 | Berkshire | Massachusetts | 25003 | 5 | 0 |
929 | 929 | 2020-03-09 | Middlesex | Massachusetts | 25017 | 15 | 0 |
930 | 930 | 2020-03-09 | Norfolk | Massachusetts | 25021 | 10 | 0 |
931 | 931 | 2020-03-09 | Suffolk | Massachusetts | 25025 | 10 | 0 |
932 | 932 | 2020-03-09 | Worcester | Massachusetts | 25027 | 1 | 0 |
933 | 933 | 2020-03-09 | Carver | Minnesota | 27019 | 1 | 0 |
934 | 934 | 2020-03-09 | Ramsey | Minnesota | 27123 | 1 | 0 |
935 | 935 | 2020-03-09 | St. Louis | Missouri | 29189 | 1 | 0 |
936 | 936 | 2020-03-09 | Douglas | Nebraska | 31055 | 16 | 0 |
937 | 937 | 2020-03-09 | Clark | Nevada | 32003 | 2 | 0 |
938 | 938 | 2020-03-09 | Washoe | Nevada | 32031 | 2 | 0 |
939 | 939 | 2020-03-09 | Grafton | New Hampshire | 33009 | 3 | 0 |
940 | 940 | 2020-03-09 | Rockingham | New Hampshire | 33015 | 1 | 0 |
941 | 941 | 2020-03-09 | Bergen | New Jersey | 34003 | 5 | 0 |
942 | 942 | 2020-03-09 | Camden | New Jersey | 34007 | 1 | 0 |
943 | 943 | 2020-03-09 | Hudson | New Jersey | 34017 | 1 | 0 |
944 | 944 | 2020-03-09 | Monmouth | New Jersey | 34025 | 2 | 0 |
945 | 945 | 2020-03-09 | Passaic | New Jersey | 34031 | 1 | 0 |
946 | 946 | 2020-03-09 | Union | New Jersey | 34039 | 1 | 0 |
947 | 947 | 2020-03-09 | Nassau | New York | 36059 | 17 | 0 |
948 | 948 | 2020-03-09 | New York City | New York | 20 | 0 | |
949 | 949 | 2020-03-09 | Rockland | New York | 36087 | 4 | 0 |
950 | 950 | 2020-03-09 | Saratoga | New York | 36091 | 2 | 0 |
951 | 951 | 2020-03-09 | Suffolk | New York | 36103 | 1 | 0 |
952 | 952 | 2020-03-09 | Ulster | New York | 36111 | 1 | 0 |
953 | 953 | 2020-03-09 | Westchester | New York | 36119 | 97 | 0 |
954 | 954 | 2020-03-09 | Chatham | North Carolina | 37037 | 1 | 0 |
955 | 955 | 2020-03-09 | Wake | North Carolina | 37183 | 6 | 0 |
956 | 956 | 2020-03-09 | Cuyahoga | Ohio | 39035 | 3 | 0 |
957 | 957 | 2020-03-09 | Tulsa | Oklahoma | 40143 | 1 | 0 |
958 | 958 | 2020-03-09 | Douglas | Oregon | 41019 | 1 | 0 |
959 | 959 | 2020-03-09 | Jackson | Oregon | 41029 | 2 | 0 |
960 | 960 | 2020-03-09 | Klamath | Oregon | 41035 | 1 | 0 |
961 | 961 | 2020-03-09 | Marion | Oregon | 41047 | 1 | 0 |
962 | 962 | 2020-03-09 | Washington | Oregon | 41067 | 8 | 0 |
963 | 963 | 2020-03-09 | Delaware | Pennsylvania | 42045 | 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);