home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

10,132 rows where county = "Carroll" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 13

  • Iowa 793
  • Maryland 791
  • New Hampshire 789
  • Georgia 785
  • Tennessee 784
  • Ohio 783
  • Indiana 778
  • Illinois 777
  • Kentucky 777
  • Mississippi 776
  • Virginia 774
  • Arkansas 773
  • Missouri 752

fips 13

  • 19027 793
  • 24013 791
  • 33003 789
  • 13045 785
  • 47017 784
  • 39019 783
  • 18015 778
  • 17015 777
  • 21041 777
  • 28015 776
  • 51035 774
  • 5015 773
  • 29033 752

county 1

  • Carroll · 10,132 ✖
Link rowid date ▲ county state fips cases deaths
2499693 2499693 2022-05-13 Carroll Arkansas 5015 6138 102
2499987 2499987 2022-05-13 Carroll Georgia 13045 23863 460
2500184 2500184 2022-05-13 Carroll Illinois 17015 4301 49
2500287 2500287 2022-05-13 Carroll Indiana 18015 4268 68
2500386 2500386 2022-05-13 Carroll Iowa 19027 4958 66
2500599 2500599 2022-05-13 Carroll Kentucky 21041 3504 45
2500787 2500787 2022-05-13 Carroll Maryland 24013 22141 409
2501000 2501000 2022-05-13 Carroll Mississippi 28015 2565 54
2501092 2501092 2022-05-13 Carroll Missouri 29033 2233 44
2501362 2501362 2022-05-13 Carroll New Hampshire 33003 9865 62
2501653 2501653 2022-05-13 Carroll Ohio 39019 5291 126
2502119 2502119 2022-05-13 Carroll Tennessee 47017 8978 156
2502530 2502530 2022-05-13 Carroll Virginia 51035 6747 148
2496435 2496435 2022-05-12 Carroll Arkansas 5015 6133 102
2496729 2496729 2022-05-12 Carroll Georgia 13045 23863 460
2496926 2496926 2022-05-12 Carroll Illinois 17015 4300 49
2497029 2497029 2022-05-12 Carroll Indiana 18015 4265 68
2497128 2497128 2022-05-12 Carroll Iowa 19027 4958 66
2497341 2497341 2022-05-12 Carroll Kentucky 21041 3504 45
2497529 2497529 2022-05-12 Carroll Maryland 24013 22092 409
2497742 2497742 2022-05-12 Carroll Mississippi 28015 2565 54
2497834 2497834 2022-05-12 Carroll Missouri 29033 2225 44
2498104 2498104 2022-05-12 Carroll New Hampshire 33003 9844 62
2498395 2498395 2022-05-12 Carroll Ohio 39019 5291 126
2498861 2498861 2022-05-12 Carroll Tennessee 47017 8978 156
2499272 2499272 2022-05-12 Carroll Virginia 51035 6745 148
2493177 2493177 2022-05-11 Carroll Arkansas 5015 6129 102
2493471 2493471 2022-05-11 Carroll Georgia 13045 23863 460
2493668 2493668 2022-05-11 Carroll Illinois 17015 4300 49
2493771 2493771 2022-05-11 Carroll Indiana 18015 4265 68
2493870 2493870 2022-05-11 Carroll Iowa 19027 4958 66
2494083 2494083 2022-05-11 Carroll Kentucky 21041 3504 45
2494271 2494271 2022-05-11 Carroll Maryland 24013 22048 408
2494484 2494484 2022-05-11 Carroll Mississippi 28015 2565 54
2494576 2494576 2022-05-11 Carroll Missouri 29033 2225 44
2494846 2494846 2022-05-11 Carroll New Hampshire 33003 9815 61
2495137 2495137 2022-05-11 Carroll Ohio 39019 5276 126
2495603 2495603 2022-05-11 Carroll Tennessee 47017 8978 156
2496014 2496014 2022-05-11 Carroll Virginia 51035 6740 148
2489919 2489919 2022-05-10 Carroll Arkansas 5015 6128 102
2490213 2490213 2022-05-10 Carroll Georgia 13045 23824 459
2490410 2490410 2022-05-10 Carroll Illinois 17015 4295 49
2490513 2490513 2022-05-10 Carroll Indiana 18015 4261 68
2490612 2490612 2022-05-10 Carroll Iowa 19027 4950 65
2490825 2490825 2022-05-10 Carroll Kentucky 21041 3504 45
2491013 2491013 2022-05-10 Carroll Maryland 24013 22018 405
2491226 2491226 2022-05-10 Carroll Mississippi 28015 2565 54
2491318 2491318 2022-05-10 Carroll Missouri 29033 2225 44
2491588 2491588 2022-05-10 Carroll New Hampshire 33003 9798 61
2491879 2491879 2022-05-10 Carroll Ohio 39019 5276 126
2492345 2492345 2022-05-10 Carroll Tennessee 47017 8972 156
2492756 2492756 2022-05-10 Carroll Virginia 51035 6730 148
2486662 2486662 2022-05-09 Carroll Arkansas 5015 6127 102
2486956 2486956 2022-05-09 Carroll Georgia 13045 23824 459
2487153 2487153 2022-05-09 Carroll Illinois 17015 4292 49
2487256 2487256 2022-05-09 Carroll Indiana 18015 4261 68
2487355 2487355 2022-05-09 Carroll Iowa 19027 4950 65
2487568 2487568 2022-05-09 Carroll Kentucky 21041 3504 45
2487756 2487756 2022-05-09 Carroll Maryland 24013 21930 405
2487969 2487969 2022-05-09 Carroll Mississippi 28015 2565 54
2488060 2488060 2022-05-09 Carroll Missouri 29033 2225 44
2488330 2488330 2022-05-09 Carroll New Hampshire 33003 9784 61
2488621 2488621 2022-05-09 Carroll Ohio 39019 5276 126
2489087 2489087 2022-05-09 Carroll Tennessee 47017 8972 156
2489498 2489498 2022-05-09 Carroll Virginia 51035 6718 148
2483404 2483404 2022-05-08 Carroll Arkansas 5015 6127 102
2483698 2483698 2022-05-08 Carroll Georgia 13045 23822 459
2483895 2483895 2022-05-08 Carroll Illinois 17015 4287 49
2483998 2483998 2022-05-08 Carroll Indiana 18015 4258 68
2484097 2484097 2022-05-08 Carroll Iowa 19027 4950 65
2484310 2484310 2022-05-08 Carroll Kentucky 21041 3500 45
2484498 2484498 2022-05-08 Carroll Maryland 24013 21887 405
2484711 2484711 2022-05-08 Carroll Mississippi 28015 2563 53
2484803 2484803 2022-05-08 Carroll Missouri 29033 2225 44
2485073 2485073 2022-05-08 Carroll New Hampshire 33003 9719 61
2485364 2485364 2022-05-08 Carroll Ohio 39019 5276 126
2485830 2485830 2022-05-08 Carroll Tennessee 47017 8972 156
2486241 2486241 2022-05-08 Carroll Virginia 51035 6708 148
2480146 2480146 2022-05-07 Carroll Arkansas 5015 6127 102
2480440 2480440 2022-05-07 Carroll Georgia 13045 23822 459
2480637 2480637 2022-05-07 Carroll Illinois 17015 4287 49
2480740 2480740 2022-05-07 Carroll Indiana 18015 4258 68
2480839 2480839 2022-05-07 Carroll Iowa 19027 4950 65
2481052 2481052 2022-05-07 Carroll Kentucky 21041 3500 45
2481240 2481240 2022-05-07 Carroll Maryland 24013 21887 405
2481453 2481453 2022-05-07 Carroll Mississippi 28015 2563 53
2481545 2481545 2022-05-07 Carroll Missouri 29033 2225 44
2481815 2481815 2022-05-07 Carroll New Hampshire 33003 9719 61
2482106 2482106 2022-05-07 Carroll Ohio 39019 5276 126
2482572 2482572 2022-05-07 Carroll Tennessee 47017 8972 156
2482983 2482983 2022-05-07 Carroll Virginia 51035 6708 148
2476888 2476888 2022-05-06 Carroll Arkansas 5015 6127 102
2477182 2477182 2022-05-06 Carroll Georgia 13045 23822 459
2477379 2477379 2022-05-06 Carroll Illinois 17015 4287 49
2477482 2477482 2022-05-06 Carroll Indiana 18015 4258 68
2477581 2477581 2022-05-06 Carroll Iowa 19027 4950 65
2477794 2477794 2022-05-06 Carroll Kentucky 21041 3500 45
2477982 2477982 2022-05-06 Carroll Maryland 24013 21887 405
2478195 2478195 2022-05-06 Carroll Mississippi 28015 2563 53
2478287 2478287 2022-05-06 Carroll Missouri 29033 2225 44

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] desc);
Powered by Datasette · Queries took 468.598ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette