participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,752 rows where station_code = "DE0001" 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 |
---|---|---|---|---|---|
5592171 | 5592171 | 20241123022831_Tw26P | DE0001 | 2024-11-24T14:20:43.537Z | 2024-11-26T14:23:39.048Z |
5591998 | 5591998 | 20241123015042_f3I6n | DE0001 | 2024-11-24T14:20:32.094Z | 2024-11-26T14:23:35.305Z |
5591913 | 5591913 | 20241123012953_AW2kI | DE0001 | 2024-11-24T14:20:26.211Z | 2024-11-26T14:23:32.478Z |
5591865 | 5591865 | 20241123011526_QXe4G | DE0001 | 2024-11-24T14:20:21.400Z | 2024-11-26T14:23:31.802Z |
5591747 | 5591747 | 20241123004727_OgOBl | DE0001 | 2024-11-24T14:20:15.645Z | 2024-11-26T14:23:28.951Z |
5591698 | 5591698 | 20241123003326_i05eP | DE0001 | 2024-11-24T14:20:10.960Z | 2024-11-26T14:23:28.415Z |
5591587 | 5591587 | 20241122235944_4WFM7 | DE0001 | 2024-11-24T14:20:04.177Z | 2024-11-26T14:23:26.070Z |
5591551 | 5591551 | 20241122235110_vWX90 | DE0001 | 2024-11-24T14:20:01.032Z | 2024-11-26T14:23:25.284Z |
5591321 | 5591321 | 20241122223239_F7OG0 | DE0001 | 2024-11-24T14:19:44.408Z | 2024-11-26T14:23:20.569Z |
5591202 | 5591202 | 20241122215656_rxr4c | DE0001 | 2024-11-24T14:19:35.381Z | 2024-11-26T14:23:17.772Z |
5582088 | 5582088 | 20241122030212_WJP3f | DE0001 | 2024-11-23T14:20:56.011Z | 2024-11-26T14:25:23.902Z |
5581356 | 5581356 | 20241122015519_I0z14 | DE0001 | 2024-11-23T14:20:17.508Z | 2024-11-26T14:25:15.935Z |
5581329 | 5581329 | 20241122015356_Wgk2t | DE0001 | 2024-11-23T14:20:16.164Z | 2024-11-26T14:25:15.573Z |
5581314 | 5581314 | 20241122015346_j2H35 | DE0001 | 2024-11-23T14:20:14.657Z | 2024-11-26T14:25:15.509Z |
5581286 | 5581286 | 20241122015213_2r7xZ | DE0001 | 2024-11-23T14:20:13.681Z | 2024-11-26T14:25:15.176Z |
5580890 | 5580890 | 20241122012053_W1jHb | DE0001 | 2024-11-23T14:19:46.392Z | 2024-11-26T14:25:11.571Z |
5580799 | 5580799 | 20241122011333_n4ol6 | DE0001 | 2024-11-23T14:19:41.983Z | 2024-11-26T14:25:09.555Z |
5580703 | 5580703 | 20241122010441_38j32 | DE0001 | 2024-11-23T14:19:37.612Z | 2024-11-26T14:25:07.529Z |
5580551 | 5580551 | 20241122005500_5ftG9 | DE0001 | 2024-11-23T14:19:28.986Z | 2024-11-26T14:25:06.184Z |
5580512 | 5580512 | 20241122004909_6ii32 | DE0001 | 2024-11-23T14:19:25.927Z | 2024-11-26T14:25:06.011Z |
5579915 | 5579915 | 20241121233535_z8lN8 | DE0001 | 2024-11-23T14:18:55.841Z | 2024-11-26T14:25:01.772Z |
5579906 | 5579906 | 20241121233445_OJ8sB | DE0001 | 2024-11-23T14:18:55.463Z | 2024-11-26T14:25:01.766Z |
5579179 | 5579179 | 20241121215816_i2p7g | DE0001 | 2024-11-23T14:17:57.078Z | 2024-11-26T14:24:55.524Z |
5579114 | 5579114 | 20241121214745_5JzE2 | DE0001 | 2024-11-23T14:17:51.247Z | 2024-11-26T14:24:54.979Z |
5578875 | 5578875 | 20241121211457_VDMRz | DE0001 | 2024-11-23T14:17:37.231Z | 2024-11-26T14:24:53.257Z |
5578566 | 5578566 | 20241121202336_qh5Up | DE0001 | 2024-11-23T14:17:22.807Z | 2024-11-26T14:24:49.533Z |
5562742 | 5562742 | 20241120000728_8R279 | DE0001 | 2024-11-21T14:15:19.553Z | 2024-11-26T14:27:39.235Z |
5530703 | 5530703 | 20241112023838_ILDNe | DE0001 | 2024-11-13T14:14:28.638Z | 2024-11-20T14:26:02.657Z |
5490269 | 5490269 | 20241105215411_m9qhu | DE0001 | 2024-11-07T14:13:47.423Z | 2024-11-14T14:23:18.613Z |
5490158 | 5490158 | 20241105212532_eGX33 | DE0001 | 2024-11-07T14:13:22.526Z | 2024-11-14T14:23:17.956Z |
5489806 | 5489806 | 20241105200316_u445E | DE0001 | 2024-11-07T14:12:46.704Z | 2024-11-14T14:23:15.738Z |
5489568 | 5489568 | 20241105191804_zT828 | DE0001 | 2024-11-07T14:12:13.325Z | 2024-11-14T14:23:13.834Z |
5489065 | 5489065 | 20241105174333_tPpXa | DE0001 | 2024-11-07T14:11:15.255Z | 2024-11-14T14:23:10.026Z |
5488976 | 5488976 | 20241105173033_yN684 | DE0001 | 2024-11-07T14:11:07.447Z | 2024-11-14T14:23:09.167Z |
5485399 | 5485399 | 20241105052102_BrLSz | DE0001 | 2024-11-06T14:18:12.283Z | 2024-11-13T14:27:42.112Z |
5485373 | 5485373 | 20241105051242_9u2x6 | DE0001 | 2024-11-06T14:18:10.797Z | 2024-11-13T14:27:42.077Z |
5485371 | 5485371 | 20241105050906_c2ANS | DE0001 | 2024-11-06T14:18:10.522Z | 2024-11-13T14:27:42.073Z |
5485362 | 5485362 | 20241105050642_CJkec | DE0001 | 2024-11-06T14:18:09.849Z | 2024-11-13T14:27:42.057Z |
5485340 | 5485340 | 20241105045915_CN8R1 | DE0001 | 2024-11-06T14:18:08.948Z | 2024-11-13T14:27:41.815Z |
5485332 | 5485332 | 20241105045255_fsurR | DE0001 | 2024-11-06T14:18:08.010Z | 2024-11-13T14:27:41.763Z |
5485321 | 5485321 | 20241105045107_59pyO | DE0001 | 2024-11-06T14:18:07.545Z | 2024-11-13T14:27:41.655Z |
5485286 | 5485286 | 20241105043950_VvaRQ | DE0001 | 2024-11-06T14:18:03.608Z | 2024-11-13T14:27:41.564Z |
5485236 | 5485236 | 20241105042707_nDcCO | DE0001 | 2024-11-06T14:17:58.035Z | 2024-11-13T14:27:41.077Z |
5484630 | 5484630 | 20241105031521_fuOdN | DE0001 | 2024-11-06T14:17:07.289Z | 2024-11-13T14:27:38.951Z |
5484598 | 5484598 | 20241105031013_fX2BV | DE0001 | 2024-11-06T14:17:04.444Z | 2024-11-13T14:27:38.840Z |
5484468 | 5484468 | 20241105025417_6omKR | DE0001 | 2024-11-06T14:16:56.640Z | 2024-11-13T14:27:38.123Z |
5484347 | 5484347 | 20241105023742_2oymg | DE0001 | 2024-11-06T14:16:49.931Z | 2024-11-13T14:27:37.779Z |
5484322 | 5484322 | 20241105023431_SUhYy | DE0001 | 2024-11-06T14:16:48.376Z | 2024-11-13T14:27:37.730Z |
5484091 | 5484091 | 20241105020911_3s7s7 | DE0001 | 2024-11-06T14:16:12.940Z | 2024-11-13T14:27:37.271Z |
5484085 | 5484085 | 20241105020909_hIf9L | DE0001 | 2024-11-06T14:16:12.685Z | 2024-11-13T14:27:37.270Z |
5483966 | 5483966 | 20241105014950_boY1H | DE0001 | 2024-11-06T14:15:58.957Z | 2024-11-13T14:27:37.073Z |
5483960 | 5483960 | 20241105014945_mfWXy | DE0001 | 2024-11-06T14:15:58.602Z | 2024-11-13T14:27:37.066Z |
5483897 | 5483897 | 20241105014202_xFcmq | DE0001 | 2024-11-06T14:15:51.460Z | 2024-11-13T14:27:36.992Z |
5483771 | 5483771 | 20241105012926_qcRd3 | DE0001 | 2024-11-06T14:15:41.850Z | 2024-11-13T14:27:36.785Z |
5483752 | 5483752 | 20241105012653_6ktkB | DE0001 | 2024-11-06T14:15:40.423Z | 2024-11-13T14:27:36.765Z |
5483740 | 5483740 | 20241105012552_KVMId | DE0001 | 2024-11-06T14:15:39.385Z | 2024-11-13T14:27:36.724Z |
5483668 | 5483668 | 20241105011717_I44Gu | DE0001 | 2024-11-06T14:15:34.756Z | 2024-11-13T14:27:36.598Z |
5483658 | 5483658 | 20241105011634_vblCJ | DE0001 | 2024-11-06T14:15:34.048Z | 2024-11-13T14:27:36.572Z |
5483646 | 5483646 | 20241105011447_G7zpN | DE0001 | 2024-11-06T14:15:33.587Z | 2024-11-13T14:27:36.545Z |
5483553 | 5483553 | 20241105005614_t2sdW | DE0001 | 2024-11-06T14:15:28.421Z | 2024-11-13T14:27:36.391Z |
5483505 | 5483505 | 20241105004753_JsHt8 | DE0001 | 2024-11-06T14:15:25.702Z | 2024-11-13T14:27:36.341Z |
5483497 | 5483497 | 20241105004521_9aZVy | DE0001 | 2024-11-06T14:15:25.457Z | 2024-11-13T14:27:36.336Z |
5483432 | 5483432 | 20241105004045_dvnXj | DE0001 | 2024-11-06T14:15:17.352Z | 2024-11-13T14:27:36.237Z |
5483421 | 5483421 | 20241105003911_3hvL3 | DE0001 | 2024-11-06T14:15:14.742Z | 2024-11-13T14:27:36.218Z |
5483394 | 5483394 | 20241105003528_1h2cy | DE0001 | 2024-11-06T14:15:11.727Z | 2024-11-13T14:27:36.179Z |
5483382 | 5483382 | 20241105003446_IrfZf | DE0001 | 2024-11-06T14:15:08.255Z | 2024-11-13T14:27:36.149Z |
5483379 | 5483379 | 20241105003440_FUA2J | DE0001 | 2024-11-06T14:15:06.044Z | 2024-11-13T14:27:36.146Z |
5483351 | 5483351 | 20241105003005_zvjy0 | DE0001 | 2024-11-06T14:15:01.451Z | 2024-11-13T14:27:36.071Z |
5483311 | 5483311 | 20241105002608_jJ4ww | DE0001 | 2024-11-06T14:14:58.560Z | 2024-11-13T14:27:36.026Z |
5483298 | 5483298 | 20241105002451_FEQRt | DE0001 | 2024-11-06T14:14:56.387Z | 2024-11-13T14:27:36.005Z |
5483100 | 5483100 | 20241104235830_FlLm0 | DE0001 | 2024-11-06T14:14:40.210Z | 2024-11-13T14:27:35.717Z |
5483074 | 5483074 | 20241104235502_q6ZGD | DE0001 | 2024-11-06T14:14:38.641Z | 2024-11-13T14:27:35.679Z |
5483026 | 5483026 | 20241104234853_Yhkcx | DE0001 | 2024-11-06T14:14:35.512Z | 2024-11-13T14:27:35.596Z |
5482893 | 5482893 | 20241104233111_q8Jel | DE0001 | 2024-11-06T14:14:16.771Z | 2024-11-13T14:27:35.331Z |
5482638 | 5482638 | 20241104225248_2ezr9 | DE0001 | 2024-11-06T14:13:29.151Z | 2024-11-13T14:27:34.948Z |
5482613 | 5482613 | 20241104224857_vfn9b | DE0001 | 2024-11-06T14:13:26.831Z | 2024-11-13T14:27:34.902Z |
5482562 | 5482562 | 20241104223958_bdyu8 | DE0001 | 2024-11-06T14:13:21.791Z | 2024-11-13T14:27:34.827Z |
5482557 | 5482557 | 20241104223958_rVvhf | DE0001 | 2024-11-06T14:13:21.532Z | 2024-11-13T14:27:34.823Z |
5482510 | 5482510 | 20241104223405_F2b87 | DE0001 | 2024-11-06T14:13:17.252Z | 2024-11-13T14:27:34.738Z |
5482450 | 5482450 | 20241104221823_IArRd | DE0001 | 2024-11-06T14:13:12.480Z | 2024-11-13T14:27:34.620Z |
5482408 | 5482408 | 20241104220811_Y2pQP | DE0001 | 2024-11-06T14:13:08.617Z | 2024-11-13T14:27:34.513Z |
5482400 | 5482400 | 20241104220715_dmS2v | DE0001 | 2024-11-06T14:13:07.881Z | 2024-11-13T14:27:34.487Z |
5482269 | 5482269 | 20241104214124_J393V | DE0001 | 2024-11-06T14:12:45.674Z | 2024-11-13T14:27:34.245Z |
5482171 | 5482171 | 20241104212017_RPQjF | DE0001 | 2024-11-06T14:12:31.220Z | 2024-11-13T14:27:34.071Z |
5482156 | 5482156 | 20241104211722_DYSHO | DE0001 | 2024-11-06T14:12:29.050Z | 2024-11-13T14:27:34.033Z |
5482150 | 5482150 | 20241104211545_jSWI5 | DE0001 | 2024-11-06T14:12:28.688Z | 2024-11-13T14:27:34.023Z |
5482074 | 5482074 | 20241104210132_I43a9 | DE0001 | 2024-11-06T14:12:20.810Z | 2024-11-13T14:27:33.843Z |
5481993 | 5481993 | 20241104204349_NEdNs | DE0001 | 2024-11-06T14:12:13.594Z | 2024-11-13T14:27:33.658Z |
5481830 | 5481830 | 20241104195458_9z64b | DE0001 | 2024-11-06T14:11:39.143Z | 2024-11-13T14:27:33.218Z |
5481813 | 5481813 | 20241104195022_o0mua | DE0001 | 2024-11-06T14:11:37.571Z | 2024-11-13T14:27:33.185Z |
5481803 | 5481803 | 20241104194642_RE41Q | DE0001 | 2024-11-06T14:11:36.854Z | 2024-11-13T14:27:33.144Z |
5481752 | 5481752 | 20241104193346_V61bn | DE0001 | 2024-11-06T14:11:31.079Z | 2024-11-13T14:27:32.592Z |
5478707 | 5478707 | 20241104051421_0sTuk | DE0001 | 2024-11-05T14:18:43.590Z | 2024-11-12T14:28:16.614Z |
5478679 | 5478679 | 20241104050632_dmAmI | DE0001 | 2024-11-05T14:18:41.465Z | 2024-11-12T14:28:16.558Z |
5478662 | 5478662 | 20241104045540_Tzgtf | DE0001 | 2024-11-05T14:18:38.885Z | 2024-11-12T14:28:16.502Z |
5478608 | 5478608 | 20241104044307_2KOYd | DE0001 | 2024-11-05T14:18:33.994Z | 2024-11-12T14:28:16.390Z |
5478582 | 5478582 | 20241104043545_Jtxd6 | DE0001 | 2024-11-05T14:18:32.701Z | 2024-11-12T14:28:16.277Z |
5478570 | 5478570 | 20241104043455_gJa4k | DE0001 | 2024-11-05T14:18:32.423Z | 2024-11-12T14:28:16.135Z |
5478526 | 5478526 | 20241104042532_hv9k5 | DE0001 | 2024-11-05T14:18:28.390Z | 2024-11-12T14:28:15.823Z |
5478465 | 5478465 | 20241104041555_2jPpy | DE0001 | 2024-11-05T14:18:24.134Z | 2024-11-12T14:28:15.554Z |
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);