participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,731 rows where station_code = "DE0005" 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 |
---|---|---|---|---|---|
5570569 | 5570569 | 20241120201205_at7I7 | DE0005 | 2024-11-22T14:15:48.661Z | 2024-11-22T14:19:21.940Z |
5570408 | 5570408 | 20241120193355_M3JXk | DE0005 | 2024-11-22T14:15:19.848Z | 2024-11-22T14:19:21.912Z |
5563515 | 5563515 | 20241120013744_ltWLr | DE0005 | 2024-11-21T14:16:14.501Z | 2024-11-22T14:21:17.171Z |
5558083 | 5558083 | 20241120053610_Jeqhl | DE0005 | 2024-11-21T14:02:29.261Z | 2024-11-22T14:19:21.176Z |
5485297 | 5485297 | 20241105044121_qNhQV | DE0005 | 2024-11-06T14:18:04.319Z | 2024-11-13T14:27:41.577Z |
5485247 | 5485247 | 20241105043004_TXd9S | DE0005 | 2024-11-06T14:17:58.886Z | 2024-11-13T14:27:41.414Z |
5485232 | 5485232 | 20241105042654_B3abf | DE0005 | 2024-11-06T14:17:57.309Z | 2024-11-13T14:27:41.018Z |
5485163 | 5485163 | 20241105041327_xK3Bi | DE0005 | 2024-11-06T14:17:50.889Z | 2024-11-13T14:27:40.889Z |
5484865 | 5484865 | 20241105033506_C3BtF | DE0005 | 2024-11-06T14:17:24.009Z | 2024-11-13T14:27:39.998Z |
5484691 | 5484691 | 20241105032018_ICuw4 | DE0005 | 2024-11-06T14:17:10.189Z | 2024-11-13T14:27:39.347Z |
5484662 | 5484662 | 20241105031817_Q2f0O | DE0005 | 2024-11-06T14:17:08.521Z | 2024-11-13T14:27:39.035Z |
5484203 | 5484203 | 20241105021959_nuK3V | DE0005 | 2024-11-06T14:16:31.757Z | 2024-11-13T14:27:37.526Z |
5484187 | 5484187 | 20241105021847_xmVYK | DE0005 | 2024-11-06T14:16:29.187Z | 2024-11-13T14:27:37.483Z |
5484107 | 5484107 | 20241105021012_nmPFB | DE0005 | 2024-11-06T14:16:16.839Z | 2024-11-13T14:27:37.295Z |
5483588 | 5483588 | 20241105010039_9yOQC | DE0005 | 2024-11-06T14:15:30.083Z | 2024-11-13T14:27:36.450Z |
5483516 | 5483516 | 20241105005112_eu7Gn | DE0005 | 2024-11-06T14:15:26.103Z | 2024-11-13T14:27:36.349Z |
5483055 | 5483055 | 20241104235131_EQnYd | DE0005 | 2024-11-06T14:14:37.035Z | 2024-11-13T14:27:35.635Z |
5482816 | 5482816 | 20241104231714_rWTIK | DE0005 | 2024-11-06T14:14:05.981Z | 2024-11-13T14:27:35.208Z |
5482788 | 5482788 | 20241104231447_RRtPf | DE0005 | 2024-11-06T14:14:00.148Z | 2024-11-13T14:27:35.139Z |
5482149 | 5482149 | 20241104211443_dRKin | DE0005 | 2024-11-06T14:12:28.399Z | 2024-11-13T14:27:34.006Z |
5481558 | 5481558 | 20241104182544_lB5Ec | DE0005 | 2024-11-06T14:10:48.741Z | 2024-11-13T14:27:30.510Z |
5478694 | 5478694 | 20241104051010_kwlNR | DE0005 | 2024-11-05T14:18:42.427Z | 2024-11-12T14:28:16.566Z |
5478529 | 5478529 | 20241104042608_hjMYG | DE0005 | 2024-11-05T14:18:28.517Z | 2024-11-12T14:28:15.832Z |
5478502 | 5478502 | 20241104041954_vfA6x | DE0005 | 2024-11-05T14:18:26.287Z | 2024-11-12T14:28:15.737Z |
5478472 | 5478472 | 20241104041603_VSGAS | DE0005 | 2024-11-05T14:18:24.217Z | 2024-11-12T14:28:15.557Z |
5478437 | 5478437 | 20241104041121_A3uH9 | DE0005 | 2024-11-05T14:18:22.731Z | 2024-11-12T14:28:15.403Z |
5478372 | 5478372 | 20241104035827_EyhKi | DE0005 | 2024-11-05T14:18:16.356Z | 2024-11-12T14:28:15.037Z |
5478280 | 5478280 | 20241104034548_ZwmTS | DE0005 | 2024-11-05T14:18:09.133Z | 2024-11-12T14:28:14.793Z |
5478225 | 5478225 | 20241104033919_Jhrha | DE0005 | 2024-11-05T14:18:05.095Z | 2024-11-12T14:28:14.628Z |
5477908 | 5477908 | 20241104025253_rffw4 | DE0005 | 2024-11-05T14:17:35.859Z | 2024-11-12T14:28:13.214Z |
5477649 | 5477649 | 20241104021717_lw8Qe | DE0005 | 2024-11-05T14:17:12.537Z | 2024-11-12T14:28:12.234Z |
5477625 | 5477625 | 20241104021536_3jnUu | DE0005 | 2024-11-05T14:17:10.126Z | 2024-11-12T14:28:12.178Z |
5477615 | 5477615 | 20241104021333_DvCWC | DE0005 | 2024-11-05T14:17:09.473Z | 2024-11-12T14:28:12.150Z |
5477323 | 5477323 | 20241104013642_zYD1N | DE0005 | 2024-11-05T14:16:43.479Z | 2024-11-12T14:28:10.692Z |
5477258 | 5477258 | 20241104012755_RsEIh | DE0005 | 2024-11-05T14:16:38.008Z | 2024-11-12T14:28:10.462Z |
5477078 | 5477078 | 20241104005817_kQl1T | DE0005 | 2024-11-05T14:16:20.935Z | 2024-11-12T14:28:08.524Z |
5477016 | 5477016 | 20241104005250_ywSp1 | DE0005 | 2024-11-05T14:16:17.664Z | 2024-11-12T14:28:08.277Z |
5476282 | 5476282 | 20241103225835_rh74E | DE0005 | 2024-11-05T14:15:00.055Z | 2024-11-12T14:28:04.853Z |
5475981 | 5475981 | 20241103220357_ylFa2 | DE0005 | 2024-11-05T14:14:37.206Z | 2024-11-12T14:28:02.007Z |
5475637 | 5475637 | 20241103205413_kOuuc | DE0005 | 2024-11-05T14:13:55.174Z | 2024-11-12T14:28:00.119Z |
5475458 | 5475458 | 20241103200942_OfNb2 | DE0005 | 2024-11-05T14:13:41.416Z | 2024-11-12T14:27:58.653Z |
5475028 | 5475028 | 20241103185239_VO73M | DE0005 | 2024-11-05T14:12:25.898Z | 2024-11-12T14:27:56.501Z |
5474682 | 5474682 | 20241103175843_jAeM3 | DE0005 | 2024-11-05T14:11:34.337Z | 2024-11-12T14:27:53.872Z |
5474624 | 5474624 | 20241103174946_391us | DE0005 | 2024-11-05T14:11:24.753Z | 2024-11-12T14:27:53.543Z |
5470011 | 5470011 | 20241103050919_RrNJ2 | DE0005 | 2024-11-04T14:17:34.322Z | 2024-11-11T14:23:03.510Z |
5442816 | 5442816 | 20241030023751_X2zQb | DE0005 | 2024-11-01T12:20:09.512Z | 2024-11-07T14:26:48.475Z |
5442814 | 5442814 | 20241030023739_Ph9PZ | DE0005 | 2024-11-01T12:20:09.443Z | 2024-11-07T14:26:48.398Z |
5441964 | 5441964 | 20241030001111_FiBPl | DE0005 | 2024-11-01T12:19:14.711Z | 2024-11-07T14:26:44.423Z |
5433751 | 5433751 | 20241027222600_ou85T | DE0005 | 2024-10-31T12:24:19.784Z | 2024-11-05T14:27:11.757Z |
5433515 | 5433515 | 20241029201252_Rar6T | DE0005 | 2024-10-31T12:22:19.328Z | 2024-11-07T14:26:40.060Z |
5433216 | 5433216 | 20241029181744_NjX4q | DE0005 | 2024-10-31T12:21:58.578Z | 2024-11-07T14:26:36.660Z |
5432344 | 5432344 | 20241029031726_IrAjP | DE0005 | 2024-10-31T12:21:18.540Z | 2024-11-06T14:27:26.738Z |
5432216 | 5432216 | 20241029025525_l1g9X | DE0005 | 2024-10-31T12:21:13.218Z | 2024-11-06T14:27:26.262Z |
5432170 | 5432170 | 20241029025202_RtKH8 | DE0005 | 2024-10-31T12:21:09.206Z | 2024-11-06T14:27:26.163Z |
5432086 | 5432086 | 20241029024113_h5ovA | DE0005 | 2024-10-31T12:21:02.072Z | 2024-11-06T14:27:25.954Z |
5431644 | 5431644 | 20241029014053_lHp4t | DE0005 | 2024-10-31T12:20:28.143Z | 2024-11-06T14:27:24.347Z |
5431422 | 5431422 | 20241029010933_9Ye36 | DE0005 | 2024-10-31T12:20:07.338Z | 2024-11-06T14:27:23.596Z |
5418658 | 5418658 | 20241027212944_sGRNk | DE0005 | 2024-10-30T12:15:57.766Z | 2024-11-05T14:27:10.902Z |
5402544 | 5402544 | 20241026195412_grPx6 | DE0005 | 2024-10-29T12:07:37.474Z | 2024-11-04T14:28:45.124Z |
5402303 | 5402303 | 20241026191341_q9lTs | DE0005 | 2024-10-29T12:06:57.979Z | 2024-11-04T14:28:43.652Z |
5401835 | 5401835 | 20241026174326_391VQ | DE0005 | 2024-10-29T12:05:27.658Z | 2024-11-04T14:28:39.736Z |
5398111 | 5398111 | 20241026022714_RmrUP | DE0005 | 2024-10-28T12:19:01.237Z | 2024-11-03T14:27:35.450Z |
5397944 | 5397944 | 20241026020907_MVt36 | DE0005 | 2024-10-28T12:18:51.765Z | 2024-11-03T14:27:34.618Z |
5397793 | 5397793 | 20241026015848_apEpU | DE0005 | 2024-10-28T12:18:42.991Z | 2024-11-03T14:27:34.154Z |
5397656 | 5397656 | 20241026014551_RkKyj | DE0005 | 2024-10-28T12:18:31.044Z | 2024-11-03T14:27:33.678Z |
5397353 | 5397353 | 20241026012103_fUQJn | DE0005 | 2024-10-28T12:18:17.606Z | 2024-11-03T14:27:32.725Z |
5397251 | 5397251 | 20241026011318_pi2lc | DE0005 | 2024-10-28T12:18:13.153Z | 2024-11-03T14:27:32.451Z |
5396967 | 5396967 | 20241026005121_RUtFH | DE0005 | 2024-10-28T12:18:01.106Z | 2024-11-03T14:27:31.581Z |
5396926 | 5396926 | 20241026004712_A13W4 | DE0005 | 2024-10-28T12:17:59.645Z | 2024-11-03T14:27:31.371Z |
5396863 | 5396863 | 20241026004300_QrubP | DE0005 | 2024-10-28T12:17:58.271Z | 2024-11-03T14:27:31.273Z |
5396788 | 5396788 | 20241026003431_c8733 | DE0005 | 2024-10-28T12:17:55.586Z | 2024-11-03T14:27:30.899Z |
5396693 | 5396693 | 20241026002401_mckft | DE0005 | 2024-10-28T12:17:53.431Z | 2024-11-03T14:27:30.704Z |
5396591 | 5396591 | 20241026001457_GnRmE | DE0005 | 2024-10-28T12:17:50.489Z | 2024-11-03T14:27:30.406Z |
5396584 | 5396584 | 20241026001428_QE80Y | DE0005 | 2024-10-28T12:17:50.308Z | 2024-11-03T14:27:30.395Z |
5396108 | 5396108 | 20241025234101_O8GSB | DE0005 | 2024-10-28T12:17:18.652Z | 2024-11-03T14:27:28.538Z |
5396097 | 5396097 | 20241025234026_zLC0v | DE0005 | 2024-10-28T12:17:18.344Z | 2024-11-03T14:27:28.522Z |
5396076 | 5396076 | 20241025233745_dTE3x | DE0005 | 2024-10-28T12:17:17.536Z | 2024-11-03T14:27:28.363Z |
5396037 | 5396037 | 20241025233409_3SAcJ | DE0005 | 2024-10-28T12:17:14.499Z | 2024-11-03T14:27:28.169Z |
5396002 | 5396002 | 20241025232914_igGrc | DE0005 | 2024-10-28T12:17:10.107Z | 2024-11-03T14:27:27.959Z |
5395898 | 5395898 | 20241025232019_uHLht | DE0005 | 2024-10-28T12:17:04.257Z | 2024-11-03T14:27:27.568Z |
5395880 | 5395880 | 20241025231741_TXlSS | DE0005 | 2024-10-28T12:17:02.928Z | 2024-11-03T14:27:27.518Z |
5395816 | 5395816 | 20241025231244_N9bt8 | DE0005 | 2024-10-28T12:16:54.861Z | 2024-11-03T14:27:26.711Z |
5395799 | 5395799 | 20241025231053_2y3ah | DE0005 | 2024-10-28T12:16:52.599Z | 2024-11-03T14:27:26.700Z |
5395758 | 5395758 | 20241025230910_amt87 | DE0005 | 2024-10-28T12:16:46.916Z | 2024-11-03T14:27:26.657Z |
5395740 | 5395740 | 20241025230722_1HOp0 | DE0005 | 2024-10-28T12:16:44.762Z | 2024-11-03T14:27:26.586Z |
5395668 | 5395668 | 20241025230345_265KH | DE0005 | 2024-10-28T12:16:38.055Z | 2024-11-03T14:27:26.383Z |
5395463 | 5395463 | 20241025224500_xLd5e | DE0005 | 2024-10-28T12:16:16.514Z | 2024-11-03T14:27:25.591Z |
5395367 | 5395367 | 20241025223629_uVluJ | DE0005 | 2024-10-28T12:16:10.986Z | 2024-11-03T14:27:25.228Z |
5395257 | 5395257 | 20241025222833_HB81y | DE0005 | 2024-10-28T12:16:03.572Z | 2024-11-03T14:27:24.452Z |
5394818 | 5394818 | 20241025213031_OzUby | DE0005 | 2024-10-28T12:15:29.131Z | 2024-11-03T14:27:22.824Z |
5394740 | 5394740 | 20241025211753_UtJ2d | DE0005 | 2024-10-28T12:15:20.916Z | 2024-11-03T14:27:22.460Z |
5394024 | 5394024 | 20241025192540_TmpgR | DE0005 | 2024-10-28T12:13:59.380Z | 2024-11-03T14:27:19.623Z |
5393962 | 5393962 | 20241025191942_95unk | DE0005 | 2024-10-28T12:13:55.827Z | 2024-11-03T14:27:19.366Z |
5388104 | 5388104 | 20241025040342_1YObW | DE0005 | 2024-10-27T12:21:59.733Z | 2024-11-02T12:28:33.747Z |
5387971 | 5387971 | 20241025034827_gIdk3 | DE0005 | 2024-10-27T12:21:51.126Z | 2024-11-02T12:28:33.510Z |
5387816 | 5387816 | 20241025032537_c04Xt | DE0005 | 2024-10-27T12:21:41.926Z | 2024-11-02T12:28:33.309Z |
5387779 | 5387779 | 20241025032117_ohOkI | DE0005 | 2024-10-27T12:21:39.902Z | 2024-11-02T12:28:33.246Z |
5387510 | 5387510 | 20241025024715_Ym6S9 | DE0005 | 2024-10-27T12:21:26.114Z | 2024-11-02T12:28:32.664Z |
5387498 | 5387498 | 20241025024621_lLUkz | DE0005 | 2024-10-27T12:21:25.742Z | 2024-11-02T12:28:32.650Z |
5386544 | 5386544 | 20241025010019_hFFzh | DE0005 | 2024-10-27T12:20:10.080Z | 2024-11-02T12:28:31.334Z |
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);