participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,043 rows where station_code = "US002A" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5134654 | 5134654 | 20240916110637_Ns7Du | US002A | 2024-09-19T12:18:01.153Z | 2024-09-19T12:18:01.153Z |
5130343 | 5130343 | 20240917112954_EYTrl | US002A | 2024-09-19T12:13:03.926Z | 2024-09-19T12:13:03.926Z |
5130322 | 5130322 | 20240917111835_Tx43J | US002A | 2024-09-19T12:12:59.853Z | 2024-09-19T12:12:59.853Z |
5130320 | 5130320 | 20240917111519_ImW62 | US002A | 2024-09-19T12:12:59.417Z | 2024-09-19T12:12:59.417Z |
5130284 | 5130284 | 20240917110331_oQF0K | US002A | 2024-09-19T12:12:55.893Z | 2024-09-19T12:12:55.893Z |
5130268 | 5130268 | 20240917105349_ggY3x | US002A | 2024-09-19T12:12:53.966Z | 2024-09-19T12:12:53.966Z |
5130234 | 5130234 | 20240917103443_EnaZb | US002A | 2024-09-19T12:12:48.686Z | 2024-09-19T12:12:48.686Z |
5130154 | 5130154 | 20240917094444_q4FqJ | US002A | 2024-09-19T12:12:41.060Z | 2024-09-19T12:12:41.060Z |
5130144 | 5130144 | 20240917093322_ixPC8 | US002A | 2024-09-19T12:12:39.836Z | 2024-09-19T12:12:39.836Z |
5123761 | 5123761 | 20240914112405_vo2lX | US002A | 2024-09-18T12:11:56.616Z | 2024-09-19T12:20:14.697Z |
5123707 | 5123707 | 20240914111224_TAfVs | US002A | 2024-09-18T12:11:54.628Z | 2024-09-19T12:20:14.079Z |
5123657 | 5123657 | 20240914105912_1U3QL | US002A | 2024-09-18T12:11:53.197Z | 2024-09-19T12:20:13.503Z |
5123627 | 5123627 | 20240914105044_iydSa | US002A | 2024-09-18T12:11:52.700Z | 2024-09-19T12:20:13.381Z |
5123566 | 5123566 | 20240914103530_dKr4a | US002A | 2024-09-18T12:11:51.415Z | 2024-09-19T12:20:12.650Z |
5123543 | 5123543 | 20240914102747_Z5Pjo | US002A | 2024-09-18T12:11:51.197Z | 2024-09-19T12:20:12.516Z |
5123410 | 5123410 | 20240914100016_NL7x1 | US002A | 2024-09-18T12:11:48.100Z | 2024-09-19T12:20:10.769Z |
5122866 | 5122866 | 20240914081304_GNAlU | US002A | 2024-09-18T12:11:32.870Z | 2024-09-19T12:20:06.530Z |
5122826 | 5122826 | 20240914080506_L4lUE | US002A | 2024-09-18T12:11:31.976Z | 2024-09-19T12:20:06.374Z |
5122778 | 5122778 | 20240914075729_BUXKW | US002A | 2024-09-18T12:11:30.916Z | 2024-09-19T12:20:06.113Z |
5122755 | 5122755 | 20240914075207_d5OVz | US002A | 2024-09-18T12:11:30.363Z | 2024-09-19T12:20:06.017Z |
5122696 | 5122696 | 20240914073249_qk2vp | US002A | 2024-09-18T12:11:28.601Z | 2024-09-19T12:20:05.763Z |
5122674 | 5122674 | 20240914073036_qvAjM | US002A | 2024-09-18T12:11:28.001Z | 2024-09-19T12:20:05.638Z |
5122581 | 5122581 | 20240914071527_QcA5Z | US002A | 2024-09-18T12:11:24.174Z | 2024-09-19T12:20:05.169Z |
5122505 | 5122505 | 20240914065407_Rax8d | US002A | 2024-09-18T12:11:21.075Z | 2024-09-19T12:20:04.642Z |
5122481 | 5122481 | 20240914063938_kejQ2 | US002A | 2024-09-18T12:11:20.512Z | 2024-09-19T12:20:04.506Z |
5122163 | 5122163 | 20240914044252_YnexH | US002A | 2024-09-18T12:11:07.909Z | 2024-09-19T12:20:02.883Z |
5118891 | 5118891 | 20240915112750_2eG0j | US002A | 2024-09-18T12:09:11.620Z | 2024-09-19T12:19:27.035Z |
5118883 | 5118883 | 20240915112638_hDFj1 | US002A | 2024-09-18T12:09:11.304Z | 2024-09-19T12:19:27.016Z |
5118855 | 5118855 | 20240915112031_NZ8vE | US002A | 2024-09-18T12:09:08.996Z | 2024-09-19T12:19:26.650Z |
5118752 | 5118752 | 20240915110134_IX4ga | US002A | 2024-09-18T12:09:01.405Z | 2024-09-19T12:19:25.287Z |
5118661 | 5118661 | 20240915104137_avZCy | US002A | 2024-09-18T12:08:57.127Z | 2024-09-19T12:19:24.813Z |
5118609 | 5118609 | 20240915102935_vRWQr | US002A | 2024-09-18T12:08:53.033Z | 2024-09-19T12:19:24.301Z |
5118607 | 5118607 | 20240915102725_PSE23 | US002A | 2024-09-18T12:08:52.921Z | 2024-09-19T12:19:24.256Z |
5118492 | 5118492 | 20240915100015_cZgxA | US002A | 2024-09-18T12:08:47.970Z | 2024-09-19T12:19:23.360Z |
5118449 | 5118449 | 20240915094859_eIDiE | US002A | 2024-09-18T12:08:44.793Z | 2024-09-19T12:19:23.024Z |
5118439 | 5118439 | 20240915094724_QF88R | US002A | 2024-09-18T12:08:44.242Z | 2024-09-19T12:19:22.942Z |
5118349 | 5118349 | 20240915092652_zubsK | US002A | 2024-09-18T12:08:38.845Z | 2024-09-19T12:19:22.212Z |
5118340 | 5118340 | 20240915092532_ElD3o | US002A | 2024-09-18T12:08:38.099Z | 2024-09-19T12:19:22.160Z |
5118320 | 5118320 | 20240915091927_qRlAw | US002A | 2024-09-18T12:08:37.485Z | 2024-09-19T12:19:22.053Z |
5118271 | 5118271 | 20240915090313_DsGFj | US002A | 2024-09-18T12:08:34.730Z | 2024-09-19T12:19:21.703Z |
5118191 | 5118191 | 20240915084841_JW4ai | US002A | 2024-09-18T12:08:29.283Z | 2024-09-19T12:19:21.163Z |
5118127 | 5118127 | 20240915083747_jjoPK | US002A | 2024-09-18T12:08:25.902Z | 2024-09-19T12:19:20.662Z |
5082806 | 5082806 | 20240911110217_k25yH | US002A | 2024-09-15T12:18:25.961Z | 2024-09-19T12:21:48.689Z |
5082720 | 5082720 | 20240911104934_yyeea | US002A | 2024-09-15T12:18:23.896Z | 2024-09-19T12:21:48.473Z |
5082618 | 5082618 | 20240911103553_EmUof | US002A | 2024-09-15T12:18:21.042Z | 2024-09-19T12:21:48.184Z |
5079625 | 5079625 | 20240911030636_VUCFm | US002A | 2024-09-15T12:16:31.676Z | 2024-09-19T12:21:42.520Z |
5068276 | 5068276 | 20240910111640_BsQas | US002A | 2024-09-14T12:19:11.631Z | 2024-09-18T12:15:25.855Z |
5068042 | 5068042 | 20240910104614_1NKgM | US002A | 2024-09-14T12:19:07.579Z | 2024-09-18T12:15:25.429Z |
5068035 | 5068035 | 20240910104520_SJCfN | US002A | 2024-09-14T12:19:07.404Z | 2024-09-18T12:15:25.413Z |
5067971 | 5067971 | 20240910103808_JLEWQ | US002A | 2024-09-14T12:19:05.973Z | 2024-09-18T12:15:25.299Z |
5067846 | 5067846 | 20240910101915_hCXLH | US002A | 2024-09-14T12:19:00.172Z | 2024-09-18T12:15:24.960Z |
5067693 | 5067693 | 20240910100134_3oMzM | US002A | 2024-09-14T12:18:54.269Z | 2024-09-18T12:15:24.698Z |
5067540 | 5067540 | 20240910094303_zBtql | US002A | 2024-09-14T12:18:47.898Z | 2024-09-18T12:15:24.333Z |
5066965 | 5066965 | 20240910083518_5c93e | US002A | 2024-09-14T12:18:23.499Z | 2024-09-18T12:15:23.059Z |
5066880 | 5066880 | 20240910082805_dMvcj | US002A | 2024-09-14T12:18:17.886Z | 2024-09-18T12:15:22.920Z |
5066761 | 5066761 | 20240910081340_XTUyY | US002A | 2024-09-14T12:18:11.073Z | 2024-09-18T12:15:22.719Z |
5066698 | 5066698 | 20240910080446_UJz4Z | US002A | 2024-09-14T12:18:08.066Z | 2024-09-18T12:15:22.516Z |
5066612 | 5066612 | 20240910075515_8CDeG | US002A | 2024-09-14T12:18:04.624Z | 2024-09-18T12:15:22.302Z |
5066505 | 5066505 | 20240910074121_GWMnY | US002A | 2024-09-14T12:17:59.507Z | 2024-09-18T12:15:22.082Z |
5056834 | 5056834 | 20240908112949_8AZGK | US002A | 2024-09-13T12:17:39.890Z | 2024-09-16T12:21:27.469Z |
5056579 | 5056579 | 20240908104551_5NeFf | US002A | 2024-09-13T12:17:35.557Z | 2024-09-16T12:21:25.960Z |
5056462 | 5056462 | 20240908103256_Wsnuk | US002A | 2024-09-13T12:17:32.581Z | 2024-09-16T12:21:25.487Z |
5056443 | 5056443 | 20240908103054_gyzgE | US002A | 2024-09-13T12:17:32.241Z | 2024-09-16T12:21:25.424Z |
5056217 | 5056217 | 20240908095610_n7O27 | US002A | 2024-09-13T12:17:28.523Z | 2024-09-16T12:21:23.870Z |
5056103 | 5056103 | 20240908094157_V4236 | US002A | 2024-09-13T12:17:27.490Z | 2024-09-16T12:21:23.300Z |
5055933 | 5055933 | 20240908092100_t8woq | US002A | 2024-09-13T12:17:25.752Z | 2024-09-16T12:21:22.617Z |
5055726 | 5055726 | 20240908084953_nIwh9 | US002A | 2024-09-13T12:17:20.994Z | 2024-09-16T12:21:21.716Z |
5055489 | 5055489 | 20240908081120_muK20 | US002A | 2024-09-13T12:17:15.255Z | 2024-09-16T12:21:19.996Z |
5055407 | 5055407 | 20240908080022_0omMk | US002A | 2024-09-13T12:17:11.767Z | 2024-09-16T12:21:19.314Z |
5055370 | 5055370 | 20240908075443_Bjzvy | US002A | 2024-09-13T12:17:10.880Z | 2024-09-16T12:21:18.993Z |
5055338 | 5055338 | 20240908075215_6Y00U | US002A | 2024-09-13T12:17:10.094Z | 2024-09-16T12:21:18.855Z |
5055309 | 5055309 | 20240908074529_weBjQ | US002A | 2024-09-13T12:17:09.398Z | 2024-09-16T12:21:18.678Z |
5055251 | 5055251 | 20240908073416_OH21k | US002A | 2024-09-13T12:17:08.418Z | 2024-09-16T12:21:18.546Z |
5055069 | 5055069 | 20240908062743_QixbZ | US002A | 2024-09-13T12:17:04.857Z | 2024-09-16T12:21:17.861Z |
5055015 | 5055015 | 20240908060241_KMDYX | US002A | 2024-09-13T12:17:02.378Z | 2024-09-16T12:21:17.696Z |
5054953 | 5054953 | 20240908054031_Bd2d6 | US002A | 2024-09-13T12:17:00.130Z | 2024-09-16T12:21:17.387Z |
5054943 | 5054943 | 20240908053241_9Rh2T | US002A | 2024-09-13T12:16:59.980Z | 2024-09-16T12:21:17.359Z |
5054862 | 5054862 | 20240908043242_kr4n4 | US002A | 2024-09-13T12:16:57.254Z | 2024-09-16T12:21:17.026Z |
5049451 | 5049451 | 20240909105734_WyuCX | US002A | 2024-09-13T12:12:12.540Z | 2024-09-17T12:19:10.458Z |
5049160 | 5049160 | 20240909101825_UwhZE | US002A | 2024-09-13T12:11:40.680Z | 2024-09-17T12:19:09.399Z |
5047794 | 5047794 | 20240909055730_KB72L | US002A | 2024-09-13T12:09:42.634Z | 2024-09-17T12:19:04.324Z |
5047783 | 5047783 | 20240909055509_HkPUE | US002A | 2024-09-13T12:09:41.529Z | 2024-09-17T12:19:04.278Z |
5047768 | 5047768 | 20240909055032_84vC4 | US002A | 2024-09-13T12:09:39.746Z | 2024-09-17T12:19:04.251Z |
5047730 | 5047730 | 20240909053916_gA7Bq | US002A | 2024-09-13T12:09:36.796Z | 2024-09-17T12:19:04.138Z |
5047485 | 5047485 | 20240909042513_W6Drj | US002A | 2024-09-13T12:09:14.174Z | 2024-09-17T12:19:02.883Z |
5042361 | 5042361 | 20240906104326_xuPKZ | US002A | 2024-09-12T12:17:01.515Z | 2024-09-14T12:23:17.121Z |
5042123 | 5042123 | 20240906095926_I3kjW | US002A | 2024-09-12T12:16:55.966Z | 2024-09-14T12:23:16.131Z |
5041952 | 5041952 | 20240906093057_jFTZi | US002A | 2024-09-12T12:16:53.166Z | 2024-09-14T12:23:15.425Z |
5041942 | 5041942 | 20240906092936_4j3Nx | US002A | 2024-09-12T12:16:52.860Z | 2024-09-14T12:23:15.403Z |
5041915 | 5041915 | 20240906092222_ZfgfG | US002A | 2024-09-12T12:16:52.436Z | 2024-09-14T12:23:15.366Z |
5041604 | 5041604 | 20240906083836_y0fuB | US002A | 2024-09-12T12:16:45.113Z | 2024-09-14T12:23:14.070Z |
5041495 | 5041495 | 20240906082443_XfMe3 | US002A | 2024-09-12T12:16:43.066Z | 2024-09-14T12:23:13.753Z |
5041083 | 5041083 | 20240906071508_3iqt4 | US002A | 2024-09-12T12:16:33.396Z | 2024-09-14T12:23:11.735Z |
5040943 | 5040943 | 20240906063526_24pKo | US002A | 2024-09-12T12:16:29.024Z | 2024-09-14T12:23:11.060Z |
5040762 | 5040762 | 20240906054118_ebKpx | US002A | 2024-09-12T12:16:23.677Z | 2024-09-14T12:23:10.555Z |
5040591 | 5040591 | 20240906045947_nMQwa | US002A | 2024-09-12T12:16:17.162Z | 2024-09-14T12:23:10.015Z |
5040509 | 5040509 | 20240906043216_2C862 | US002A | 2024-09-12T12:16:13.881Z | 2024-09-14T12:23:09.569Z |
5040422 | 5040422 | 20240906040737_BzVU1 | US002A | 2024-09-12T12:16:10.824Z | 2024-09-14T12:23:09.125Z |
5039918 | 5039918 | 20240906022635_VvWCv | US002A | 2024-09-12T12:15:50.907Z | 2024-09-14T12:23:05.831Z |
5035577 | 5035577 | 20240907095150_q0SiM | US002A | 2024-09-12T12:12:13.839Z | 2024-09-15T12:21:40.004Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);