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

774 rows where county = "Martin" and fips = 37117 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

  • 37117 · 774 ✖

county 1

  • Martin · 774 ✖
Link rowid date ▲ county state fips cases deaths
2501543 2501543 2022-05-13 Martin North Carolina 37117 6112 93
2498285 2498285 2022-05-12 Martin North Carolina 37117 6112 93
2495027 2495027 2022-05-11 Martin North Carolina 37117 6112 93
2491769 2491769 2022-05-10 Martin North Carolina 37117 6093 93
2488511 2488511 2022-05-09 Martin North Carolina 37117 6093 93
2485254 2485254 2022-05-08 Martin North Carolina 37117 6093 93
2481996 2481996 2022-05-07 Martin North Carolina 37117 6093 93
2478738 2478738 2022-05-06 Martin North Carolina 37117 6093 93
2475480 2475480 2022-05-05 Martin North Carolina 37117 6093 93
2472223 2472223 2022-05-04 Martin North Carolina 37117 6093 93
2468967 2468967 2022-05-03 Martin North Carolina 37117 6083 89
2465711 2465711 2022-05-02 Martin North Carolina 37117 6083 89
2462456 2462456 2022-05-01 Martin North Carolina 37117 6083 89
2459200 2459200 2022-04-30 Martin North Carolina 37117 6083 89
2455944 2455944 2022-04-29 Martin North Carolina 37117 6083 89
2452688 2452688 2022-04-28 Martin North Carolina 37117 6083 89
2449432 2449432 2022-04-27 Martin North Carolina 37117 6083 89
2446175 2446175 2022-04-26 Martin North Carolina 37117 6073 89
2442920 2442920 2022-04-25 Martin North Carolina 37117 6073 89
2439664 2439664 2022-04-24 Martin North Carolina 37117 6073 89
2436408 2436408 2022-04-23 Martin North Carolina 37117 6073 89
2433152 2433152 2022-04-22 Martin North Carolina 37117 6073 89
2429896 2429896 2022-04-21 Martin North Carolina 37117 6073 89
2426640 2426640 2022-04-20 Martin North Carolina 37117 6073 89
2423384 2423384 2022-04-19 Martin North Carolina 37117 6069 89
2420127 2420127 2022-04-18 Martin North Carolina 37117 6069 89
2416872 2416872 2022-04-17 Martin North Carolina 37117 6069 89
2413616 2413616 2022-04-16 Martin North Carolina 37117 6069 89
2410360 2410360 2022-04-15 Martin North Carolina 37117 6069 89
2407104 2407104 2022-04-14 Martin North Carolina 37117 6069 89
2403848 2403848 2022-04-13 Martin North Carolina 37117 6069 89
2400593 2400593 2022-04-12 Martin North Carolina 37117 6058 89
2397338 2397338 2022-04-11 Martin North Carolina 37117 6058 89
2394083 2394083 2022-04-10 Martin North Carolina 37117 6058 89
2390827 2390827 2022-04-09 Martin North Carolina 37117 6058 89
2387571 2387571 2022-04-08 Martin North Carolina 37117 6058 89
2384316 2384316 2022-04-07 Martin North Carolina 37117 6058 89
2381061 2381061 2022-04-06 Martin North Carolina 37117 6058 89
2377806 2377806 2022-04-05 Martin North Carolina 37117 6051 89
2374553 2374553 2022-04-04 Martin North Carolina 37117 6051 89
2371301 2371301 2022-04-03 Martin North Carolina 37117 6049 89
2368048 2368048 2022-04-02 Martin North Carolina 37117 6049 89
2364795 2364795 2022-04-01 Martin North Carolina 37117 6049 89
2361541 2361541 2022-03-31 Martin North Carolina 37117 6049 89
2358287 2358287 2022-03-30 Martin North Carolina 37117 6047 89
2355033 2355033 2022-03-29 Martin North Carolina 37117 6046 89
2351780 2351780 2022-03-28 Martin North Carolina 37117 6046 89
2348528 2348528 2022-03-27 Martin North Carolina 37117 6045 89
2345275 2345275 2022-03-26 Martin North Carolina 37117 6045 89
2342022 2342022 2022-03-25 Martin North Carolina 37117 6045 89
2338769 2338769 2022-03-24 Martin North Carolina 37117 6046 89
2335515 2335515 2022-03-23 Martin North Carolina 37117 6047 89
2332261 2332261 2022-03-22 Martin North Carolina 37117 6047 89
2329008 2329008 2022-03-21 Martin North Carolina 37117 6046 89
2325756 2325756 2022-03-20 Martin North Carolina 37117 6045 89
2322503 2322503 2022-03-19 Martin North Carolina 37117 6045 89
2319249 2319249 2022-03-18 Martin North Carolina 37117 6045 89
2315995 2315995 2022-03-17 Martin North Carolina 37117 6045 89
2312742 2312742 2022-03-16 Martin North Carolina 37117 6044 89
2309489 2309489 2022-03-15 Martin North Carolina 37117 6043 89
2306236 2306236 2022-03-14 Martin North Carolina 37117 6042 89
2302985 2302985 2022-03-13 Martin North Carolina 37117 6040 89
2299733 2299733 2022-03-12 Martin North Carolina 37117 6040 89
2296481 2296481 2022-03-11 Martin North Carolina 37117 6040 89
2293229 2293229 2022-03-10 Martin North Carolina 37117 6040 89
2289977 2289977 2022-03-09 Martin North Carolina 37117 6038 89
2286725 2286725 2022-03-08 Martin North Carolina 37117 6035 89
2283473 2283473 2022-03-07 Martin North Carolina 37117 6034 89
2280221 2280221 2022-03-06 Martin North Carolina 37117 6028 89
2276968 2276968 2022-03-05 Martin North Carolina 37117 6028 89
2273715 2273715 2022-03-04 Martin North Carolina 37117 6028 89
2270462 2270462 2022-03-03 Martin North Carolina 37117 6028 89
2267210 2267210 2022-03-02 Martin North Carolina 37117 6024 88
2263958 2263958 2022-03-01 Martin North Carolina 37117 6014 87
2260707 2260707 2022-02-28 Martin North Carolina 37117 6011 85
2257456 2257456 2022-02-27 Martin North Carolina 37117 6001 85
2254205 2254205 2022-02-26 Martin North Carolina 37117 6001 85
2250954 2250954 2022-02-25 Martin North Carolina 37117 6001 85
2247703 2247703 2022-02-24 Martin North Carolina 37117 5999 85
2244452 2244452 2022-02-23 Martin North Carolina 37117 5990 85
2241201 2241201 2022-02-22 Martin North Carolina 37117 5984 85
2237950 2237950 2022-02-21 Martin North Carolina 37117 5978 85
2234699 2234699 2022-02-20 Martin North Carolina 37117 5974 85
2231448 2231448 2022-02-19 Martin North Carolina 37117 5974 85
2228197 2228197 2022-02-18 Martin North Carolina 37117 5974 85
2224946 2224946 2022-02-17 Martin North Carolina 37117 5967 85
2221695 2221695 2022-02-16 Martin North Carolina 37117 5963 85
2218444 2218444 2022-02-15 Martin North Carolina 37117 5956 85
2215193 2215193 2022-02-14 Martin North Carolina 37117 5955 83
2211942 2211942 2022-02-13 Martin North Carolina 37117 5928 83
2208689 2208689 2022-02-12 Martin North Carolina 37117 5928 83
2205436 2205436 2022-02-11 Martin North Carolina 37117 5928 83
2202183 2202183 2022-02-10 Martin North Carolina 37117 5920 83
2198929 2198929 2022-02-09 Martin North Carolina 37117 5900 81
2195675 2195675 2022-02-08 Martin North Carolina 37117 5887 81
2192421 2192421 2022-02-07 Martin North Carolina 37117 5880 81
2189167 2189167 2022-02-06 Martin North Carolina 37117 5825 80
2185914 2185914 2022-02-05 Martin North Carolina 37117 5825 80
2182662 2182662 2022-02-04 Martin North Carolina 37117 5825 80
2179410 2179410 2022-02-03 Martin North Carolina 37117 5801 80

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