ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,028 rows where county = "Adams" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state
- Indiana 363
- Colorado 361
- Nebraska 355
- Pennsylvania 355
- Illinois 353
- Mississippi 353
- Washington 350
- Idaho 342
- Wisconsin 340
- Ohio 338
- Iowa 295
- North Dakota 223
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 |
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]);