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

3,114 rows where county = "Smith" sorted by date descending

✎ View and edit SQL

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

state 4

fips 4

county 1

  • Smith · 3,114 ✖
Link rowid date ▲ county state fips cases deaths
2500564 2500564 2022-05-13 Smith Kansas 20183 645 7
2501057 2501057 2022-05-13 Smith Mississippi 28129 4127 68
2502190 2502190 2022-05-13 Smith Tennessee 47159 6171 85
2502419 2502419 2022-05-13 Smith Texas 48423 45581 968
2497306 2497306 2022-05-12 Smith Kansas 20183 645 7
2497799 2497799 2022-05-12 Smith Mississippi 28129 4127 68
2498932 2498932 2022-05-12 Smith Tennessee 47159 6171 85
2499161 2499161 2022-05-12 Smith Texas 48423 45574 968
2494048 2494048 2022-05-11 Smith Kansas 20183 645 7
2494541 2494541 2022-05-11 Smith Mississippi 28129 4127 68
2495674 2495674 2022-05-11 Smith Tennessee 47159 6171 85
2495903 2495903 2022-05-11 Smith Texas 48423 45571 968
2490790 2490790 2022-05-10 Smith Kansas 20183 645 7
2491283 2491283 2022-05-10 Smith Mississippi 28129 4127 68
2492416 2492416 2022-05-10 Smith Tennessee 47159 6168 85
2492645 2492645 2022-05-10 Smith Texas 48423 45561 968
2487533 2487533 2022-05-09 Smith Kansas 20183 645 7
2488026 2488026 2022-05-09 Smith Mississippi 28129 4127 68
2489158 2489158 2022-05-09 Smith Tennessee 47159 6168 85
2489387 2489387 2022-05-09 Smith Texas 48423 45555 967
2484275 2484275 2022-05-08 Smith Kansas 20183 645 7
2484768 2484768 2022-05-08 Smith Mississippi 28129 4115 68
2485901 2485901 2022-05-08 Smith Tennessee 47159 6168 85
2486129 2486129 2022-05-08 Smith Texas 48423 45545 967
2481017 2481017 2022-05-07 Smith Kansas 20183 645 7
2481510 2481510 2022-05-07 Smith Mississippi 28129 4115 68
2482643 2482643 2022-05-07 Smith Tennessee 47159 6168 85
2482871 2482871 2022-05-07 Smith Texas 48423 45529 967
2477759 2477759 2022-05-06 Smith Kansas 20183 645 7
2478252 2478252 2022-05-06 Smith Mississippi 28129 4115 68
2479385 2479385 2022-05-06 Smith Tennessee 47159 6168 85
2479613 2479613 2022-05-06 Smith Texas 48423 45523 966
2474501 2474501 2022-05-05 Smith Kansas 20183 644 7
2474994 2474994 2022-05-05 Smith Mississippi 28129 4115 68
2476127 2476127 2022-05-05 Smith Tennessee 47159 6168 85
2476355 2476355 2022-05-05 Smith Texas 48423 45520 966
2471244 2471244 2022-05-04 Smith Kansas 20183 644 7
2471737 2471737 2022-05-04 Smith Mississippi 28129 4115 68
2472870 2472870 2022-05-04 Smith Tennessee 47159 6168 85
2473098 2473098 2022-05-04 Smith Texas 48423 45515 966
2467988 2467988 2022-05-03 Smith Kansas 20183 644 7
2468481 2468481 2022-05-03 Smith Mississippi 28129 4115 68
2469614 2469614 2022-05-03 Smith Tennessee 47159 6163 84
2469842 2469842 2022-05-03 Smith Texas 48423 45507 966
2464733 2464733 2022-05-02 Smith Kansas 20183 644 7
2465226 2465226 2022-05-02 Smith Mississippi 28129 4115 68
2466358 2466358 2022-05-02 Smith Tennessee 47159 6163 84
2466586 2466586 2022-05-02 Smith Texas 48423 45505 966
2461477 2461477 2022-05-01 Smith Kansas 20183 644 7
2461970 2461970 2022-05-01 Smith Mississippi 28129 4113 68
2463103 2463103 2022-05-01 Smith Tennessee 47159 6163 84
2463331 2463331 2022-05-01 Smith Texas 48423 45503 966
2458221 2458221 2022-04-30 Smith Kansas 20183 644 7
2458714 2458714 2022-04-30 Smith Mississippi 28129 4113 68
2459847 2459847 2022-04-30 Smith Tennessee 47159 6163 84
2460075 2460075 2022-04-30 Smith Texas 48423 45497 966
2454965 2454965 2022-04-29 Smith Kansas 20183 644 7
2455458 2455458 2022-04-29 Smith Mississippi 28129 4113 68
2456591 2456591 2022-04-29 Smith Tennessee 47159 6163 84
2456819 2456819 2022-04-29 Smith Texas 48423 45494 966
2451709 2451709 2022-04-28 Smith Kansas 20183 644 7
2452202 2452202 2022-04-28 Smith Mississippi 28129 4113 68
2453335 2453335 2022-04-28 Smith Tennessee 47159 6163 84
2453563 2453563 2022-04-28 Smith Texas 48423 45492 965
2448453 2448453 2022-04-27 Smith Kansas 20183 644 7
2448946 2448946 2022-04-27 Smith Mississippi 28129 4113 68
2450079 2450079 2022-04-27 Smith Tennessee 47159 6163 84
2450307 2450307 2022-04-27 Smith Texas 48423 45489 965
2445197 2445197 2022-04-26 Smith Kansas 20183 644 7
2445690 2445690 2022-04-26 Smith Mississippi 28129 4113 68
2446822 2446822 2022-04-26 Smith Tennessee 47159 6163 84
2447050 2447050 2022-04-26 Smith Texas 48423 45486 965
2441941 2441941 2022-04-25 Smith Kansas 20183 644 7
2442434 2442434 2022-04-25 Smith Mississippi 28129 4112 68
2443567 2443567 2022-04-25 Smith Tennessee 47159 6163 84
2443795 2443795 2022-04-25 Smith Texas 48423 45483 964
2438685 2438685 2022-04-24 Smith Kansas 20183 644 7
2439178 2439178 2022-04-24 Smith Mississippi 28129 4112 68
2440311 2440311 2022-04-24 Smith Tennessee 47159 6163 84
2440539 2440539 2022-04-24 Smith Texas 48423 45478 964
2435429 2435429 2022-04-23 Smith Kansas 20183 644 7
2435922 2435922 2022-04-23 Smith Mississippi 28129 4112 68
2437055 2437055 2022-04-23 Smith Tennessee 47159 6163 84
2437283 2437283 2022-04-23 Smith Texas 48423 45472 964
2432173 2432173 2022-04-22 Smith Kansas 20183 644 7
2432666 2432666 2022-04-22 Smith Mississippi 28129 4112 68
2433799 2433799 2022-04-22 Smith Tennessee 47159 6163 84
2434027 2434027 2022-04-22 Smith Texas 48423 45468 964
2428917 2428917 2022-04-21 Smith Kansas 20183 644 7
2429410 2429410 2022-04-21 Smith Mississippi 28129 4112 68
2430543 2430543 2022-04-21 Smith Tennessee 47159 6163 84
2430771 2430771 2022-04-21 Smith Texas 48423 45465 964
2425661 2425661 2022-04-20 Smith Kansas 20183 644 7
2426154 2426154 2022-04-20 Smith Mississippi 28129 4112 68
2427287 2427287 2022-04-20 Smith Tennessee 47159 6163 84
2427515 2427515 2022-04-20 Smith Texas 48423 45460 964
2422405 2422405 2022-04-19 Smith Kansas 20183 644 7
2422898 2422898 2022-04-19 Smith Mississippi 28129 4112 68
2424031 2424031 2022-04-19 Smith Tennessee 47159 6161 84
2424259 2424259 2022-04-19 Smith Texas 48423 45456 964

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