ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Caldwell" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501499 | 2501499 | 2022-05-13 | Caldwell | North Carolina | 37027 | 22411 | 308 |
2498241 | 2498241 | 2022-05-12 | Caldwell | North Carolina | 37027 | 22411 | 308 |
2494983 | 2494983 | 2022-05-11 | Caldwell | North Carolina | 37027 | 22411 | 308 |
2491725 | 2491725 | 2022-05-10 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2488467 | 2488467 | 2022-05-09 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2485210 | 2485210 | 2022-05-08 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2481952 | 2481952 | 2022-05-07 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2478694 | 2478694 | 2022-05-06 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2475436 | 2475436 | 2022-05-05 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2472179 | 2472179 | 2022-05-04 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2468923 | 2468923 | 2022-05-03 | Caldwell | North Carolina | 37027 | 22292 | 300 |
2465667 | 2465667 | 2022-05-02 | Caldwell | North Carolina | 37027 | 22292 | 300 |
2462412 | 2462412 | 2022-05-01 | Caldwell | North Carolina | 37027 | 22292 | 300 |
2459156 | 2459156 | 2022-04-30 | Caldwell | North Carolina | 37027 | 22292 | 300 |
2455900 | 2455900 | 2022-04-29 | Caldwell | North Carolina | 37027 | 22292 | 300 |
2452644 | 2452644 | 2022-04-28 | Caldwell | North Carolina | 37027 | 22292 | 300 |
2449388 | 2449388 | 2022-04-27 | Caldwell | North Carolina | 37027 | 22292 | 300 |
2446131 | 2446131 | 2022-04-26 | Caldwell | North Carolina | 37027 | 22230 | 300 |
2442876 | 2442876 | 2022-04-25 | Caldwell | North Carolina | 37027 | 22230 | 300 |
2439620 | 2439620 | 2022-04-24 | Caldwell | North Carolina | 37027 | 22230 | 300 |
2436364 | 2436364 | 2022-04-23 | Caldwell | North Carolina | 37027 | 22230 | 300 |
2433108 | 2433108 | 2022-04-22 | Caldwell | North Carolina | 37027 | 22230 | 300 |
2429852 | 2429852 | 2022-04-21 | Caldwell | North Carolina | 37027 | 22230 | 300 |
2426596 | 2426596 | 2022-04-20 | Caldwell | North Carolina | 37027 | 22230 | 300 |
2423340 | 2423340 | 2022-04-19 | Caldwell | North Carolina | 37027 | 22198 | 300 |
2420083 | 2420083 | 2022-04-18 | Caldwell | North Carolina | 37027 | 22198 | 300 |
2416828 | 2416828 | 2022-04-17 | Caldwell | North Carolina | 37027 | 22198 | 300 |
2413572 | 2413572 | 2022-04-16 | Caldwell | North Carolina | 37027 | 22198 | 300 |
2410316 | 2410316 | 2022-04-15 | Caldwell | North Carolina | 37027 | 22198 | 300 |
2407060 | 2407060 | 2022-04-14 | Caldwell | North Carolina | 37027 | 22198 | 300 |
2403804 | 2403804 | 2022-04-13 | Caldwell | North Carolina | 37027 | 22198 | 300 |
2400549 | 2400549 | 2022-04-12 | Caldwell | North Carolina | 37027 | 22190 | 300 |
2397294 | 2397294 | 2022-04-11 | Caldwell | North Carolina | 37027 | 22190 | 300 |
2394039 | 2394039 | 2022-04-10 | Caldwell | North Carolina | 37027 | 22190 | 300 |
2390783 | 2390783 | 2022-04-09 | Caldwell | North Carolina | 37027 | 22190 | 300 |
2387527 | 2387527 | 2022-04-08 | Caldwell | North Carolina | 37027 | 22190 | 300 |
2384272 | 2384272 | 2022-04-07 | Caldwell | North Carolina | 37027 | 22190 | 300 |
2381017 | 2381017 | 2022-04-06 | Caldwell | North Carolina | 37027 | 22190 | 300 |
2377762 | 2377762 | 2022-04-05 | Caldwell | North Carolina | 37027 | 22183 | 299 |
2374509 | 2374509 | 2022-04-04 | Caldwell | North Carolina | 37027 | 22178 | 299 |
2371257 | 2371257 | 2022-04-03 | Caldwell | North Carolina | 37027 | 22165 | 299 |
2368004 | 2368004 | 2022-04-02 | Caldwell | North Carolina | 37027 | 22165 | 299 |
2364751 | 2364751 | 2022-04-01 | Caldwell | North Carolina | 37027 | 22165 | 299 |
2361497 | 2361497 | 2022-03-31 | Caldwell | North Carolina | 37027 | 22164 | 299 |
2358243 | 2358243 | 2022-03-30 | Caldwell | North Carolina | 37027 | 22159 | 299 |
2354989 | 2354989 | 2022-03-29 | Caldwell | North Carolina | 37027 | 22156 | 299 |
2351736 | 2351736 | 2022-03-28 | Caldwell | North Carolina | 37027 | 22154 | 299 |
2348484 | 2348484 | 2022-03-27 | Caldwell | North Carolina | 37027 | 22074 | 298 |
2345231 | 2345231 | 2022-03-26 | Caldwell | North Carolina | 37027 | 22074 | 298 |
2341978 | 2341978 | 2022-03-25 | Caldwell | North Carolina | 37027 | 22074 | 298 |
2338725 | 2338725 | 2022-03-24 | Caldwell | North Carolina | 37027 | 22064 | 298 |
2335471 | 2335471 | 2022-03-23 | Caldwell | North Carolina | 37027 | 22028 | 298 |
2332217 | 2332217 | 2022-03-22 | Caldwell | North Carolina | 37027 | 21995 | 298 |
2328964 | 2328964 | 2022-03-21 | Caldwell | North Carolina | 37027 | 22006 | 297 |
2325712 | 2325712 | 2022-03-20 | Caldwell | North Carolina | 37027 | 22046 | 298 |
2322459 | 2322459 | 2022-03-19 | Caldwell | North Carolina | 37027 | 22046 | 298 |
2319205 | 2319205 | 2022-03-18 | Caldwell | North Carolina | 37027 | 22046 | 298 |
2315951 | 2315951 | 2022-03-17 | Caldwell | North Carolina | 37027 | 22084 | 296 |
2312698 | 2312698 | 2022-03-16 | Caldwell | North Carolina | 37027 | 22102 | 297 |
2309445 | 2309445 | 2022-03-15 | Caldwell | North Carolina | 37027 | 22132 | 296 |
2306192 | 2306192 | 2022-03-14 | Caldwell | North Carolina | 37027 | 22131 | 296 |
2302941 | 2302941 | 2022-03-13 | Caldwell | North Carolina | 37027 | 22063 | 296 |
2299689 | 2299689 | 2022-03-12 | Caldwell | North Carolina | 37027 | 22063 | 296 |
2296437 | 2296437 | 2022-03-11 | Caldwell | North Carolina | 37027 | 22063 | 296 |
2293185 | 2293185 | 2022-03-10 | Caldwell | North Carolina | 37027 | 22020 | 295 |
2289933 | 2289933 | 2022-03-09 | Caldwell | North Carolina | 37027 | 22006 | 295 |
2286681 | 2286681 | 2022-03-08 | Caldwell | North Carolina | 37027 | 22001 | 293 |
2283429 | 2283429 | 2022-03-07 | Caldwell | North Carolina | 37027 | 21988 | 293 |
2280177 | 2280177 | 2022-03-06 | Caldwell | North Carolina | 37027 | 21960 | 292 |
2276924 | 2276924 | 2022-03-05 | Caldwell | North Carolina | 37027 | 21960 | 292 |
2273671 | 2273671 | 2022-03-04 | Caldwell | North Carolina | 37027 | 21960 | 292 |
2270418 | 2270418 | 2022-03-03 | Caldwell | North Carolina | 37027 | 21946 | 292 |
2267166 | 2267166 | 2022-03-02 | Caldwell | North Carolina | 37027 | 21934 | 291 |
2263914 | 2263914 | 2022-03-01 | Caldwell | North Carolina | 37027 | 21897 | 280 |
2260663 | 2260663 | 2022-02-28 | Caldwell | North Carolina | 37027 | 21867 | 280 |
2257412 | 2257412 | 2022-02-27 | Caldwell | North Carolina | 37027 | 21798 | 280 |
2254161 | 2254161 | 2022-02-26 | Caldwell | North Carolina | 37027 | 21798 | 280 |
2250910 | 2250910 | 2022-02-25 | Caldwell | North Carolina | 37027 | 21798 | 280 |
2247659 | 2247659 | 2022-02-24 | Caldwell | North Carolina | 37027 | 21759 | 280 |
2244408 | 2244408 | 2022-02-23 | Caldwell | North Carolina | 37027 | 21697 | 280 |
2241157 | 2241157 | 2022-02-22 | Caldwell | North Carolina | 37027 | 21670 | 280 |
2237906 | 2237906 | 2022-02-21 | Caldwell | North Carolina | 37027 | 21654 | 280 |
2234655 | 2234655 | 2022-02-20 | Caldwell | North Carolina | 37027 | 21573 | 279 |
2231404 | 2231404 | 2022-02-19 | Caldwell | North Carolina | 37027 | 21573 | 279 |
2228153 | 2228153 | 2022-02-18 | Caldwell | North Carolina | 37027 | 21573 | 279 |
2224902 | 2224902 | 2022-02-17 | Caldwell | North Carolina | 37027 | 21533 | 277 |
2221651 | 2221651 | 2022-02-16 | Caldwell | North Carolina | 37027 | 21476 | 267 |
2218400 | 2218400 | 2022-02-15 | Caldwell | North Carolina | 37027 | 21431 | 267 |
2215149 | 2215149 | 2022-02-14 | Caldwell | North Carolina | 37027 | 21391 | 267 |
2211898 | 2211898 | 2022-02-13 | Caldwell | North Carolina | 37027 | 21209 | 264 |
2208645 | 2208645 | 2022-02-12 | Caldwell | North Carolina | 37027 | 21209 | 264 |
2205392 | 2205392 | 2022-02-11 | Caldwell | North Carolina | 37027 | 21209 | 264 |
2202139 | 2202139 | 2022-02-10 | Caldwell | North Carolina | 37027 | 21149 | 264 |
2198885 | 2198885 | 2022-02-09 | Caldwell | North Carolina | 37027 | 21050 | 262 |
2195631 | 2195631 | 2022-02-08 | Caldwell | North Carolina | 37027 | 20977 | 258 |
2192377 | 2192377 | 2022-02-07 | Caldwell | North Carolina | 37027 | 20944 | 258 |
2189123 | 2189123 | 2022-02-06 | Caldwell | North Carolina | 37027 | 20668 | 258 |
2185870 | 2185870 | 2022-02-05 | Caldwell | North Carolina | 37027 | 20668 | 258 |
2182618 | 2182618 | 2022-02-04 | Caldwell | North Carolina | 37027 | 20668 | 258 |
2179366 | 2179366 | 2022-02-03 | Caldwell | North Carolina | 37027 | 20570 | 258 |
Advanced export
JSON shape: default, array, newline-delimited
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);