participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
613 rows where station_code = "DE000P" 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 |
---|---|---|---|---|---|
5060653 | 5060653 | 20240910204847_Te1nB | DE000P | 2024-09-14T12:09:17.979Z | 2024-09-19T12:21:33.401Z |
5060211 | 5060211 | 20240910200747_ttlr1 | DE000P | 2024-09-14T12:08:29.586Z | 2024-09-19T12:21:32.003Z |
5054651 | 5054651 | 20240908032931_X42qm | DE000P | 2024-09-13T12:16:50.993Z | 2024-09-16T12:21:16.405Z |
5054509 | 5054509 | 20240908030304_L5bmH | DE000P | 2024-09-13T12:16:45.190Z | 2024-09-16T12:21:15.809Z |
5053906 | 5053906 | 20240908014722_4FNMv | DE000P | 2024-09-13T12:16:21.514Z | 2024-09-16T12:21:13.110Z |
5053756 | 5053756 | 20240908012355_yslM3 | DE000P | 2024-09-13T12:16:16.898Z | 2024-09-16T12:21:12.650Z |
5053448 | 5053448 | 20240908003652_1fRpK | DE000P | 2024-09-13T12:16:04.368Z | 2024-09-16T12:21:11.154Z |
5053316 | 5053316 | 20240908000922_PyRqK | DE000P | 2024-09-13T12:15:58.483Z | 2024-09-16T12:21:10.319Z |
5053289 | 5053289 | 20240908000446_2LpQQ | DE000P | 2024-09-13T12:15:57.016Z | 2024-09-16T12:21:10.251Z |
5052972 | 5052972 | 20240907225028_l0bUZ | DE000P | 2024-09-13T12:15:39.114Z | 2024-09-16T12:21:08.787Z |
5052488 | 5052488 | 20240907205329_lKYUJ | DE000P | 2024-09-13T12:15:11.533Z | 2024-09-16T12:21:05.948Z |
5052123 | 5052123 | 20240907194250_wTs97 | DE000P | 2024-09-13T12:14:57.460Z | 2024-09-16T12:21:03.905Z |
5033318 | 5033318 | 20240907024829_bnUnh | DE000P | 2024-09-12T12:09:07.383Z | 2024-09-15T12:21:29.601Z |
5033099 | 5033099 | 20240907022456_U9meM | DE000P | 2024-09-12T12:08:49.236Z | 2024-09-15T12:21:29.007Z |
5032929 | 5032929 | 20240907020512_8L9XP | DE000P | 2024-09-12T12:08:29.428Z | 2024-09-15T12:21:28.331Z |
5032007 | 5032007 | 20240906235357_4vB8e | DE000P | 2024-09-12T12:06:23.178Z | 2024-09-15T12:21:25.005Z |
5031953 | 5031953 | 20240906234559_EeIpu | DE000P | 2024-09-12T12:06:10.221Z | 2024-09-15T12:21:24.867Z |
5031562 | 5031562 | 20240906222843_iWwse | DE000P | 2024-09-12T12:05:10.673Z | 2024-09-15T12:21:23.071Z |
5031308 | 5031308 | 20240906212000_9EkBd | DE000P | 2024-09-12T12:04:29.501Z | 2024-09-15T12:21:21.939Z |
5031044 | 5031044 | 20240906201238_yamvS | DE000P | 2024-09-12T12:03:47.541Z | 2024-09-15T12:21:21.232Z |
5030868 | 5030868 | 20240906191455_ywvvf | DE000P | 2024-09-12T12:03:17.021Z | 2024-09-15T12:21:20.215Z |
4996754 | 4996754 | 20240902204938_xBa0I | DE000P | 2024-09-08T12:05:14.427Z | 2024-09-11T12:20:57.817Z |
4996206 | 4996206 | 20240902185837_3PoXE | DE000P | 2024-09-08T12:04:30.379Z | 2024-09-11T12:20:51.842Z |
4991002 | 4991002 | 20240901014434_8RLdQ | DE000P | 2024-09-07T12:11:26.341Z | 2024-09-09T12:26:57.439Z |
4990801 | 4990801 | 20240901011313_GNMLu | DE000P | 2024-09-07T12:11:08.619Z | 2024-09-09T12:26:44.200Z |
4988226 | 4988226 | 20240901201605_TQPrH | DE000P | 2024-09-07T12:07:05.280Z | 2024-09-10T12:19:13.130Z |
4983516 | 4983516 | 20240812004511_a7W3f | DE000P | 2024-09-06T12:15:35.350Z | 2024-09-06T12:15:35.350Z |
4968514 | 4968514 | 20240811215844_2j1qC | DE000P | 2024-09-05T12:08:21.048Z | 2024-09-06T12:07:31.293Z |
4967701 | 4967701 | 20240811214808_WCMNR | DE000P | 2024-09-05T12:07:45.741Z | 2024-09-06T12:07:07.252Z |
4967029 | 4967029 | 20240811213809_DBTMB | DE000P | 2024-09-05T12:07:28.851Z | 2024-09-06T12:06:52.154Z |
4966557 | 4966557 | 20240811213105_3b8iM | DE000P | 2024-09-04T12:07:29.646Z | 2024-09-06T12:06:34.719Z |
4966148 | 4966148 | 20240811212438_jz3rI | DE000P | 2024-09-04T12:07:19.094Z | 2024-09-06T12:06:14.823Z |
4965296 | 4965296 | 20240811211145_c3upb | DE000P | 2024-09-04T12:06:53.642Z | 2024-09-06T12:05:52.882Z |
4964179 | 4964179 | 20240811204809_gnk7A | DE000P | 2024-09-04T12:06:11.220Z | 2024-09-06T12:05:13.447Z |
4952451 | 4952451 | 20240811022224_L7NZz | DE000P | 2024-09-03T12:16:58.671Z | 2024-09-06T12:28:02.327Z |
4950804 | 4950804 | 20240811021214_k2srx | DE000P | 2024-09-02T12:16:36.534Z | 2024-09-06T12:27:50.100Z |
4950541 | 4950541 | 20240811020826_TaKgd | DE000P | 2024-09-02T12:16:30.362Z | 2024-09-06T12:27:45.370Z |
4949335 | 4949335 | 20240811014757_tJd72 | DE000P | 2024-09-02T12:15:43.158Z | 2024-09-06T12:27:32.095Z |
4948152 | 4948152 | 20240811012932_0FG9N | DE000P | 2024-09-02T12:14:56.276Z | 2024-09-06T12:27:10.137Z |
4947625 | 4947625 | 20240811012146_czf9k | DE000P | 2024-09-02T12:14:41.288Z | 2024-09-06T12:26:56.261Z |
4947368 | 4947368 | 20240811011749_fdMHF | DE000P | 2024-09-02T12:14:27.980Z | 2024-09-06T12:26:51.956Z |
4946940 | 4946940 | 20240811011048_hCby8 | DE000P | 2024-09-02T12:14:12.217Z | 2024-09-06T12:26:40.684Z |
4943275 | 4943275 | 20240811000904_4BtWd | DE000P | 2024-09-02T12:11:45.999Z | 2024-09-06T12:24:42.540Z |
4943206 | 4943206 | 20240811000808_EE4sU | DE000P | 2024-09-02T12:11:44.599Z | 2024-09-06T12:24:40.829Z |
4942402 | 4942402 | 20240810235132_M5Kvy | DE000P | 2024-09-02T12:11:11.386Z | 2024-09-06T12:24:15.244Z |
4942393 | 4942393 | 20240810235121_rqlyr | DE000P | 2024-09-02T12:11:11.140Z | 2024-09-06T12:24:15.134Z |
4941333 | 4941333 | 20240810233107_lLunP | DE000P | 2024-09-02T12:10:26.077Z | 2024-09-06T12:23:46.525Z |
4941193 | 4941193 | 20240810232813_bCj68 | DE000P | 2024-09-02T12:10:19.521Z | 2024-09-06T12:23:44.703Z |
4940330 | 4940330 | 20240810230954_w3wEp | DE000P | 2024-09-01T12:10:24.797Z | 2024-09-06T12:23:33.948Z |
4938388 | 4938388 | 20240810221916_jFQFL | DE000P | 2024-09-01T12:09:05.792Z | 2024-09-06T12:22:51.276Z |
4937038 | 4937038 | 20240810213809_3Rq9s | DE000P | 2024-09-01T12:08:00.605Z | 2024-09-06T12:21:56.942Z |
4937015 | 4937015 | 20240810213711_3bL0a | DE000P | 2024-09-01T12:07:59.529Z | 2024-09-06T12:21:55.932Z |
4936950 | 4936950 | 20240810213603_5RoSy | DE000P | 2024-09-01T12:07:57.243Z | 2024-09-06T12:21:53.936Z |
4936076 | 4936076 | 20240810210009_CsJi8 | DE000P | 2024-09-01T12:07:06.686Z | 2024-09-06T12:21:13.657Z |
4927183 | 4927183 | 20240810020553_HlNLm | DE000P | 2024-08-31T12:20:19.396Z | 2024-09-02T12:28:22.151Z |
4923106 | 4923106 | 20240810013206_frj13 | DE000P | 2024-08-30T12:15:06.135Z | 2024-09-02T12:27:35.131Z |
4919224 | 4919224 | 20240810000653_fvpcI | DE000P | 2024-08-30T12:12:35.419Z | 2024-09-02T12:25:43.564Z |
4918935 | 4918935 | 20240810000119_WLaOu | DE000P | 2024-08-30T12:12:26.415Z | 2024-09-02T12:25:38.958Z |
4913139 | 4913139 | 20240809213924_98Nac | DE000P | 2024-08-29T12:08:59.084Z | 2024-09-02T12:22:45.142Z |
4901465 | 4901465 | 20240808013032_AHFPC | DE000P | 2024-08-28T12:18:44.500Z | 2024-08-28T12:18:44.500Z |
4901330 | 4901330 | 20240808012316_1r33G | DE000P | 2024-08-28T12:18:41.955Z | 2024-08-28T12:18:41.955Z |
4899162 | 4899162 | 20240807223606_PewI7 | DE000P | 2024-08-28T12:17:11.666Z | 2024-08-28T12:17:11.666Z |
4899138 | 4899138 | 20240807223442_XTA3W | DE000P | 2024-08-28T12:17:11.164Z | 2024-08-28T12:17:11.164Z |
4899013 | 4899013 | 20240807222727_X7j4k | DE000P | 2024-08-28T12:17:00.694Z | 2024-08-28T12:17:00.694Z |
4898567 | 4898567 | 20240807214856_Y0Ugw | DE000P | 2024-08-28T12:16:42.755Z | 2024-08-28T12:16:42.755Z |
4898343 | 4898343 | 20240807212746_usBLl | DE000P | 2024-08-28T12:16:34.240Z | 2024-08-28T12:16:34.240Z |
4892440 | 4892440 | 20240809025145_Np3Tn | DE000P | 2024-08-28T12:10:13.931Z | 2024-08-30T12:22:08.117Z |
4892359 | 4892359 | 20240809023535_2dEun | DE000P | 2024-08-28T12:10:09.180Z | 2024-08-30T12:22:02.134Z |
4892308 | 4892308 | 20240809022821_kzCv3 | DE000P | 2024-08-28T12:10:02.147Z | 2024-08-30T12:21:58.420Z |
4892287 | 4892287 | 20240809022506_TbULR | DE000P | 2024-08-28T12:10:01.200Z | 2024-08-30T12:21:57.404Z |
4892075 | 4892075 | 20240809020328_6HreR | DE000P | 2024-08-28T12:09:46.662Z | 2024-08-30T12:21:37.971Z |
4891549 | 4891549 | 20240809011149_9djsZ | DE000P | 2024-08-28T12:09:09.731Z | 2024-08-30T12:21:17.689Z |
4891546 | 4891546 | 20240809011149_c8wc2 | DE000P | 2024-08-28T12:09:09.621Z | 2024-08-30T12:21:17.664Z |
4890288 | 4890288 | 20240808225401_QY4Oz | DE000P | 2024-08-28T12:07:30.362Z | 2024-08-30T12:20:10.533Z |
4882839 | 4882839 | 20240807022344_c68X4 | DE000P | 2024-08-20T12:14:41.595Z | 2024-08-27T12:15:42.404Z |
4882685 | 4882685 | 20240807021855_sHPbz | DE000P | 2024-08-20T12:14:35.801Z | 2024-08-27T12:15:37.435Z |
4881823 | 4881823 | 20240807015421_4DjFA | DE000P | 2024-08-20T12:14:21.010Z | 2024-08-27T12:15:22.132Z |
4881658 | 4881658 | 20240807015005_klt7r | DE000P | 2024-08-20T12:14:17.543Z | 2024-08-27T12:15:19.217Z |
4881309 | 4881309 | 20240807014224_brq23 | DE000P | 2024-08-20T12:13:58.800Z | 2024-08-27T12:15:08.983Z |
4881016 | 4881016 | 20240807013449_hl0HB | DE000P | 2024-08-20T12:13:42.972Z | 2024-08-27T12:14:59.362Z |
4880723 | 4880723 | 20240807012754_1dbE2 | DE000P | 2024-08-20T12:13:32.952Z | 2024-08-27T12:14:50.468Z |
4880287 | 4880287 | 20240807011645_IsM7h | DE000P | 2024-08-20T12:13:22.491Z | 2024-08-27T12:14:39.764Z |
4879037 | 4879037 | 20240807004550_4BBnD | DE000P | 2024-08-19T12:14:36.827Z | 2024-08-27T12:14:04.739Z |
4878424 | 4878424 | 20240807002802_nHTCZ | DE000P | 2024-08-19T12:14:12.127Z | 2024-08-27T12:13:42.186Z |
4877263 | 4877263 | 20240806235804_qg9HT | DE000P | 2024-08-19T12:13:16.660Z | 2024-08-27T12:13:07.228Z |
4874854 | 4874854 | 20240806225856_aYKO9 | DE000P | 2024-08-19T12:11:51.036Z | 2024-08-27T12:11:54.599Z |
4871743 | 4871743 | 20240806210756_GlvLw | DE000P | 2024-08-19T12:09:23.059Z | 2024-08-27T12:10:00.341Z |
4857582 | 4857582 | 20240806023744_0L3pl | DE000P | 2024-08-17T12:22:41.592Z | 2024-08-19T12:28:18.012Z |
4856421 | 4856421 | 20240806013126_QlDSR | DE000P | 2024-08-17T12:21:14.319Z | 2024-08-19T12:27:25.459Z |
4856170 | 4856170 | 20240806012110_oIrxk | DE000P | 2024-08-17T12:20:54.370Z | 2024-08-19T12:27:14.456Z |
4855464 | 4855464 | 20240806004319_2l31c | DE000P | 2024-08-17T12:20:04.621Z | 2024-08-19T12:26:42.524Z |
4855351 | 4855351 | 20240806003708_sEetf | DE000P | 2024-08-17T12:19:59.112Z | 2024-08-19T12:26:36.298Z |
4854939 | 4854939 | 20240806001319_QXuTN | DE000P | 2024-08-17T12:19:21.127Z | 2024-08-19T12:26:16.564Z |
4854545 | 4854545 | 20240805234724_nnIQ3 | DE000P | 2024-08-17T12:18:48.610Z | 2024-08-19T12:25:59.209Z |
4853942 | 4853942 | 20240805232106_vSDZH | DE000P | 2024-08-17T12:18:01.857Z | 2024-08-19T12:25:27.754Z |
4853683 | 4853683 | 20240805230815_4lnG3 | DE000P | 2024-08-17T12:17:45.123Z | 2024-08-19T12:25:12.158Z |
4852914 | 4852914 | 20240805222726_cuag1 | DE000P | 2024-08-17T12:16:47.543Z | 2024-08-19T12:24:35.385Z |
4852773 | 4852773 | 20240805221955_wvpHX | DE000P | 2024-08-17T12:16:30.905Z | 2024-08-19T12:24:32.630Z |
4851072 | 4851072 | 20240805203047_LUVpk | DE000P | 2024-08-17T12:14:11.416Z | 2024-08-19T12:23:40.636Z |
4850978 | 4850978 | 20240805202143_Ra7gI | DE000P | 2024-08-17T12:14:05.784Z | 2024-08-19T12:23:36.101Z |
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);