ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

4,028 rows where county = "Adams" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Adams · 4,028 ✖
Link rowid date ▲ county state fips cases deaths
1095943 1095943 2021-03-07 Adams Colorado 8001 49858 631
1096256 1096256 2021-03-07 Adams Idaho 16003 331 4
1096299 1096299 2021-03-07 Adams Illinois 17001 8046 143
1096402 1096402 2021-03-07 Adams Indiana 18001 3298 50
1096495 1096495 2021-03-07 Adams Iowa 19003 317 4
1097114 1097114 2021-03-07 Adams Mississippi 28001 2359 78
1097369 1097369 2021-03-07 Adams Nebraska 31001 2722 38
1097704 1097704 2021-03-07 Adams North Dakota 38001 266 3
1097760 1097760 2021-03-07 Adams Ohio 39001 2183 39
1097963 1097963 2021-03-07 Adams Pennsylvania 42001 7429 152
1098758 1098758 2021-03-07 Adams Washington 53001 1931 21
1098852 1098852 2021-03-07 Adams Wisconsin 55001 1754 15
1092697 1092697 2021-03-06 Adams Colorado 8001 49858 631
1093010 1093010 2021-03-06 Adams Idaho 16003 331 4
1093053 1093053 2021-03-06 Adams Illinois 17001 8037 143
1093156 1093156 2021-03-06 Adams Indiana 18001 3289 50
1093249 1093249 2021-03-06 Adams Iowa 19003 317 4
1093867 1093867 2021-03-06 Adams Mississippi 28001 2357 78
1094122 1094122 2021-03-06 Adams Nebraska 31001 2722 38
1094456 1094456 2021-03-06 Adams North Dakota 38001 266 3
1094512 1094512 2021-03-06 Adams Ohio 39001 2182 39
1094715 1094715 2021-03-06 Adams Pennsylvania 42001 7406 152
1095510 1095510 2021-03-06 Adams Washington 53001 1931 21
1095604 1095604 2021-03-06 Adams Wisconsin 55001 1752 15
1089451 1089451 2021-03-05 Adams Colorado 8001 49858 631
1089764 1089764 2021-03-05 Adams Idaho 16003 330 4
1089807 1089807 2021-03-05 Adams Illinois 17001 8041 143
1089910 1089910 2021-03-05 Adams Indiana 18001 3277 50
1090003 1090003 2021-03-05 Adams Iowa 19003 317 4
1090621 1090621 2021-03-05 Adams Mississippi 28001 2353 78
1090876 1090876 2021-03-05 Adams Nebraska 31001 2722 38
1091210 1091210 2021-03-05 Adams North Dakota 38001 266 3
1091266 1091266 2021-03-05 Adams Ohio 39001 2181 39
1091469 1091469 2021-03-05 Adams Pennsylvania 42001 7378 152
1092264 1092264 2021-03-05 Adams Washington 53001 1931 21
1092358 1092358 2021-03-05 Adams Wisconsin 55001 1750 15
1086206 1086206 2021-03-04 Adams Colorado 8001 49759 631
1086519 1086519 2021-03-04 Adams Idaho 16003 330 4
1086562 1086562 2021-03-04 Adams Illinois 17001 8036 143
1086665 1086665 2021-03-04 Adams Indiana 18001 3248 50
1086758 1086758 2021-03-04 Adams Iowa 19003 317 4
1087376 1087376 2021-03-04 Adams Mississippi 28001 2350 78
1087631 1087631 2021-03-04 Adams Nebraska 31001 2720 38
1087965 1087965 2021-03-04 Adams North Dakota 38001 266 3
1088021 1088021 2021-03-04 Adams Ohio 39001 2174 36
1088223 1088223 2021-03-04 Adams Pennsylvania 42001 7357 152
1089018 1089018 2021-03-04 Adams Washington 53001 1929 21
1089112 1089112 2021-03-04 Adams Wisconsin 55001 1750 15
1082960 1082960 2021-03-03 Adams Colorado 8001 49615 630
1083273 1083273 2021-03-03 Adams Idaho 16003 330 4
1083316 1083316 2021-03-03 Adams Illinois 17001 8033 143
1083419 1083419 2021-03-03 Adams Indiana 18001 3240 50
1083512 1083512 2021-03-03 Adams Iowa 19003 317 4
1084131 1084131 2021-03-03 Adams Mississippi 28001 2346 78
1084386 1084386 2021-03-03 Adams Nebraska 31001 2716 38
1084720 1084720 2021-03-03 Adams North Dakota 38001 266 3
1084776 1084776 2021-03-03 Adams Ohio 39001 2170 36
1084978 1084978 2021-03-03 Adams Pennsylvania 42001 7332 151
1085773 1085773 2021-03-03 Adams Washington 53001 1926 21
1085867 1085867 2021-03-03 Adams Wisconsin 55001 1746 15
1079714 1079714 2021-03-02 Adams Colorado 8001 49497 628
1080027 1080027 2021-03-02 Adams Idaho 16003 330 4
1080070 1080070 2021-03-02 Adams Illinois 17001 8016 143
1080173 1080173 2021-03-02 Adams Indiana 18001 3236 50
1080266 1080266 2021-03-02 Adams Iowa 19003 317 4
1080885 1080885 2021-03-02 Adams Mississippi 28001 2346 78
1081140 1081140 2021-03-02 Adams Nebraska 31001 2714 38
1081474 1081474 2021-03-02 Adams North Dakota 38001 266 3
1081530 1081530 2021-03-02 Adams Ohio 39001 2163 36
1081732 1081732 2021-03-02 Adams Pennsylvania 42001 7298 151
1082527 1082527 2021-03-02 Adams Washington 53001 1924 21
1082621 1082621 2021-03-02 Adams Wisconsin 55001 1744 15
1076469 1076469 2021-03-01 Adams Colorado 8001 49444 628
1076782 1076782 2021-03-01 Adams Idaho 16003 330 3
1076825 1076825 2021-03-01 Adams Illinois 17001 8009 143
1076928 1076928 2021-03-01 Adams Indiana 18001 3236 50
1077021 1077021 2021-03-01 Adams Iowa 19003 317 4
1077639 1077639 2021-03-01 Adams Mississippi 28001 2343 77
1077894 1077894 2021-03-01 Adams Nebraska 31001 2711 38
1078228 1078228 2021-03-01 Adams North Dakota 38001 266 3
1078284 1078284 2021-03-01 Adams Ohio 39001 2160 32
1078486 1078486 2021-03-01 Adams Pennsylvania 42001 7284 150
1079281 1079281 2021-03-01 Adams Washington 53001 1921 21
1079375 1079375 2021-03-01 Adams Wisconsin 55001 1743 15
1073223 1073223 2021-02-28 Adams Colorado 8001 49369 628
1073536 1073536 2021-02-28 Adams Idaho 16003 330 3
1073579 1073579 2021-02-28 Adams Illinois 17001 8003 143
1073682 1073682 2021-02-28 Adams Indiana 18001 3232 50
1073775 1073775 2021-02-28 Adams Iowa 19003 317 4
1074393 1074393 2021-02-28 Adams Mississippi 28001 2342 77
1074648 1074648 2021-02-28 Adams Nebraska 31001 2711 38
1074983 1074983 2021-02-28 Adams North Dakota 38001 266 3
1075039 1075039 2021-02-28 Adams Ohio 39001 2155 32
1075241 1075241 2021-02-28 Adams Pennsylvania 42001 7273 150
1076036 1076036 2021-02-28 Adams Washington 53001 1912 21
1076130 1076130 2021-02-28 Adams Wisconsin 55001 1739 15
1069977 1069977 2021-02-27 Adams Colorado 8001 49264 628
1070290 1070290 2021-02-27 Adams Idaho 16003 330 3
1070333 1070333 2021-02-27 Adams Illinois 17001 8009 143
1070436 1070436 2021-02-27 Adams Indiana 18001 3226 50

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);