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

792 rows where county = "Copiah" and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 792 ✖

fips 1

county 1

  • Copiah · 792 ✖
Link rowid date ▲ county state fips cases deaths
2501007 2501007 2022-05-13 Copiah Mississippi 28029 7287 121
2497749 2497749 2022-05-12 Copiah Mississippi 28029 7287 121
2494491 2494491 2022-05-11 Copiah Mississippi 28029 7287 121
2491233 2491233 2022-05-10 Copiah Mississippi 28029 7287 121
2487976 2487976 2022-05-09 Copiah Mississippi 28029 7287 121
2484718 2484718 2022-05-08 Copiah Mississippi 28029 7253 121
2481460 2481460 2022-05-07 Copiah Mississippi 28029 7253 121
2478202 2478202 2022-05-06 Copiah Mississippi 28029 7253 121
2474944 2474944 2022-05-05 Copiah Mississippi 28029 7253 121
2471687 2471687 2022-05-04 Copiah Mississippi 28029 7253 121
2468431 2468431 2022-05-03 Copiah Mississippi 28029 7253 121
2465176 2465176 2022-05-02 Copiah Mississippi 28029 7253 121
2461920 2461920 2022-05-01 Copiah Mississippi 28029 7216 121
2458664 2458664 2022-04-30 Copiah Mississippi 28029 7216 121
2455408 2455408 2022-04-29 Copiah Mississippi 28029 7216 121
2452152 2452152 2022-04-28 Copiah Mississippi 28029 7216 121
2448896 2448896 2022-04-27 Copiah Mississippi 28029 7216 121
2445640 2445640 2022-04-26 Copiah Mississippi 28029 7216 121
2442384 2442384 2022-04-25 Copiah Mississippi 28029 7185 121
2439128 2439128 2022-04-24 Copiah Mississippi 28029 7185 121
2435872 2435872 2022-04-23 Copiah Mississippi 28029 7185 121
2432616 2432616 2022-04-22 Copiah Mississippi 28029 7185 121
2429360 2429360 2022-04-21 Copiah Mississippi 28029 7185 121
2426104 2426104 2022-04-20 Copiah Mississippi 28029 7185 121
2422848 2422848 2022-04-19 Copiah Mississippi 28029 7185 121
2419592 2419592 2022-04-18 Copiah Mississippi 28029 7185 121
2416336 2416336 2022-04-17 Copiah Mississippi 28029 7140 120
2413080 2413080 2022-04-16 Copiah Mississippi 28029 7140 120
2409824 2409824 2022-04-15 Copiah Mississippi 28029 7140 120
2406568 2406568 2022-04-14 Copiah Mississippi 28029 7140 120
2403312 2403312 2022-04-13 Copiah Mississippi 28029 7140 120
2400058 2400058 2022-04-12 Copiah Mississippi 28029 7140 120
2396802 2396802 2022-04-11 Copiah Mississippi 28029 7130 120
2393547 2393547 2022-04-10 Copiah Mississippi 28029 7130 120
2390291 2390291 2022-04-09 Copiah Mississippi 28029 7130 120
2387035 2387035 2022-04-08 Copiah Mississippi 28029 7130 120
2383780 2383780 2022-04-07 Copiah Mississippi 28029 7130 120
2380525 2380525 2022-04-06 Copiah Mississippi 28029 7130 120
2377270 2377270 2022-04-05 Copiah Mississippi 28029 7130 120
2374018 2374018 2022-04-04 Copiah Mississippi 28029 7130 120
2370765 2370765 2022-04-03 Copiah Mississippi 28029 7113 120
2367512 2367512 2022-04-02 Copiah Mississippi 28029 7113 120
2364259 2364259 2022-04-01 Copiah Mississippi 28029 7113 120
2361005 2361005 2022-03-31 Copiah Mississippi 28029 7113 120
2357751 2357751 2022-03-30 Copiah Mississippi 28029 7113 120
2354498 2354498 2022-03-29 Copiah Mississippi 28029 7113 120
2351246 2351246 2022-03-28 Copiah Mississippi 28029 7113 120
2347993 2347993 2022-03-27 Copiah Mississippi 28029 7110 118
2344740 2344740 2022-03-26 Copiah Mississippi 28029 7110 118
2341487 2341487 2022-03-25 Copiah Mississippi 28029 7110 118
2338234 2338234 2022-03-24 Copiah Mississippi 28029 7110 118
2334980 2334980 2022-03-23 Copiah Mississippi 28029 7110 118
2331726 2331726 2022-03-22 Copiah Mississippi 28029 7110 118
2328474 2328474 2022-03-21 Copiah Mississippi 28029 7110 118
2325221 2325221 2022-03-20 Copiah Mississippi 28029 7107 117
2321967 2321967 2022-03-19 Copiah Mississippi 28029 7107 117
2318713 2318713 2022-03-18 Copiah Mississippi 28029 7107 117
2315460 2315460 2022-03-17 Copiah Mississippi 28029 7107 117
2312207 2312207 2022-03-16 Copiah Mississippi 28029 7107 117
2308954 2308954 2022-03-15 Copiah Mississippi 28029 7107 117
2305703 2305703 2022-03-14 Copiah Mississippi 28029 7107 117
2302451 2302451 2022-03-13 Copiah Mississippi 28029 7102 114
2299199 2299199 2022-03-12 Copiah Mississippi 28029 7102 114
2295947 2295947 2022-03-11 Copiah Mississippi 28029 7102 114
2292695 2292695 2022-03-10 Copiah Mississippi 28029 7102 114
2289443 2289443 2022-03-09 Copiah Mississippi 28029 7102 114
2286192 2286192 2022-03-08 Copiah Mississippi 28029 7102 114
2282940 2282940 2022-03-07 Copiah Mississippi 28029 7101 114
2279687 2279687 2022-03-06 Copiah Mississippi 28029 7098 114
2276434 2276434 2022-03-05 Copiah Mississippi 28029 7098 114
2273181 2273181 2022-03-04 Copiah Mississippi 28029 7098 114
2269929 2269929 2022-03-03 Copiah Mississippi 28029 7098 113
2266676 2266676 2022-03-02 Copiah Mississippi 28029 7097 113
2263425 2263425 2022-03-01 Copiah Mississippi 28029 7091 112
2260174 2260174 2022-02-28 Copiah Mississippi 28029 7088 111
2256923 2256923 2022-02-27 Copiah Mississippi 28029 7085 111
2253672 2253672 2022-02-26 Copiah Mississippi 28029 7085 111
2250421 2250421 2022-02-25 Copiah Mississippi 28029 7085 111
2247170 2247170 2022-02-24 Copiah Mississippi 28029 7080 111
2243919 2243919 2022-02-23 Copiah Mississippi 28029 7077 111
2240668 2240668 2022-02-22 Copiah Mississippi 28029 7071 109
2237417 2237417 2022-02-21 Copiah Mississippi 28029 7057 109
2234166 2234166 2022-02-20 Copiah Mississippi 28029 7057 109
2230915 2230915 2022-02-19 Copiah Mississippi 28029 7057 109
2227664 2227664 2022-02-18 Copiah Mississippi 28029 7057 109
2224413 2224413 2022-02-17 Copiah Mississippi 28029 7049 109
2221162 2221162 2022-02-16 Copiah Mississippi 28029 7046 109
2217911 2217911 2022-02-15 Copiah Mississippi 28029 7040 108
2214660 2214660 2022-02-14 Copiah Mississippi 28029 7028 106
2211408 2211408 2022-02-13 Copiah Mississippi 28029 7006 104
2208155 2208155 2022-02-12 Copiah Mississippi 28029 7006 104
2204902 2204902 2022-02-11 Copiah Mississippi 28029 7006 104
2201649 2201649 2022-02-10 Copiah Mississippi 28029 6988 103
2198395 2198395 2022-02-09 Copiah Mississippi 28029 6977 103
2195141 2195141 2022-02-08 Copiah Mississippi 28029 6955 101
2191887 2191887 2022-02-07 Copiah Mississippi 28029 6927 101
2188634 2188634 2022-02-06 Copiah Mississippi 28029 6618 101
2185381 2185381 2022-02-05 Copiah Mississippi 28029 6618 101
2182129 2182129 2022-02-04 Copiah Mississippi 28029 6618 101
2178877 2178877 2022-02-03 Copiah Mississippi 28029 6531 101

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