participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,951 rows where station_code = "DE0006" 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 |
---|---|---|---|---|---|
5485368 | 5485368 | 20241105050837_CCXhH | DE0006 | 2024-11-06T14:18:10.366Z | 2024-11-12T14:27:38.452Z |
5485086 | 5485086 | 20241105040209_DFMAo | DE0006 | 2024-11-06T14:17:44.072Z | 2024-11-12T14:27:36.645Z |
5484771 | 5484771 | 20241105032650_I2e9l | DE0006 | 2024-11-06T14:17:14.756Z | 2024-11-12T14:27:35.430Z |
5484639 | 5484639 | 20241105031549_LfNYm | DE0006 | 2024-11-06T14:17:07.433Z | 2024-11-12T14:27:35.032Z |
5484282 | 5484282 | 20241105023038_1Q32c | DE0006 | 2024-11-06T14:16:44.164Z | 2024-11-12T14:27:33.210Z |
5484168 | 5484168 | 20241105021739_0ss2c | DE0006 | 2024-11-06T14:16:24.817Z | 2024-11-12T14:27:32.485Z |
5484003 | 5484003 | 20241105015426_WxaUV | DE0006 | 2024-11-06T14:16:02.305Z | 2024-11-12T14:27:31.114Z |
5483798 | 5483798 | 20241105013206_7iIAz | DE0006 | 2024-11-06T14:15:43.541Z | 2024-11-12T14:27:30.238Z |
5483056 | 5483056 | 20241104235131_EQnYd | DE0006 | 2024-11-06T14:14:37.035Z | 2024-11-12T14:27:25.475Z |
5482556 | 5482556 | 20241104223951_Qt2hl | DE0006 | 2024-11-06T14:13:21.266Z | 2024-11-12T14:27:22.948Z |
5482348 | 5482348 | 20241104215508_Cni5g | DE0006 | 2024-11-06T14:13:04.225Z | 2024-11-12T14:27:21.958Z |
5482040 | 5482040 | 20241104205617_EpJ9T | DE0006 | 2024-11-06T14:12:17.243Z | 2024-11-12T14:27:18.763Z |
5478721 | 5478721 | 20241104051835_nY2lT | DE0006 | 2024-11-05T14:18:44.690Z | 2024-11-12T14:28:16.768Z |
5478687 | 5478687 | 20241104050743_bueea | DE0006 | 2024-11-05T14:18:41.851Z | 2024-11-12T14:28:16.562Z |
5478673 | 5478673 | 20241104045806_MqiB3 | DE0006 | 2024-11-05T14:18:39.903Z | 2024-11-12T14:28:16.539Z |
5478669 | 5478669 | 20241104045745_yl0gC | DE0006 | 2024-11-05T14:18:39.732Z | 2024-11-12T14:28:16.537Z |
5478667 | 5478667 | 20241104045635_RdFor | DE0006 | 2024-11-05T14:18:39.509Z | 2024-11-12T14:28:16.530Z |
5478660 | 5478660 | 20241104045532_PREvZ | DE0006 | 2024-11-05T14:18:38.629Z | 2024-11-12T14:28:16.479Z |
5478445 | 5478445 | 20241104041327_pNqj0 | DE0006 | 2024-11-05T14:18:23.236Z | 2024-11-12T14:28:15.409Z |
5478427 | 5478427 | 20241104040922_Wd0JL | DE0006 | 2024-11-05T14:18:21.799Z | 2024-11-12T14:28:15.280Z |
5478312 | 5478312 | 20241104035118_l7RA8 | DE0006 | 2024-11-05T14:18:13.131Z | 2024-11-12T14:28:14.917Z |
5478226 | 5478226 | 20241104033919_Jhrha | DE0006 | 2024-11-05T14:18:05.095Z | 2024-11-12T14:28:14.628Z |
5478096 | 5478096 | 20241104032132_4qcrh | DE0006 | 2024-11-05T14:17:55.376Z | 2024-11-12T14:28:14.197Z |
5478069 | 5478069 | 20241104031729_UFZPC | DE0006 | 2024-11-05T14:17:51.281Z | 2024-11-12T14:28:14.138Z |
5478052 | 5478052 | 20241104031500_No5vR | DE0006 | 2024-11-05T14:17:48.073Z | 2024-11-12T14:28:13.961Z |
5477969 | 5477969 | 20241104030220_T8jqM | DE0006 | 2024-11-05T14:17:41.304Z | 2024-11-12T14:28:13.669Z |
5477775 | 5477775 | 20241104023350_RWbze | DE0006 | 2024-11-05T14:17:23.935Z | 2024-11-12T14:28:12.873Z |
5477511 | 5477511 | 20241104020439_RrO28 | DE0006 | 2024-11-05T14:16:59.771Z | 2024-11-12T14:28:11.911Z |
5477410 | 5477410 | 20241104014921_QOLZE | DE0006 | 2024-11-05T14:16:50.607Z | 2024-11-12T14:28:11.257Z |
5477405 | 5477405 | 20241104014856_chlsH | DE0006 | 2024-11-05T14:16:50.511Z | 2024-11-12T14:28:11.240Z |
5477086 | 5477086 | 20241104005919_MzJl8 | DE0006 | 2024-11-05T14:16:21.295Z | 2024-11-12T14:28:08.783Z |
5477009 | 5477009 | 20241104005217_c3wVU | DE0006 | 2024-11-05T14:16:17.177Z | 2024-11-12T14:28:08.068Z |
5476809 | 5476809 | 20241104002724_ii0sO | DE0006 | 2024-11-05T14:16:05.968Z | 2024-11-12T14:28:07.539Z |
5476737 | 5476737 | 20241104001431_zATz4 | DE0006 | 2024-11-05T14:16:01.812Z | 2024-11-12T14:28:07.056Z |
5476348 | 5476348 | 20241103231103_wiXvU | DE0006 | 2024-11-05T14:15:08.166Z | 2024-11-12T14:28:05.833Z |
5476283 | 5476283 | 20241103225835_rh74E | DE0006 | 2024-11-05T14:15:00.055Z | 2024-11-12T14:28:04.853Z |
5475932 | 5475932 | 20241103215552_GxHEb | DE0006 | 2024-11-05T14:14:34.328Z | 2024-11-12T14:28:01.839Z |
5475638 | 5475638 | 20241103205413_kOuuc | DE0006 | 2024-11-05T14:13:55.174Z | 2024-11-12T14:28:00.119Z |
5443193 | 5443193 | 20241030035640_2UTlX | DE0006 | 2024-11-01T12:20:21.420Z | 2024-11-07T14:26:50.021Z |
5443027 | 5443027 | 20241030031603_7nYPv | DE0006 | 2024-11-01T12:20:16.084Z | 2024-11-07T14:26:49.281Z |
5442668 | 5442668 | 20241030021242_x1XQC | DE0006 | 2024-11-01T12:20:04.710Z | 2024-11-07T14:26:47.645Z |
5442239 | 5442239 | 20241030005938_Tp3ai | DE0006 | 2024-11-01T12:19:35.143Z | 2024-11-07T14:26:45.703Z |
5441436 | 5441436 | 20241029221536_VxxTL | DE0006 | 2024-11-01T12:18:34.887Z | 2024-11-07T14:26:42.094Z |
5433752 | 5433752 | 20241027222600_ou85T | DE0006 | 2024-10-31T12:24:19.784Z | 2024-11-05T14:27:11.757Z |
5433576 | 5433576 | 20241029202508_7fVO0 | DE0006 | 2024-10-31T12:22:22.772Z | 2024-11-07T14:26:40.227Z |
5433389 | 5433389 | 20241029193314_v5Eq3 | DE0006 | 2024-10-31T12:22:11.924Z | 2024-11-07T14:26:38.912Z |
5433368 | 5433368 | 20241029192524_RTvKa | DE0006 | 2024-10-31T12:22:10.728Z | 2024-11-07T14:26:38.749Z |
5432837 | 5432837 | 20241029045233_ll2qP | DE0006 | 2024-10-31T12:21:36.399Z | 2024-11-06T14:27:28.905Z |
5432511 | 5432511 | 20241029034524_2GwGY | DE0006 | 2024-10-31T12:21:25.303Z | 2024-11-06T14:27:27.722Z |
5432413 | 5432413 | 20241029032946_c2X2j | DE0006 | 2024-10-31T12:21:21.729Z | 2024-11-06T14:27:26.983Z |
5432117 | 5432117 | 20241029024409_nMrA2 | DE0006 | 2024-10-31T12:21:03.397Z | 2024-11-06T14:27:25.983Z |
5432029 | 5432029 | 20241029023313_OPjG2 | DE0006 | 2024-10-31T12:20:56.996Z | 2024-11-06T14:27:25.709Z |
5431901 | 5431901 | 20241029021415_RJP1z | DE0006 | 2024-10-31T12:20:48.115Z | 2024-11-06T14:27:25.207Z |
5431857 | 5431857 | 20241029020700_pb9hS | DE0006 | 2024-10-31T12:20:44.634Z | 2024-11-06T14:27:25.103Z |
5431852 | 5431852 | 20241029020558_13iDI | DE0006 | 2024-10-31T12:20:44.353Z | 2024-11-06T14:27:25.096Z |
5431738 | 5431738 | 20241029015256_uy0YN | DE0006 | 2024-10-31T12:20:35.482Z | 2024-11-06T14:27:24.645Z |
5431587 | 5431587 | 20241029013553_MJgGA | DE0006 | 2024-10-31T12:20:23.008Z | 2024-11-06T14:27:24.111Z |
5431518 | 5431518 | 20241029012315_2Mt2B | DE0006 | 2024-10-31T12:20:17.765Z | 2024-11-06T14:27:23.979Z |
5419516 | 5419516 | 20241028001311_r5c56 | DE0006 | 2024-10-30T12:17:31.275Z | 2024-11-05T14:27:13.311Z |
5419338 | 5419338 | 20241027233924_bpKWE | DE0006 | 2024-10-30T12:17:21.415Z | 2024-11-05T14:27:12.780Z |
5419019 | 5419019 | 20241027224603_d7vu2 | DE0006 | 2024-10-30T12:16:53.007Z | 2024-11-05T14:27:12.222Z |
5401916 | 5401916 | 20241026180553_SCMLh | DE0006 | 2024-10-29T12:05:49.189Z | 2024-11-04T14:28:40.938Z |
5401901 | 5401901 | 20241026180314_tLaMV | DE0006 | 2024-10-29T12:05:46.878Z | 2024-11-04T14:28:40.853Z |
5398326 | 5398326 | 20241026024424_BaWKf | DE0006 | 2024-10-28T12:19:10.710Z | 2024-11-03T14:27:35.897Z |
5398150 | 5398150 | 20241026023000_l20sf | DE0006 | 2024-10-28T12:19:02.849Z | 2024-11-03T14:27:35.587Z |
5397832 | 5397832 | 20241026020122_2s516 | DE0006 | 2024-10-28T12:18:46.831Z | 2024-11-03T14:27:34.289Z |
5397640 | 5397640 | 20241026014425_XQsSc | DE0006 | 2024-10-28T12:18:30.612Z | 2024-11-03T14:27:33.636Z |
5397097 | 5397097 | 20241026010158_EJhYi | DE0006 | 2024-10-28T12:18:07.719Z | 2024-11-03T14:27:32.023Z |
5394996 | 5394996 | 20241025215819_8ZLeP | DE0006 | 2024-10-28T12:15:52.241Z | 2024-11-03T14:27:23.630Z |
5394025 | 5394025 | 20241025192540_TmpgR | DE0006 | 2024-10-28T12:13:59.380Z | 2024-11-03T14:27:19.623Z |
5389267 | 5389267 | 20241023221236_yZw7h | DE0006 | 2024-10-27T12:24:58.602Z | 2024-11-01T12:26:54.599Z |
5387764 | 5387764 | 20241025031827_YkWkK | DE0006 | 2024-10-27T12:21:38.899Z | 2024-11-02T12:28:33.219Z |
5387485 | 5387485 | 20241025024435_ruKqt | DE0006 | 2024-10-27T12:21:23.857Z | 2024-11-02T12:28:32.630Z |
5386289 | 5386289 | 20241025002230_U31uA | DE0006 | 2024-10-27T12:19:58.815Z | 2024-11-02T12:28:30.935Z |
5386083 | 5386083 | 20241025000208_EP3CT | DE0006 | 2024-10-27T12:19:49.540Z | 2024-11-02T12:28:30.680Z |
5385645 | 5385645 | 20241024231224_CsQJO | DE0006 | 2024-10-27T12:19:12.796Z | 2024-11-02T12:28:30.008Z |
5385235 | 5385235 | 20241024221156_I0spU | DE0006 | 2024-10-27T12:18:36.523Z | 2024-11-02T12:28:29.355Z |
5384988 | 5384988 | 20241024213126_FX9cP | DE0006 | 2024-10-27T12:18:07.439Z | 2024-11-02T12:28:28.862Z |
5384831 | 5384831 | 20241024210150_Nogvd | DE0006 | 2024-10-27T12:17:47.927Z | 2024-11-02T12:28:28.408Z |
5366974 | 5366974 | 20241023045308_mz2Ty | DE0006 | 2024-10-25T12:21:39.634Z | 2024-10-31T12:30:09.733Z |
5366857 | 5366857 | 20241023042832_qnEV2 | DE0006 | 2024-10-25T12:21:33.611Z | 2024-10-31T12:30:09.073Z |
5366748 | 5366748 | 20241023035731_47cgb | DE0006 | 2024-10-25T12:21:28.852Z | 2024-10-31T12:30:08.249Z |
5366741 | 5366741 | 20241023035706_xkmwg | DE0006 | 2024-10-25T12:21:28.707Z | 2024-10-31T12:30:08.111Z |
5366719 | 5366719 | 20241023034857_BnBoy | DE0006 | 2024-10-25T12:21:28.388Z | 2024-10-31T12:30:08.058Z |
5366686 | 5366686 | 20241023033525_AD1qP | DE0006 | 2024-10-25T12:21:25.922Z | 2024-10-31T12:30:07.564Z |
5366683 | 5366683 | 20241023033432_KuB0N | DE0006 | 2024-10-25T12:21:25.838Z | 2024-10-31T12:30:07.557Z |
5366597 | 5366597 | 20241023025425_xZxE4 | DE0006 | 2024-10-25T12:21:18.657Z | 2024-10-31T12:30:06.691Z |
5365665 | 5365665 | 20241023234200_dajeR | DE0006 | 2024-10-25T12:18:04.354Z | 2024-11-01T12:26:56.332Z |
5365590 | 5365590 | 20241023233846_SfyVg | DE0006 | 2024-10-25T12:18:02.140Z | 2024-11-01T12:26:56.265Z |
5365355 | 5365355 | 20241023232652_MUbLA | DE0006 | 2024-10-25T12:17:56.430Z | 2024-11-01T12:26:56.062Z |
5365131 | 5365131 | 20241023231606_FAuEY | DE0006 | 2024-10-25T12:17:47.057Z | 2024-11-01T12:26:55.886Z |
5364878 | 5364878 | 20241023225902_hdol7 | DE0006 | 2024-10-25T12:17:38.550Z | 2024-11-01T12:26:55.735Z |
5364433 | 5364433 | 20241023222745_tunMh | DE0006 | 2024-10-25T12:17:20.455Z | 2024-11-01T12:26:55.074Z |
5364361 | 5364361 | 20241023222324_dVb6x | DE0006 | 2024-10-25T12:17:18.262Z | 2024-11-01T12:26:55.019Z |
5363792 | 5363792 | 20241023214436_VuZda | DE0006 | 2024-10-25T12:16:46.404Z | 2024-11-01T12:26:53.635Z |
5363779 | 5363779 | 20241023214354_YOIns | DE0006 | 2024-10-25T12:16:44.651Z | 2024-11-01T12:26:53.620Z |
5361137 | 5361137 | 20241023175247_wtOiF | DE0006 | 2024-10-25T12:12:23.083Z | 2024-11-01T12:26:49.322Z |
5353871 | 5353871 | 20241023015233_IjKGq | DE0006 | 2024-10-24T12:19:59.295Z | 2024-10-31T12:30:04.939Z |
5353449 | 5353449 | 20241023012616_3yRa3 | DE0006 | 2024-10-24T12:19:43.011Z | 2024-10-31T12:30:04.260Z |
5353288 | 5353288 | 20241023011903_Atp1F | DE0006 | 2024-10-24T12:19:38.202Z | 2024-10-31T12:30:04.088Z |
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);