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

775 rows where county = "Torrance" and state = "New Mexico" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • New Mexico · 775 ✖

fips 1

county 1

  • Torrance · 775 ✖
Link rowid date ▲ county state fips cases deaths
2501424 2501424 2022-05-13 Torrance New Mexico 35057 3152 56
2498166 2498166 2022-05-12 Torrance New Mexico 35057 3151 56
2494908 2494908 2022-05-11 Torrance New Mexico 35057 3148 55
2491650 2491650 2022-05-10 Torrance New Mexico 35057 3148 55
2488392 2488392 2022-05-09 Torrance New Mexico 35057 3145 55
2485135 2485135 2022-05-08 Torrance New Mexico 35057 3140 55
2481877 2481877 2022-05-07 Torrance New Mexico 35057 3140 55
2478619 2478619 2022-05-06 Torrance New Mexico 35057 3140 55
2475361 2475361 2022-05-05 Torrance New Mexico 35057 3139 55
2472104 2472104 2022-05-04 Torrance New Mexico 35057 3139 55
2468848 2468848 2022-05-03 Torrance New Mexico 35057 3138 54
2465592 2465592 2022-05-02 Torrance New Mexico 35057 3141 54
2462337 2462337 2022-05-01 Torrance New Mexico 35057 3137 54
2459081 2459081 2022-04-30 Torrance New Mexico 35057 3137 54
2455825 2455825 2022-04-29 Torrance New Mexico 35057 3137 54
2452569 2452569 2022-04-28 Torrance New Mexico 35057 3132 54
2449313 2449313 2022-04-27 Torrance New Mexico 35057 3132 54
2446056 2446056 2022-04-26 Torrance New Mexico 35057 3132 54
2442801 2442801 2022-04-25 Torrance New Mexico 35057 3132 54
2439545 2439545 2022-04-24 Torrance New Mexico 35057 3133 54
2436289 2436289 2022-04-23 Torrance New Mexico 35057 3133 54
2433033 2433033 2022-04-22 Torrance New Mexico 35057 3133 54
2429777 2429777 2022-04-21 Torrance New Mexico 35057 3133 54
2426521 2426521 2022-04-20 Torrance New Mexico 35057 3133 54
2423265 2423265 2022-04-19 Torrance New Mexico 35057 3133 54
2420008 2420008 2022-04-18 Torrance New Mexico 35057 3132 53
2416753 2416753 2022-04-17 Torrance New Mexico 35057 3128 53
2413497 2413497 2022-04-16 Torrance New Mexico 35057 3128 53
2410241 2410241 2022-04-15 Torrance New Mexico 35057 3128 53
2406985 2406985 2022-04-14 Torrance New Mexico 35057 3127 53
2403729 2403729 2022-04-13 Torrance New Mexico 35057 3127 53
2400474 2400474 2022-04-12 Torrance New Mexico 35057 3127 53
2397219 2397219 2022-04-11 Torrance New Mexico 35057 3126 53
2393964 2393964 2022-04-10 Torrance New Mexico 35057 3125 53
2390708 2390708 2022-04-09 Torrance New Mexico 35057 3125 53
2387452 2387452 2022-04-08 Torrance New Mexico 35057 3125 53
2384197 2384197 2022-04-07 Torrance New Mexico 35057 3125 53
2380942 2380942 2022-04-06 Torrance New Mexico 35057 3124 53
2377687 2377687 2022-04-05 Torrance New Mexico 35057 3120 53
2374434 2374434 2022-04-04 Torrance New Mexico 35057 3120 53
2371182 2371182 2022-04-03 Torrance New Mexico 35057 3120 53
2367929 2367929 2022-04-02 Torrance New Mexico 35057 3120 53
2364676 2364676 2022-04-01 Torrance New Mexico 35057 3120 53
2361422 2361422 2022-03-31 Torrance New Mexico 35057 3120 53
2358168 2358168 2022-03-30 Torrance New Mexico 35057 3119 53
2354915 2354915 2022-03-29 Torrance New Mexico 35057 3119 52
2351662 2351662 2022-03-28 Torrance New Mexico 35057 3117 52
2348410 2348410 2022-03-27 Torrance New Mexico 35057 3114 52
2345157 2345157 2022-03-26 Torrance New Mexico 35057 3114 52
2341904 2341904 2022-03-25 Torrance New Mexico 35057 3114 52
2338651 2338651 2022-03-24 Torrance New Mexico 35057 3112 52
2335397 2335397 2022-03-23 Torrance New Mexico 35057 3111 52
2332143 2332143 2022-03-22 Torrance New Mexico 35057 3113 52
2328890 2328890 2022-03-21 Torrance New Mexico 35057 3116 52
2325638 2325638 2022-03-20 Torrance New Mexico 35057 3109 52
2322384 2322384 2022-03-19 Torrance New Mexico 35057 3109 52
2319130 2319130 2022-03-18 Torrance New Mexico 35057 3109 52
2315877 2315877 2022-03-17 Torrance New Mexico 35057 3109 52
2312624 2312624 2022-03-16 Torrance New Mexico 35057 3109 52
2309371 2309371 2022-03-15 Torrance New Mexico 35057 3109 52
2306118 2306118 2022-03-14 Torrance New Mexico 35057 3109 52
2302867 2302867 2022-03-13 Torrance New Mexico 35057 3107 51
2299615 2299615 2022-03-12 Torrance New Mexico 35057 3107 51
2296363 2296363 2022-03-11 Torrance New Mexico 35057 3107 51
2293111 2293111 2022-03-10 Torrance New Mexico 35057 3106 51
2289859 2289859 2022-03-09 Torrance New Mexico 35057 3103 51
2286607 2286607 2022-03-08 Torrance New Mexico 35057 3102 51
2283355 2283355 2022-03-07 Torrance New Mexico 35057 3100 51
2280102 2280102 2022-03-06 Torrance New Mexico 35057 3079 51
2276849 2276849 2022-03-05 Torrance New Mexico 35057 3079 51
2273596 2273596 2022-03-04 Torrance New Mexico 35057 3079 51
2270344 2270344 2022-03-03 Torrance New Mexico 35057 3075 50
2267091 2267091 2022-03-02 Torrance New Mexico 35057 3069 50
2263840 2263840 2022-03-01 Torrance New Mexico 35057 3074 50
2260589 2260589 2022-02-28 Torrance New Mexico 35057 3073 50
2257338 2257338 2022-02-27 Torrance New Mexico 35057 3069 50
2254087 2254087 2022-02-26 Torrance New Mexico 35057 3069 50
2250836 2250836 2022-02-25 Torrance New Mexico 35057 3069 50
2247585 2247585 2022-02-24 Torrance New Mexico 35057 3068 50
2244334 2244334 2022-02-23 Torrance New Mexico 35057 3062 50
2241083 2241083 2022-02-22 Torrance New Mexico 35057 3059 50
2237832 2237832 2022-02-21 Torrance New Mexico 35057 3058 50
2234581 2234581 2022-02-20 Torrance New Mexico 35057 3032 50
2231330 2231330 2022-02-19 Torrance New Mexico 35057 3032 50
2228079 2228079 2022-02-18 Torrance New Mexico 35057 3032 50
2224828 2224828 2022-02-17 Torrance New Mexico 35057 3025 49
2221577 2221577 2022-02-16 Torrance New Mexico 35057 3019 49
2218326 2218326 2022-02-15 Torrance New Mexico 35057 3012 49
2215075 2215075 2022-02-14 Torrance New Mexico 35057 3010 49
2211823 2211823 2022-02-13 Torrance New Mexico 35057 2951 49
2208570 2208570 2022-02-12 Torrance New Mexico 35057 2951 49
2205317 2205317 2022-02-11 Torrance New Mexico 35057 2951 49
2202064 2202064 2022-02-10 Torrance New Mexico 35057 2946 49
2198810 2198810 2022-02-09 Torrance New Mexico 35057 2935 48
2195556 2195556 2022-02-08 Torrance New Mexico 35057 2930 48
2192302 2192302 2022-02-07 Torrance New Mexico 35057 2928 48
2189049 2189049 2022-02-06 Torrance New Mexico 35057 2900 48
2185796 2185796 2022-02-05 Torrance New Mexico 35057 2900 48
2182544 2182544 2022-02-04 Torrance New Mexico 35057 2900 48
2179292 2179292 2022-02-03 Torrance New Mexico 35057 2886 48

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