ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,335 rows where county = "Burke" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Georgia 748
- North Carolina 747
- North Dakota 740
county 1
- Burke · 2,235 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394037 | 2394037 | 2022-04-10 | Burke | North Carolina | 37023 | 25061 | 316 |
2394132 | 2394132 | 2022-04-10 | Burke | North Dakota | 38013 | 432 | 3 |
2389266 | 2389266 | 2022-04-09 | Burke | Georgia | 13033 | 5292 | 106 |
2390781 | 2390781 | 2022-04-09 | Burke | North Carolina | 37023 | 25061 | 316 |
2390876 | 2390876 | 2022-04-09 | Burke | North Dakota | 38013 | 432 | 3 |
2386011 | 2386011 | 2022-04-08 | Burke | Georgia | 13033 | 5292 | 106 |
2387525 | 2387525 | 2022-04-08 | Burke | North Carolina | 37023 | 25061 | 316 |
2387620 | 2387620 | 2022-04-08 | Burke | North Dakota | 38013 | 432 | 3 |
2382756 | 2382756 | 2022-04-07 | Burke | Georgia | 13033 | 5292 | 106 |
2384270 | 2384270 | 2022-04-07 | Burke | North Carolina | 37023 | 25061 | 316 |
2384365 | 2384365 | 2022-04-07 | Burke | North Dakota | 38013 | 432 | 3 |
2379501 | 2379501 | 2022-04-06 | Burke | Georgia | 13033 | 5292 | 106 |
2381015 | 2381015 | 2022-04-06 | Burke | North Carolina | 37023 | 25061 | 316 |
2381110 | 2381110 | 2022-04-06 | Burke | North Dakota | 38013 | 432 | 3 |
2376247 | 2376247 | 2022-04-05 | Burke | Georgia | 13033 | 5292 | 106 |
2377760 | 2377760 | 2022-04-05 | Burke | North Carolina | 37023 | 25061 | 316 |
2377855 | 2377855 | 2022-04-05 | Burke | North Dakota | 38013 | 432 | 3 |
2372995 | 2372995 | 2022-04-04 | Burke | Georgia | 13033 | 5292 | 106 |
2374507 | 2374507 | 2022-04-04 | Burke | North Carolina | 37023 | 25054 | 316 |
2374602 | 2374602 | 2022-04-04 | Burke | North Dakota | 38013 | 432 | 3 |
2369742 | 2369742 | 2022-04-03 | Burke | Georgia | 13033 | 5292 | 106 |
2371255 | 2371255 | 2022-04-03 | Burke | North Carolina | 37023 | 25052 | 316 |
2371350 | 2371350 | 2022-04-03 | Burke | North Dakota | 38013 | 432 | 3 |
2366489 | 2366489 | 2022-04-02 | Burke | Georgia | 13033 | 5292 | 106 |
2368002 | 2368002 | 2022-04-02 | Burke | North Carolina | 37023 | 25052 | 316 |
2368097 | 2368097 | 2022-04-02 | Burke | North Dakota | 38013 | 432 | 3 |
2363236 | 2363236 | 2022-04-01 | Burke | Georgia | 13033 | 5292 | 106 |
2364749 | 2364749 | 2022-04-01 | Burke | North Carolina | 37023 | 25052 | 316 |
2364844 | 2364844 | 2022-04-01 | Burke | North Dakota | 38013 | 432 | 3 |
2359982 | 2359982 | 2022-03-31 | Burke | Georgia | 13033 | 5291 | 105 |
2361495 | 2361495 | 2022-03-31 | Burke | North Carolina | 37023 | 25044 | 316 |
2361590 | 2361590 | 2022-03-31 | Burke | North Dakota | 38013 | 432 | 3 |
2356728 | 2356728 | 2022-03-30 | Burke | Georgia | 13033 | 5292 | 105 |
2358241 | 2358241 | 2022-03-30 | Burke | North Carolina | 37023 | 25039 | 316 |
2358336 | 2358336 | 2022-03-30 | Burke | North Dakota | 38013 | 432 | 3 |
2353475 | 2353475 | 2022-03-29 | Burke | Georgia | 13033 | 5292 | 105 |
2354987 | 2354987 | 2022-03-29 | Burke | North Carolina | 37023 | 25031 | 316 |
2355082 | 2355082 | 2022-03-29 | Burke | North Dakota | 38013 | 432 | 3 |
2350223 | 2350223 | 2022-03-28 | Burke | Georgia | 13033 | 5292 | 104 |
2351734 | 2351734 | 2022-03-28 | Burke | North Carolina | 37023 | 25041 | 316 |
2351829 | 2351829 | 2022-03-28 | Burke | North Dakota | 38013 | 432 | 3 |
2346970 | 2346970 | 2022-03-27 | Burke | Georgia | 13033 | 5289 | 104 |
2348482 | 2348482 | 2022-03-27 | Burke | North Carolina | 37023 | 24991 | 315 |
2348577 | 2348577 | 2022-03-27 | Burke | North Dakota | 38013 | 432 | 3 |
2343717 | 2343717 | 2022-03-26 | Burke | Georgia | 13033 | 5289 | 104 |
2345229 | 2345229 | 2022-03-26 | Burke | North Carolina | 37023 | 24991 | 315 |
2345324 | 2345324 | 2022-03-26 | Burke | North Dakota | 38013 | 432 | 3 |
2340464 | 2340464 | 2022-03-25 | Burke | Georgia | 13033 | 5289 | 104 |
2341976 | 2341976 | 2022-03-25 | Burke | North Carolina | 37023 | 24991 | 315 |
2342071 | 2342071 | 2022-03-25 | Burke | North Dakota | 38013 | 432 | 3 |
2337211 | 2337211 | 2022-03-24 | Burke | Georgia | 13033 | 5289 | 104 |
2338723 | 2338723 | 2022-03-24 | Burke | North Carolina | 37023 | 24995 | 314 |
2338818 | 2338818 | 2022-03-24 | Burke | North Dakota | 38013 | 432 | 3 |
2333957 | 2333957 | 2022-03-23 | Burke | Georgia | 13033 | 5289 | 104 |
2335469 | 2335469 | 2022-03-23 | Burke | North Carolina | 37023 | 24993 | 314 |
2335564 | 2335564 | 2022-03-23 | Burke | North Dakota | 38013 | 432 | 3 |
2330703 | 2330703 | 2022-03-22 | Burke | Georgia | 13033 | 5289 | 104 |
2332215 | 2332215 | 2022-03-22 | Burke | North Carolina | 37023 | 24982 | 311 |
2332310 | 2332310 | 2022-03-22 | Burke | North Dakota | 38013 | 432 | 3 |
2327451 | 2327451 | 2022-03-21 | Burke | Georgia | 13033 | 5289 | 104 |
2328962 | 2328962 | 2022-03-21 | Burke | North Carolina | 37023 | 24982 | 311 |
2329057 | 2329057 | 2022-03-21 | Burke | North Dakota | 38013 | 432 | 3 |
2324198 | 2324198 | 2022-03-20 | Burke | Georgia | 13033 | 5289 | 104 |
2325710 | 2325710 | 2022-03-20 | Burke | North Carolina | 37023 | 24961 | 308 |
2325805 | 2325805 | 2022-03-20 | Burke | North Dakota | 38013 | 432 | 3 |
2320944 | 2320944 | 2022-03-19 | Burke | Georgia | 13033 | 5289 | 104 |
2322457 | 2322457 | 2022-03-19 | Burke | North Carolina | 37023 | 24961 | 308 |
2322552 | 2322552 | 2022-03-19 | Burke | North Dakota | 38013 | 432 | 3 |
2317690 | 2317690 | 2022-03-18 | Burke | Georgia | 13033 | 5289 | 104 |
2319203 | 2319203 | 2022-03-18 | Burke | North Carolina | 37023 | 24961 | 308 |
2319298 | 2319298 | 2022-03-18 | Burke | North Dakota | 38013 | 432 | 3 |
2314437 | 2314437 | 2022-03-17 | Burke | Georgia | 13033 | 5287 | 104 |
2315949 | 2315949 | 2022-03-17 | Burke | North Carolina | 37023 | 24943 | 307 |
2316044 | 2316044 | 2022-03-17 | Burke | North Dakota | 38013 | 432 | 3 |
2311184 | 2311184 | 2022-03-16 | Burke | Georgia | 13033 | 5283 | 104 |
2312696 | 2312696 | 2022-03-16 | Burke | North Carolina | 37023 | 24945 | 307 |
2312791 | 2312791 | 2022-03-16 | Burke | North Dakota | 38013 | 432 | 3 |
2307931 | 2307931 | 2022-03-15 | Burke | Georgia | 13033 | 5283 | 104 |
2309443 | 2309443 | 2022-03-15 | Burke | North Carolina | 37023 | 24936 | 307 |
2309538 | 2309538 | 2022-03-15 | Burke | North Dakota | 38013 | 432 | 3 |
2304680 | 2304680 | 2022-03-14 | Burke | Georgia | 13033 | 5282 | 104 |
2306190 | 2306190 | 2022-03-14 | Burke | North Carolina | 37023 | 24915 | 308 |
2306285 | 2306285 | 2022-03-14 | Burke | North Dakota | 38013 | 432 | 3 |
2301428 | 2301428 | 2022-03-13 | Burke | Georgia | 13033 | 5280 | 104 |
2302939 | 2302939 | 2022-03-13 | Burke | North Carolina | 37023 | 24828 | 302 |
2303034 | 2303034 | 2022-03-13 | Burke | North Dakota | 38013 | 432 | 3 |
2298176 | 2298176 | 2022-03-12 | Burke | Georgia | 13033 | 5280 | 104 |
2299687 | 2299687 | 2022-03-12 | Burke | North Carolina | 37023 | 24828 | 302 |
2299782 | 2299782 | 2022-03-12 | Burke | North Dakota | 38013 | 432 | 3 |
2294924 | 2294924 | 2022-03-11 | Burke | Georgia | 13033 | 5280 | 104 |
2296435 | 2296435 | 2022-03-11 | Burke | North Carolina | 37023 | 24828 | 302 |
2296530 | 2296530 | 2022-03-11 | Burke | North Dakota | 38013 | 432 | 3 |
2291672 | 2291672 | 2022-03-10 | Burke | Georgia | 13033 | 5279 | 104 |
2293183 | 2293183 | 2022-03-10 | Burke | North Carolina | 37023 | 24783 | 302 |
2293278 | 2293278 | 2022-03-10 | Burke | North Dakota | 38013 | 431 | 3 |
2288420 | 2288420 | 2022-03-09 | Burke | Georgia | 13033 | 5279 | 104 |
2289931 | 2289931 | 2022-03-09 | Burke | North Carolina | 37023 | 24714 | 302 |
2290026 | 2290026 | 2022-03-09 | Burke | North Dakota | 38013 | 430 | 3 |
2285169 | 2285169 | 2022-03-08 | Burke | Georgia | 13033 | 5279 | 103 |
2286679 | 2286679 | 2022-03-08 | Burke | North Carolina | 37023 | 24678 | 302 |
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);