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

6,900 rows where county = "Putnam" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 9

fips 9

county 1

  • Putnam · 6,900 ✖
Link rowid date ▲ county state fips cases deaths
2499951 2499951 2022-05-13 Putnam Florida 12107 17669 424
2500082 2500082 2022-05-13 Putnam Georgia 13237 4528 106
2500254 2500254 2022-05-13 Putnam Illinois 17155 1158 10
2500346 2500346 2022-05-13 Putnam Indiana 18133 9427 129
2501163 2501163 2022-05-13 Putnam Missouri 29171 1013 24
2501465 2501465 2022-05-13 Putnam New York 36079 24875 125
2501712 2501712 2022-05-13 Putnam Ohio 39137 8492 157
2502181 2502181 2022-05-13 Putnam Tennessee 47141 25178 304
2502722 2502722 2022-05-13 Putnam West Virginia 54079 16889 178
2496693 2496693 2022-05-12 Putnam Florida 12107 17669 424
2496824 2496824 2022-05-12 Putnam Georgia 13237 4528 106
2496996 2496996 2022-05-12 Putnam Illinois 17155 1158 10
2497088 2497088 2022-05-12 Putnam Indiana 18133 9414 129
2497905 2497905 2022-05-12 Putnam Missouri 29171 1013 24
2498207 2498207 2022-05-12 Putnam New York 36079 24875 125
2498454 2498454 2022-05-12 Putnam Ohio 39137 8492 157
2498923 2498923 2022-05-12 Putnam Tennessee 47141 25178 304
2499464 2499464 2022-05-12 Putnam West Virginia 54079 16875 178
2493435 2493435 2022-05-11 Putnam Florida 12107 17669 424
2493566 2493566 2022-05-11 Putnam Georgia 13237 4528 106
2493738 2493738 2022-05-11 Putnam Illinois 17155 1156 10
2493830 2493830 2022-05-11 Putnam Indiana 18133 9414 129
2494647 2494647 2022-05-11 Putnam Missouri 29171 1013 24
2494949 2494949 2022-05-11 Putnam New York 36079 24801 125
2495196 2495196 2022-05-11 Putnam Ohio 39137 8477 157
2495665 2495665 2022-05-11 Putnam Tennessee 47141 25178 304
2496206 2496206 2022-05-11 Putnam West Virginia 54079 16866 178
2490177 2490177 2022-05-10 Putnam Florida 12107 17669 424
2490308 2490308 2022-05-10 Putnam Georgia 13237 4509 106
2490480 2490480 2022-05-10 Putnam Illinois 17155 1156 10
2490572 2490572 2022-05-10 Putnam Indiana 18133 9397 129
2491389 2491389 2022-05-10 Putnam Missouri 29171 1013 24
2491691 2491691 2022-05-10 Putnam New York 36079 24746 125
2491938 2491938 2022-05-10 Putnam Ohio 39137 8477 157
2492407 2492407 2022-05-10 Putnam Tennessee 47141 25161 304
2492948 2492948 2022-05-10 Putnam West Virginia 54079 16850 178
2486920 2486920 2022-05-09 Putnam Florida 12107 17669 424
2487051 2487051 2022-05-09 Putnam Georgia 13237 4509 106
2487223 2487223 2022-05-09 Putnam Illinois 17155 1155 10
2487315 2487315 2022-05-09 Putnam Indiana 18133 9397 129
2488131 2488131 2022-05-09 Putnam Missouri 29171 1013 24
2488433 2488433 2022-05-09 Putnam New York 36079 24725 125
2488680 2488680 2022-05-09 Putnam Ohio 39137 8477 157
2489149 2489149 2022-05-09 Putnam Tennessee 47141 25161 304
2489690 2489690 2022-05-09 Putnam West Virginia 54079 16850 178
2483662 2483662 2022-05-08 Putnam Florida 12107 17669 424
2483793 2483793 2022-05-08 Putnam Georgia 13237 4509 106
2483965 2483965 2022-05-08 Putnam Illinois 17155 1154 10
2484057 2484057 2022-05-08 Putnam Indiana 18133 9381 129
2484874 2484874 2022-05-08 Putnam Missouri 29171 1013 24
2485176 2485176 2022-05-08 Putnam New York 36079 24685 124
2485423 2485423 2022-05-08 Putnam Ohio 39137 8477 157
2485892 2485892 2022-05-08 Putnam Tennessee 47141 25161 304
2486433 2486433 2022-05-08 Putnam West Virginia 54079 16827 178
2480404 2480404 2022-05-07 Putnam Florida 12107 17669 424
2480535 2480535 2022-05-07 Putnam Georgia 13237 4509 106
2480707 2480707 2022-05-07 Putnam Illinois 17155 1154 10
2480799 2480799 2022-05-07 Putnam Indiana 18133 9381 129
2481616 2481616 2022-05-07 Putnam Missouri 29171 1013 24
2481918 2481918 2022-05-07 Putnam New York 36079 24650 124
2482165 2482165 2022-05-07 Putnam Ohio 39137 8477 157
2482634 2482634 2022-05-07 Putnam Tennessee 47141 25161 304
2483175 2483175 2022-05-07 Putnam West Virginia 54079 16827 178
2477146 2477146 2022-05-06 Putnam Florida 12107 17669 424
2477277 2477277 2022-05-06 Putnam Georgia 13237 4509 106
2477449 2477449 2022-05-06 Putnam Illinois 17155 1154 10
2477541 2477541 2022-05-06 Putnam Indiana 18133 9381 129
2478358 2478358 2022-05-06 Putnam Missouri 29171 1013 24
2478660 2478660 2022-05-06 Putnam New York 36079 24592 124
2478907 2478907 2022-05-06 Putnam Ohio 39137 8477 157
2479376 2479376 2022-05-06 Putnam Tennessee 47141 25161 304
2479917 2479917 2022-05-06 Putnam West Virginia 54079 16827 178
2473888 2473888 2022-05-05 Putnam Florida 12107 17602 424
2474019 2474019 2022-05-05 Putnam Georgia 13237 4509 106
2474191 2474191 2022-05-05 Putnam Illinois 17155 1153 10
2474283 2474283 2022-05-05 Putnam Indiana 18133 9381 129
2475100 2475100 2022-05-05 Putnam Missouri 29171 1009 24
2475402 2475402 2022-05-05 Putnam New York 36079 24546 123
2475649 2475649 2022-05-05 Putnam Ohio 39137 8477 157
2476118 2476118 2022-05-05 Putnam Tennessee 47141 25161 304
2476659 2476659 2022-05-05 Putnam West Virginia 54079 16819 178
2470631 2470631 2022-05-04 Putnam Florida 12107 17602 424
2470762 2470762 2022-05-04 Putnam Georgia 13237 4509 106
2470934 2470934 2022-05-04 Putnam Illinois 17155 1153 10
2471026 2471026 2022-05-04 Putnam Indiana 18133 9381 129
2471843 2471843 2022-05-04 Putnam Missouri 29171 995 23
2472145 2472145 2022-05-04 Putnam New York 36079 24485 122
2472392 2472392 2022-05-04 Putnam Ohio 39137 8465 156
2472861 2472861 2022-05-04 Putnam Tennessee 47141 25161 304
2473401 2473401 2022-05-04 Putnam West Virginia 54079 16801 178
2467375 2467375 2022-05-03 Putnam Florida 12107 17602 424
2467506 2467506 2022-05-03 Putnam Georgia 13237 4501 106
2467678 2467678 2022-05-03 Putnam Illinois 17155 1153 10
2467770 2467770 2022-05-03 Putnam Indiana 18133 9370 129
2468587 2468587 2022-05-03 Putnam Missouri 29171 995 23
2468889 2468889 2022-05-03 Putnam New York 36079 24433 122
2469136 2469136 2022-05-03 Putnam Ohio 39137 8465 156
2469605 2469605 2022-05-03 Putnam Tennessee 47141 25135 304
2470144 2470144 2022-05-03 Putnam West Virginia 54079 16797 178
2464120 2464120 2022-05-02 Putnam Florida 12107 17602 424

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