participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,724 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 |
---|---|---|---|---|---|
5490269 | 5490269 | 20241105215411_m9qhu | DE0001 | 2024-11-07T14:13:47.423Z | 2024-11-12T14:26:47.574Z |
5490158 | 5490158 | 20241105212532_eGX33 | DE0001 | 2024-11-07T14:13:22.526Z | 2024-11-12T14:26:46.839Z |
5489806 | 5489806 | 20241105200316_u445E | DE0001 | 2024-11-07T14:12:46.704Z | 2024-11-12T14:26:45.004Z |
5489568 | 5489568 | 20241105191804_zT828 | DE0001 | 2024-11-07T14:12:13.325Z | 2024-11-12T14:26:43.807Z |
5489065 | 5489065 | 20241105174333_tPpXa | DE0001 | 2024-11-07T14:11:15.255Z | 2024-11-12T14:26:38.581Z |
5488976 | 5488976 | 20241105173033_yN684 | DE0001 | 2024-11-07T14:11:07.447Z | 2024-11-12T14:26:37.375Z |
5485399 | 5485399 | 20241105052102_BrLSz | DE0001 | 2024-11-06T14:18:12.283Z | 2024-11-12T14:27:38.594Z |
5485373 | 5485373 | 20241105051242_9u2x6 | DE0001 | 2024-11-06T14:18:10.797Z | 2024-11-12T14:27:38.530Z |
5485371 | 5485371 | 20241105050906_c2ANS | DE0001 | 2024-11-06T14:18:10.522Z | 2024-11-12T14:27:38.462Z |
5485362 | 5485362 | 20241105050642_CJkec | DE0001 | 2024-11-06T14:18:09.849Z | 2024-11-12T14:27:38.442Z |
5485340 | 5485340 | 20241105045915_CN8R1 | DE0001 | 2024-11-06T14:18:08.948Z | 2024-11-12T14:27:38.392Z |
5485332 | 5485332 | 20241105045255_fsurR | DE0001 | 2024-11-06T14:18:08.010Z | 2024-11-12T14:27:38.351Z |
5485321 | 5485321 | 20241105045107_59pyO | DE0001 | 2024-11-06T14:18:07.545Z | 2024-11-12T14:27:38.308Z |
5485286 | 5485286 | 20241105043950_VvaRQ | DE0001 | 2024-11-06T14:18:03.608Z | 2024-11-12T14:27:38.098Z |
5485236 | 5485236 | 20241105042707_nDcCO | DE0001 | 2024-11-06T14:17:58.035Z | 2024-11-12T14:27:37.514Z |
5484630 | 5484630 | 20241105031521_fuOdN | DE0001 | 2024-11-06T14:17:07.289Z | 2024-11-12T14:27:34.995Z |
5484598 | 5484598 | 20241105031013_fX2BV | DE0001 | 2024-11-06T14:17:04.444Z | 2024-11-12T14:27:34.882Z |
5484468 | 5484468 | 20241105025417_6omKR | DE0001 | 2024-11-06T14:16:56.640Z | 2024-11-12T14:27:34.354Z |
5484347 | 5484347 | 20241105023742_2oymg | DE0001 | 2024-11-06T14:16:49.931Z | 2024-11-12T14:27:33.572Z |
5484322 | 5484322 | 20241105023431_SUhYy | DE0001 | 2024-11-06T14:16:48.376Z | 2024-11-12T14:27:33.497Z |
5484091 | 5484091 | 20241105020911_3s7s7 | DE0001 | 2024-11-06T14:16:12.940Z | 2024-11-12T14:27:31.698Z |
5484085 | 5484085 | 20241105020909_hIf9L | DE0001 | 2024-11-06T14:16:12.685Z | 2024-11-12T14:27:31.693Z |
5483966 | 5483966 | 20241105014950_boY1H | DE0001 | 2024-11-06T14:15:58.957Z | 2024-11-12T14:27:30.799Z |
5483960 | 5483960 | 20241105014945_mfWXy | DE0001 | 2024-11-06T14:15:58.602Z | 2024-11-12T14:27:30.775Z |
5483897 | 5483897 | 20241105014202_xFcmq | DE0001 | 2024-11-06T14:15:51.460Z | 2024-11-12T14:27:30.543Z |
5483771 | 5483771 | 20241105012926_qcRd3 | DE0001 | 2024-11-06T14:15:41.850Z | 2024-11-12T14:27:30.146Z |
5483752 | 5483752 | 20241105012653_6ktkB | DE0001 | 2024-11-06T14:15:40.423Z | 2024-11-12T14:27:30.101Z |
5483740 | 5483740 | 20241105012552_KVMId | DE0001 | 2024-11-06T14:15:39.385Z | 2024-11-12T14:27:29.908Z |
5483668 | 5483668 | 20241105011717_I44Gu | DE0001 | 2024-11-06T14:15:34.756Z | 2024-11-12T14:27:29.701Z |
5483658 | 5483658 | 20241105011634_vblCJ | DE0001 | 2024-11-06T14:15:34.048Z | 2024-11-12T14:27:29.657Z |
5483646 | 5483646 | 20241105011447_G7zpN | DE0001 | 2024-11-06T14:15:33.587Z | 2024-11-12T14:27:29.518Z |
5483553 | 5483553 | 20241105005614_t2sdW | DE0001 | 2024-11-06T14:15:28.421Z | 2024-11-12T14:27:28.907Z |
5483505 | 5483505 | 20241105004753_JsHt8 | DE0001 | 2024-11-06T14:15:25.702Z | 2024-11-12T14:27:28.442Z |
5483497 | 5483497 | 20241105004521_9aZVy | DE0001 | 2024-11-06T14:15:25.457Z | 2024-11-12T14:27:28.317Z |
5483432 | 5483432 | 20241105004045_dvnXj | DE0001 | 2024-11-06T14:15:17.352Z | 2024-11-12T14:27:28.115Z |
5483421 | 5483421 | 20241105003911_3hvL3 | DE0001 | 2024-11-06T14:15:14.742Z | 2024-11-12T14:27:28.095Z |
5483394 | 5483394 | 20241105003528_1h2cy | DE0001 | 2024-11-06T14:15:11.727Z | 2024-11-12T14:27:27.977Z |
5483382 | 5483382 | 20241105003446_IrfZf | DE0001 | 2024-11-06T14:15:08.255Z | 2024-11-12T14:27:27.874Z |
5483379 | 5483379 | 20241105003440_FUA2J | DE0001 | 2024-11-06T14:15:06.044Z | 2024-11-12T14:27:27.866Z |
5483351 | 5483351 | 20241105003005_zvjy0 | DE0001 | 2024-11-06T14:15:01.451Z | 2024-11-12T14:27:27.766Z |
5483311 | 5483311 | 20241105002608_jJ4ww | DE0001 | 2024-11-06T14:14:58.560Z | 2024-11-12T14:27:27.618Z |
5483298 | 5483298 | 20241105002451_FEQRt | DE0001 | 2024-11-06T14:14:56.387Z | 2024-11-12T14:27:27.545Z |
5483100 | 5483100 | 20241104235830_FlLm0 | DE0001 | 2024-11-06T14:14:40.210Z | 2024-11-12T14:27:25.759Z |
5483074 | 5483074 | 20241104235502_q6ZGD | DE0001 | 2024-11-06T14:14:38.641Z | 2024-11-12T14:27:25.705Z |
5483026 | 5483026 | 20241104234853_Yhkcx | DE0001 | 2024-11-06T14:14:35.512Z | 2024-11-12T14:27:25.351Z |
5482893 | 5482893 | 20241104233111_q8Jel | DE0001 | 2024-11-06T14:14:16.771Z | 2024-11-12T14:27:24.511Z |
5482638 | 5482638 | 20241104225248_2ezr9 | DE0001 | 2024-11-06T14:13:29.151Z | 2024-11-12T14:27:23.513Z |
5482613 | 5482613 | 20241104224857_vfn9b | DE0001 | 2024-11-06T14:13:26.831Z | 2024-11-12T14:27:23.386Z |
5482562 | 5482562 | 20241104223958_bdyu8 | DE0001 | 2024-11-06T14:13:21.791Z | 2024-11-12T14:27:22.993Z |
5482557 | 5482557 | 20241104223958_rVvhf | DE0001 | 2024-11-06T14:13:21.532Z | 2024-11-12T14:27:22.968Z |
5482510 | 5482510 | 20241104223405_F2b87 | DE0001 | 2024-11-06T14:13:17.252Z | 2024-11-12T14:27:22.752Z |
5482450 | 5482450 | 20241104221823_IArRd | DE0001 | 2024-11-06T14:13:12.480Z | 2024-11-12T14:27:22.532Z |
5482408 | 5482408 | 20241104220811_Y2pQP | DE0001 | 2024-11-06T14:13:08.617Z | 2024-11-12T14:27:22.387Z |
5482400 | 5482400 | 20241104220715_dmS2v | DE0001 | 2024-11-06T14:13:07.881Z | 2024-11-12T14:27:22.375Z |
5482269 | 5482269 | 20241104214124_J393V | DE0001 | 2024-11-06T14:12:45.674Z | 2024-11-12T14:27:21.490Z |
5482171 | 5482171 | 20241104212017_RPQjF | DE0001 | 2024-11-06T14:12:31.220Z | 2024-11-12T14:27:20.410Z |
5482156 | 5482156 | 20241104211722_DYSHO | DE0001 | 2024-11-06T14:12:29.050Z | 2024-11-12T14:27:20.236Z |
5482150 | 5482150 | 20241104211545_jSWI5 | DE0001 | 2024-11-06T14:12:28.688Z | 2024-11-12T14:27:20.210Z |
5482074 | 5482074 | 20241104210132_I43a9 | DE0001 | 2024-11-06T14:12:20.810Z | 2024-11-12T14:27:19.621Z |
5481993 | 5481993 | 20241104204349_NEdNs | DE0001 | 2024-11-06T14:12:13.594Z | 2024-11-12T14:27:18.602Z |
5481830 | 5481830 | 20241104195458_9z64b | DE0001 | 2024-11-06T14:11:39.143Z | 2024-11-12T14:27:17.356Z |
5481813 | 5481813 | 20241104195022_o0mua | DE0001 | 2024-11-06T14:11:37.571Z | 2024-11-12T14:27:17.310Z |
5481803 | 5481803 | 20241104194642_RE41Q | DE0001 | 2024-11-06T14:11:36.854Z | 2024-11-12T14:27:17.186Z |
5481752 | 5481752 | 20241104193346_V61bn | DE0001 | 2024-11-06T14:11:31.079Z | 2024-11-12T14:27:16.752Z |
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 |
5478347 | 5478347 | 20241104035523_DKC0t | DE0001 | 2024-11-05T14:18:15.125Z | 2024-11-12T14:28:14.991Z |
5478314 | 5478314 | 20241104035120_n8eXV | DE0001 | 2024-11-05T14:18:13.177Z | 2024-11-12T14:28:14.926Z |
5478240 | 5478240 | 20241104034039_3cRHB | DE0001 | 2024-11-05T14:18:05.938Z | 2024-11-12T14:28:14.653Z |
5478170 | 5478170 | 20241104033159_jSY8f | DE0001 | 2024-11-05T14:18:01.773Z | 2024-11-12T14:28:14.479Z |
5477952 | 5477952 | 20241104030017_yPzeg | DE0001 | 2024-11-05T14:17:40.151Z | 2024-11-12T14:28:13.646Z |
5477640 | 5477640 | 20241104021634_2hWCD | DE0001 | 2024-11-05T14:17:11.486Z | 2024-11-12T14:28:12.206Z |
5477485 | 5477485 | 20241104020155_YCXXa | DE0001 | 2024-11-05T14:16:56.912Z | 2024-11-12T14:28:11.847Z |
5477352 | 5477352 | 20241104014118_723V2 | DE0001 | 2024-11-05T14:16:45.911Z | 2024-11-12T14:28:10.937Z |
5477099 | 5477099 | 20241104010056_iyX5o | DE0001 | 2024-11-05T14:16:22.332Z | 2024-11-12T14:28:09.692Z |
5477019 | 5477019 | 20241104005331_vdt2a | DE0001 | 2024-11-05T14:16:17.796Z | 2024-11-12T14:28:08.304Z |
5476935 | 5476935 | 20241104004347_N2qYT | DE0001 | 2024-11-05T14:16:13.087Z | 2024-11-12T14:28:07.923Z |
5476902 | 5476902 | 20241104003955_Me7Mw | DE0001 | 2024-11-05T14:16:11.444Z | 2024-11-12T14:28:07.874Z |
5476818 | 5476818 | 20241104002939_CjiZH | DE0001 | 2024-11-05T14:16:06.345Z | 2024-11-12T14:28:07.582Z |
5476810 | 5476810 | 20241104002753_E0e9h | DE0001 | 2024-11-05T14:16:06.137Z | 2024-11-12T14:28:07.569Z |
5476760 | 5476760 | 20241104001814_3ISHE | DE0001 | 2024-11-05T14:16:03.568Z | 2024-11-12T14:28:07.176Z |
5476729 | 5476729 | 20241104001414_lBykI | DE0001 | 2024-11-05T14:16:00.976Z | 2024-11-12T14:28:07.020Z |
5476657 | 5476657 | 20241104000337_22y6h | DE0001 | 2024-11-05T14:15:49.120Z | 2024-11-12T14:28:06.751Z |
5476571 | 5476571 | 20241103234737_x17OU | DE0001 | 2024-11-05T14:15:41.034Z | 2024-11-12T14:28:06.544Z |
5476558 | 5476558 | 20241103234536_3wGdp | DE0001 | 2024-11-05T14:15:39.798Z | 2024-11-12T14:28:06.521Z |
5476483 | 5476483 | 20241103233255_n20ls | DE0001 | 2024-11-05T14:15:29.595Z | 2024-11-12T14:28:06.255Z |
5476245 | 5476245 | 20241103225244_7K8dt | DE0001 | 2024-11-05T14:14:58.325Z | 2024-11-12T14:28:04.514Z |
5476183 | 5476183 | 20241103223929_i6NLK | DE0001 | 2024-11-05T14:14:50.414Z | 2024-11-12T14:28:03.693Z |
5476179 | 5476179 | 20241103223906_zEfE6 | DE0001 | 2024-11-05T14:14:50.214Z | 2024-11-12T14:28:03.677Z |
5476064 | 5476064 | 20241103221541_gMlfI | DE0001 | 2024-11-05T14:14:42.485Z | 2024-11-12T14:28:02.632Z |
5476049 | 5476049 | 20241103221313_m2r3o | DE0001 | 2024-11-05T14:14:41.655Z | 2024-11-12T14:28:02.508Z |
5475955 | 5475955 | 20241103220026_48NBx | DE0001 | 2024-11-05T14:14:35.725Z | 2024-11-12T14:28:01.898Z |
5475860 | 5475860 | 20241103214220_XWEIr | DE0001 | 2024-11-05T14:14:23.903Z | 2024-11-12T14:28:01.680Z |
5475827 | 5475827 | 20241103213134_X9Hzm | DE0001 | 2024-11-05T14:14:20.071Z | 2024-11-12T14:28:01.251Z |
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);