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

768 rows where county = "Greene" and fips = 28041 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 28041 · 768 ✖

county 1

  • Greene · 768 ✖
Link rowid date ▲ county state fips cases deaths
2501013 2501013 2022-05-13 Greene Mississippi 28041 3198 59
2497755 2497755 2022-05-12 Greene Mississippi 28041 3198 59
2494497 2494497 2022-05-11 Greene Mississippi 28041 3198 59
2491239 2491239 2022-05-10 Greene Mississippi 28041 3198 59
2487982 2487982 2022-05-09 Greene Mississippi 28041 3198 59
2484724 2484724 2022-05-08 Greene Mississippi 28041 3193 59
2481466 2481466 2022-05-07 Greene Mississippi 28041 3193 59
2478208 2478208 2022-05-06 Greene Mississippi 28041 3193 59
2474950 2474950 2022-05-05 Greene Mississippi 28041 3193 59
2471693 2471693 2022-05-04 Greene Mississippi 28041 3193 59
2468437 2468437 2022-05-03 Greene Mississippi 28041 3193 59
2465182 2465182 2022-05-02 Greene Mississippi 28041 3193 59
2461926 2461926 2022-05-01 Greene Mississippi 28041 3192 59
2458670 2458670 2022-04-30 Greene Mississippi 28041 3192 59
2455414 2455414 2022-04-29 Greene Mississippi 28041 3192 59
2452158 2452158 2022-04-28 Greene Mississippi 28041 3192 59
2448902 2448902 2022-04-27 Greene Mississippi 28041 3192 59
2445646 2445646 2022-04-26 Greene Mississippi 28041 3192 59
2442390 2442390 2022-04-25 Greene Mississippi 28041 3189 59
2439134 2439134 2022-04-24 Greene Mississippi 28041 3189 59
2435878 2435878 2022-04-23 Greene Mississippi 28041 3189 59
2432622 2432622 2022-04-22 Greene Mississippi 28041 3189 59
2429366 2429366 2022-04-21 Greene Mississippi 28041 3189 59
2426110 2426110 2022-04-20 Greene Mississippi 28041 3189 59
2422854 2422854 2022-04-19 Greene Mississippi 28041 3189 59
2419598 2419598 2022-04-18 Greene Mississippi 28041 3189 59
2416342 2416342 2022-04-17 Greene Mississippi 28041 3187 59
2413086 2413086 2022-04-16 Greene Mississippi 28041 3187 59
2409830 2409830 2022-04-15 Greene Mississippi 28041 3187 59
2406574 2406574 2022-04-14 Greene Mississippi 28041 3187 59
2403318 2403318 2022-04-13 Greene Mississippi 28041 3187 59
2400064 2400064 2022-04-12 Greene Mississippi 28041 3187 59
2396808 2396808 2022-04-11 Greene Mississippi 28041 3187 59
2393553 2393553 2022-04-10 Greene Mississippi 28041 3187 59
2390297 2390297 2022-04-09 Greene Mississippi 28041 3187 59
2387041 2387041 2022-04-08 Greene Mississippi 28041 3187 59
2383786 2383786 2022-04-07 Greene Mississippi 28041 3187 59
2380531 2380531 2022-04-06 Greene Mississippi 28041 3187 59
2377276 2377276 2022-04-05 Greene Mississippi 28041 3187 59
2374024 2374024 2022-04-04 Greene Mississippi 28041 3187 59
2370771 2370771 2022-04-03 Greene Mississippi 28041 3184 59
2367518 2367518 2022-04-02 Greene Mississippi 28041 3184 59
2364265 2364265 2022-04-01 Greene Mississippi 28041 3184 59
2361011 2361011 2022-03-31 Greene Mississippi 28041 3184 59
2357757 2357757 2022-03-30 Greene Mississippi 28041 3184 59
2354504 2354504 2022-03-29 Greene Mississippi 28041 3184 59
2351252 2351252 2022-03-28 Greene Mississippi 28041 3184 59
2347999 2347999 2022-03-27 Greene Mississippi 28041 3184 59
2344746 2344746 2022-03-26 Greene Mississippi 28041 3184 59
2341493 2341493 2022-03-25 Greene Mississippi 28041 3184 59
2338240 2338240 2022-03-24 Greene Mississippi 28041 3184 59
2334986 2334986 2022-03-23 Greene Mississippi 28041 3184 59
2331732 2331732 2022-03-22 Greene Mississippi 28041 3184 59
2328480 2328480 2022-03-21 Greene Mississippi 28041 3184 59
2325227 2325227 2022-03-20 Greene Mississippi 28041 3183 57
2321973 2321973 2022-03-19 Greene Mississippi 28041 3183 57
2318719 2318719 2022-03-18 Greene Mississippi 28041 3183 57
2315466 2315466 2022-03-17 Greene Mississippi 28041 3183 57
2312213 2312213 2022-03-16 Greene Mississippi 28041 3183 57
2308960 2308960 2022-03-15 Greene Mississippi 28041 3183 57
2305709 2305709 2022-03-14 Greene Mississippi 28041 3183 57
2302457 2302457 2022-03-13 Greene Mississippi 28041 3179 56
2299205 2299205 2022-03-12 Greene Mississippi 28041 3179 56
2295953 2295953 2022-03-11 Greene Mississippi 28041 3179 56
2292701 2292701 2022-03-10 Greene Mississippi 28041 3179 56
2289449 2289449 2022-03-09 Greene Mississippi 28041 3179 56
2286198 2286198 2022-03-08 Greene Mississippi 28041 3179 56
2282946 2282946 2022-03-07 Greene Mississippi 28041 3179 56
2279693 2279693 2022-03-06 Greene Mississippi 28041 3178 56
2276440 2276440 2022-03-05 Greene Mississippi 28041 3178 56
2273187 2273187 2022-03-04 Greene Mississippi 28041 3178 56
2269935 2269935 2022-03-03 Greene Mississippi 28041 3177 56
2266682 2266682 2022-03-02 Greene Mississippi 28041 3176 56
2263431 2263431 2022-03-01 Greene Mississippi 28041 3175 56
2260180 2260180 2022-02-28 Greene Mississippi 28041 3175 56
2256929 2256929 2022-02-27 Greene Mississippi 28041 3170 56
2253678 2253678 2022-02-26 Greene Mississippi 28041 3170 56
2250427 2250427 2022-02-25 Greene Mississippi 28041 3170 56
2247176 2247176 2022-02-24 Greene Mississippi 28041 3170 56
2243925 2243925 2022-02-23 Greene Mississippi 28041 3166 56
2240674 2240674 2022-02-22 Greene Mississippi 28041 3164 55
2237423 2237423 2022-02-21 Greene Mississippi 28041 3160 55
2234172 2234172 2022-02-20 Greene Mississippi 28041 3160 55
2230921 2230921 2022-02-19 Greene Mississippi 28041 3160 55
2227670 2227670 2022-02-18 Greene Mississippi 28041 3160 55
2224419 2224419 2022-02-17 Greene Mississippi 28041 3156 54
2221168 2221168 2022-02-16 Greene Mississippi 28041 3152 54
2217917 2217917 2022-02-15 Greene Mississippi 28041 3150 53
2214666 2214666 2022-02-14 Greene Mississippi 28041 3147 53
2211414 2211414 2022-02-13 Greene Mississippi 28041 3131 53
2208161 2208161 2022-02-12 Greene Mississippi 28041 3131 53
2204908 2204908 2022-02-11 Greene Mississippi 28041 3131 53
2201655 2201655 2022-02-10 Greene Mississippi 28041 3119 53
2198401 2198401 2022-02-09 Greene Mississippi 28041 3109 53
2195147 2195147 2022-02-08 Greene Mississippi 28041 3097 51
2191893 2191893 2022-02-07 Greene Mississippi 28041 3089 51
2188640 2188640 2022-02-06 Greene Mississippi 28041 2977 51
2185387 2185387 2022-02-05 Greene Mississippi 28041 2977 51
2182135 2182135 2022-02-04 Greene Mississippi 28041 2977 51
2178883 2178883 2022-02-03 Greene Mississippi 28041 2961 51

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