ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where date = "2020-03-19" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state >30
- New York 37
- Florida 35
- Georgia 34
- California 33
- Texas 33
- Arkansas 26
- Louisiana 25
- Washington 25
- Ohio 24
- Colorado 22
- Indiana 22
- North Carolina 22
- Pennsylvania 22
- Illinois 21
- Mississippi 21
- Wisconsin 21
- Michigan 20
- New Jersey 20
- Virginia 20
- Tennessee 19
- Minnesota 18
- Kentucky 17
- South Carolina 17
- Alabama 15
- Oregon 14
- Iowa 13
- Maryland 13
- Massachusetts 13
- Oklahoma 13
- Kansas 11
- …
fips >30
county >30
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4401 | 4401 | 2020-03-19 | Baldwin | Alabama | 1003 | 1 | 0 |
4402 | 4402 | 2020-03-19 | Calhoun | Alabama | 1015 | 1 | 0 |
4403 | 4403 | 2020-03-19 | Chambers | Alabama | 1017 | 1 | 0 |
4404 | 4404 | 2020-03-19 | Elmore | Alabama | 1051 | 5 | 0 |
4405 | 4405 | 2020-03-19 | Jefferson | Alabama | 1073 | 34 | 0 |
4406 | 4406 | 2020-03-19 | Lee | Alabama | 1081 | 10 | 0 |
4407 | 4407 | 2020-03-19 | Limestone | Alabama | 1083 | 1 | 0 |
4408 | 4408 | 2020-03-19 | Madison | Alabama | 1089 | 5 | 0 |
4409 | 4409 | 2020-03-19 | Mobile | Alabama | 1097 | 1 | 0 |
4410 | 4410 | 2020-03-19 | Montgomery | Alabama | 1101 | 3 | 0 |
4411 | 4411 | 2020-03-19 | Shelby | Alabama | 1117 | 9 | 0 |
4412 | 4412 | 2020-03-19 | St. Clair | Alabama | 1115 | 1 | 0 |
4413 | 4413 | 2020-03-19 | Talladega | Alabama | 1121 | 1 | 0 |
4414 | 4414 | 2020-03-19 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
4415 | 4415 | 2020-03-19 | Walker | Alabama | 1127 | 1 | 0 |
4416 | 4416 | 2020-03-19 | Anchorage | Alaska | 2020 | 4 | 0 |
4417 | 4417 | 2020-03-19 | Fairbanks North Star Borough | Alaska | 2090 | 5 | 0 |
4418 | 4418 | 2020-03-19 | Kenai Peninsula Borough | Alaska | 2122 | 1 | 0 |
4419 | 4419 | 2020-03-19 | Ketchikan Gateway Borough | Alaska | 2130 | 2 | 0 |
4420 | 4420 | 2020-03-19 | Coconino | Arizona | 4005 | 2 | 0 |
4421 | 4421 | 2020-03-19 | Graham | Arizona | 4009 | 1 | 0 |
4422 | 4422 | 2020-03-19 | Maricopa | Arizona | 4013 | 22 | 0 |
4423 | 4423 | 2020-03-19 | Navajo | Arizona | 4017 | 3 | 0 |
4424 | 4424 | 2020-03-19 | Pima | Arizona | 4019 | 7 | 0 |
4425 | 4425 | 2020-03-19 | Pinal | Arizona | 4021 | 10 | 0 |
4426 | 4426 | 2020-03-19 | Santa Cruz | Arizona | 4023 | 1 | 0 |
4427 | 4427 | 2020-03-19 | Yavapai | Arizona | 4025 | 1 | 0 |
4428 | 4428 | 2020-03-19 | Benton | Arkansas | 5007 | 1 | 0 |
4429 | 4429 | 2020-03-19 | Boone | Arkansas | 5009 | 1 | 0 |
4430 | 4430 | 2020-03-19 | Bradley | Arkansas | 5011 | 1 | 0 |
4431 | 4431 | 2020-03-19 | Clark | Arkansas | 5019 | 1 | 0 |
4432 | 4432 | 2020-03-19 | Cleburne | Arkansas | 5023 | 1 | 0 |
4433 | 4433 | 2020-03-19 | Cleveland | Arkansas | 5025 | 1 | 0 |
4434 | 4434 | 2020-03-19 | Craighead | Arkansas | 5031 | 1 | 0 |
4435 | 4435 | 2020-03-19 | Crittenden | Arkansas | 5035 | 1 | 0 |
4436 | 4436 | 2020-03-19 | Desha | Arkansas | 5041 | 1 | 0 |
4437 | 4437 | 2020-03-19 | Faulkner | Arkansas | 5045 | 1 | 0 |
4438 | 4438 | 2020-03-19 | Garland | Arkansas | 5051 | 3 | 0 |
4439 | 4439 | 2020-03-19 | Grant | Arkansas | 5053 | 1 | 0 |
4440 | 4440 | 2020-03-19 | Greene | Arkansas | 5055 | 1 | 0 |
4441 | 4441 | 2020-03-19 | Independence | Arkansas | 5063 | 1 | 0 |
4442 | 4442 | 2020-03-19 | Jefferson | Arkansas | 5069 | 18 | 0 |
4443 | 4443 | 2020-03-19 | Lincoln | Arkansas | 5079 | 1 | 0 |
4444 | 4444 | 2020-03-19 | Poinsett | Arkansas | 5111 | 1 | 0 |
4445 | 4445 | 2020-03-19 | Polk | Arkansas | 5113 | 1 | 0 |
4446 | 4446 | 2020-03-19 | Pope | Arkansas | 5115 | 1 | 0 |
4447 | 4447 | 2020-03-19 | Pulaski | Arkansas | 5119 | 18 | 0 |
4448 | 4448 | 2020-03-19 | Saline | Arkansas | 5125 | 1 | 0 |
4449 | 4449 | 2020-03-19 | Searcy | Arkansas | 5129 | 1 | 0 |
4450 | 4450 | 2020-03-19 | Sebastian | Arkansas | 5131 | 1 | 0 |
4451 | 4451 | 2020-03-19 | Sevier | Arkansas | 5133 | 1 | 0 |
4452 | 4452 | 2020-03-19 | Van Buren | Arkansas | 5141 | 1 | 0 |
4453 | 4453 | 2020-03-19 | Washington | Arkansas | 5143 | 1 | 0 |
4454 | 4454 | 2020-03-19 | Alameda | California | 6001 | 57 | 0 |
4455 | 4455 | 2020-03-19 | Contra Costa | California | 6013 | 42 | 0 |
4456 | 4456 | 2020-03-19 | Fresno | California | 6019 | 4 | 0 |
4457 | 4457 | 2020-03-19 | Humboldt | California | 6023 | 1 | 0 |
4458 | 4458 | 2020-03-19 | Kern | California | 6029 | 2 | 0 |
4459 | 4459 | 2020-03-19 | Los Angeles | California | 6037 | 231 | 2 |
4460 | 4460 | 2020-03-19 | Madera | California | 6039 | 3 | 0 |
4461 | 4461 | 2020-03-19 | Marin | California | 6041 | 25 | 0 |
4462 | 4462 | 2020-03-19 | Mendocino | California | 6045 | 1 | 0 |
4463 | 4463 | 2020-03-19 | Monterey | California | 6053 | 2 | 0 |
4464 | 4464 | 2020-03-19 | Napa | California | 6055 | 1 | 0 |
4465 | 4465 | 2020-03-19 | Nevada | California | 6057 | 1 | 0 |
4466 | 4466 | 2020-03-19 | Orange | California | 6059 | 53 | 0 |
4467 | 4467 | 2020-03-19 | Placer | California | 6061 | 9 | 1 |
4468 | 4468 | 2020-03-19 | Riverside | California | 6065 | 22 | 3 |
4469 | 4469 | 2020-03-19 | Sacramento | California | 6067 | 44 | 3 |
4470 | 4470 | 2020-03-19 | San Benito | California | 6069 | 5 | 1 |
4471 | 4471 | 2020-03-19 | San Bernardino | California | 6071 | 5 | 0 |
4472 | 4472 | 2020-03-19 | San Diego | California | 6073 | 105 | 0 |
4473 | 4473 | 2020-03-19 | San Francisco | California | 6075 | 73 | 0 |
4474 | 4474 | 2020-03-19 | San Joaquin | California | 6077 | 17 | 2 |
4475 | 4475 | 2020-03-19 | San Luis Obispo | California | 6079 | 13 | 0 |
4476 | 4476 | 2020-03-19 | San Mateo | California | 6081 | 89 | 1 |
4477 | 4477 | 2020-03-19 | Santa Barbara | California | 6083 | 8 | 0 |
4478 | 4478 | 2020-03-19 | Santa Clara | California | 6085 | 189 | 6 |
4479 | 4479 | 2020-03-19 | Santa Cruz | California | 6087 | 2 | 0 |
4480 | 4480 | 2020-03-19 | Shasta | California | 6089 | 1 | 0 |
4481 | 4481 | 2020-03-19 | Solano | California | 6095 | 15 | 0 |
4482 | 4482 | 2020-03-19 | Sonoma | California | 6097 | 11 | 0 |
4483 | 4483 | 2020-03-19 | Stanislaus | California | 6099 | 5 | 0 |
4484 | 4484 | 2020-03-19 | Tulare | California | 6107 | 7 | 0 |
4485 | 4485 | 2020-03-19 | Ventura | California | 6111 | 19 | 0 |
4486 | 4486 | 2020-03-19 | Yolo | California | 6113 | 5 | 0 |
4487 | 4487 | 2020-03-19 | Adams | Colorado | 8001 | 10 | 0 |
4488 | 4488 | 2020-03-19 | Arapahoe | Colorado | 8005 | 22 | 0 |
4489 | 4489 | 2020-03-19 | Boulder | Colorado | 8013 | 11 | 0 |
4490 | 4490 | 2020-03-19 | Clear Creek | Colorado | 8019 | 2 | 0 |
4491 | 4491 | 2020-03-19 | Crowley | Colorado | 8025 | 1 | 1 |
4492 | 4492 | 2020-03-19 | Denver | Colorado | 8031 | 61 | 0 |
4493 | 4493 | 2020-03-19 | Douglas | Colorado | 8035 | 14 | 0 |
4494 | 4494 | 2020-03-19 | Eagle | Colorado | 8037 | 51 | 0 |
4495 | 4495 | 2020-03-19 | El Paso | Colorado | 8041 | 15 | 3 |
4496 | 4496 | 2020-03-19 | Garfield | Colorado | 8045 | 3 | 0 |
4497 | 4497 | 2020-03-19 | Grand | Colorado | 8049 | 1 | 0 |
4498 | 4498 | 2020-03-19 | Gunnison | Colorado | 8051 | 13 | 0 |
4499 | 4499 | 2020-03-19 | Jefferson | Colorado | 8059 | 36 | 0 |
4500 | 4500 | 2020-03-19 | Larimer | Colorado | 8069 | 5 | 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);