participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,884 rows where station_code = "DE0009" 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 |
---|---|---|---|---|---|
5484414 | 5484414 | 20241105024745_aA6VJ | DE0009 | 2024-11-06T14:16:53.285Z | 2024-11-09T14:21:13.887Z |
5484170 | 5484170 | 20241105021739_0ss2c | DE0009 | 2024-11-06T14:16:24.817Z | 2024-11-09T14:21:11.567Z |
5484004 | 5484004 | 20241105015426_WxaUV | DE0009 | 2024-11-06T14:16:02.305Z | 2024-11-09T14:21:10.039Z |
5483404 | 5483404 | 20241105003706_kVQFN | DE0009 | 2024-11-06T14:15:12.835Z | 2024-11-09T14:21:05.262Z |
5483261 | 5483261 | 20241105002013_NhnZn | DE0009 | 2024-11-06T14:14:50.956Z | 2024-11-09T14:21:04.464Z |
5482262 | 5482262 | 20241104213951_9qi9o | DE0009 | 2024-11-06T14:12:43.370Z | 2024-11-09T14:20:57.482Z |
5478497 | 5478497 | 20241104041818_pDJi3 | DE0009 | 2024-11-05T14:18:25.852Z | 2024-11-09T14:22:28.565Z |
5478396 | 5478396 | 20241104040156_XD0YN | DE0009 | 2024-11-05T14:18:18.337Z | 2024-11-09T14:22:27.807Z |
5478056 | 5478056 | 20241104031522_0zGfp | DE0009 | 2024-11-05T14:17:48.845Z | 2024-11-09T14:22:24.642Z |
5477965 | 5477965 | 20241104030139_UJv6f | DE0009 | 2024-11-05T14:17:40.628Z | 2024-11-09T14:22:23.140Z |
5476779 | 5476779 | 20241104002104_js2rS | DE0009 | 2024-11-05T14:16:04.358Z | 2024-11-09T14:22:12.329Z |
5476195 | 5476195 | 20241103224059_vm7Pb | DE0009 | 2024-11-05T14:14:51.163Z | 2024-11-09T14:22:06.672Z |
5468414 | 5468414 | 20241103003011_yhKVf | DE0009 | 2024-11-04T14:14:04.555Z | 2024-11-09T14:22:58.290Z |
5442406 | 5442406 | 20241030012551_cDWvu | DE0009 | 2024-11-01T12:19:46.680Z | 2024-11-07T14:26:46.539Z |
5442152 | 5442152 | 20241030004450_fHjTH | DE0009 | 2024-11-01T12:19:30.800Z | 2024-11-07T14:26:45.211Z |
5433774 | 5433774 | 20241024205758_vOwZd | DE0009 | 2024-10-31T12:28:20.483Z | 2024-11-02T12:28:27.747Z |
5433769 | 5433769 | 20241024202405_2142d | DE0009 | 2024-10-31T12:28:18.715Z | 2024-11-02T12:28:27.353Z |
5433288 | 5433288 | 20241029185107_Cg2k5 | DE0009 | 2024-10-31T12:22:04.123Z | 2024-11-07T14:26:37.520Z |
5433146 | 5433146 | 20241029173031_2qVju | DE0009 | 2024-10-31T12:21:52.433Z | 2024-11-07T14:26:35.595Z |
5432785 | 5432785 | 20241029043848_ffjsa | DE0009 | 2024-10-31T12:21:35.001Z | 2024-11-06T14:27:28.706Z |
5432692 | 5432692 | 20241029041850_pqdQu | DE0009 | 2024-10-31T12:21:31.420Z | 2024-11-06T14:27:28.450Z |
5432391 | 5432391 | 20241029032540_QddIc | DE0009 | 2024-10-31T12:21:20.562Z | 2024-11-06T14:27:26.801Z |
5431843 | 5431843 | 20241029020517_eCGJy | DE0009 | 2024-10-31T12:20:43.799Z | 2024-11-06T14:27:25.079Z |
5431744 | 5431744 | 20241029015403_tOQbG | DE0009 | 2024-10-31T12:20:35.848Z | 2024-11-06T14:27:24.657Z |
5431490 | 5431490 | 20241029012002_bzr4i | DE0009 | 2024-10-31T12:20:13.840Z | 2024-11-06T14:27:23.915Z |
5420133 | 5420133 | 20241028020122_EARse | DE0009 | 2024-10-30T12:18:23.593Z | 2024-11-05T14:27:14.638Z |
5419564 | 5419564 | 20241028001841_HUaPI | DE0009 | 2024-10-30T12:17:33.464Z | 2024-11-05T14:27:13.414Z |
5419285 | 5419285 | 20241027233025_jPzM2 | DE0009 | 2024-10-30T12:17:19.085Z | 2024-11-05T14:27:12.697Z |
5419149 | 5419149 | 20241027230736_2oSyP | DE0009 | 2024-10-30T12:17:11.890Z | 2024-11-05T14:27:12.436Z |
5418864 | 5418864 | 20241027221536_i6JbO | DE0009 | 2024-10-30T12:16:24.742Z | 2024-11-05T14:27:11.513Z |
5418750 | 5418750 | 20241027215159_381vA | DE0009 | 2024-10-30T12:16:05.243Z | 2024-11-05T14:27:11.056Z |
5418618 | 5418618 | 20241027212413_vRaBX | DE0009 | 2024-10-30T12:15:53.925Z | 2024-11-05T14:27:10.786Z |
5388088 | 5388088 | 20241025040103_GGIFP | DE0009 | 2024-10-27T12:21:58.725Z | 2024-11-02T12:28:33.741Z |
5385923 | 5385923 | 20241024234429_Koo2p | DE0009 | 2024-10-27T12:19:37.371Z | 2024-11-02T12:28:30.487Z |
5385780 | 5385780 | 20241024232939_OzPSy | DE0009 | 2024-10-27T12:19:22.919Z | 2024-10-30T12:25:08.089Z |
5385172 | 5385172 | 20241024220151_W3WEu | DE0009 | 2024-10-27T12:18:31.921Z | 2024-11-02T12:28:29.232Z |
5385101 | 5385101 | 20241024215051_ZPq8S | DE0009 | 2024-10-27T12:18:23.382Z | 2024-11-02T12:28:29.137Z |
5384832 | 5384832 | 20241024210150_Nogvd | DE0009 | 2024-10-27T12:17:47.945Z | 2024-11-02T12:28:28.408Z |
5366732 | 5366732 | 20241023035331_RAFhh | DE0009 | 2024-10-25T12:21:28.574Z | 2024-10-31T12:30:08.085Z |
5366687 | 5366687 | 20241023033525_AD1qP | DE0009 | 2024-10-25T12:21:25.922Z | 2024-10-31T12:30:07.564Z |
5353983 | 5353983 | 20241023015746_3IvCn | DE0009 | 2024-10-24T12:20:07.594Z | 2024-10-31T12:30:05.225Z |
5352075 | 5352075 | 20241023000859_dY2G3 | DE0009 | 2024-10-24T12:18:18.638Z | 2024-10-31T12:30:01.828Z |
5351460 | 5351460 | 20241022232933_qxfaX | DE0009 | 2024-10-24T12:17:32.788Z | 2024-10-31T12:30:00.388Z |
5348833 | 5348833 | 20241022190139_pqR2o | DE0009 | 2024-10-24T12:12:24.329Z | 2024-10-31T12:29:53.840Z |
5348526 | 5348526 | 20241022182546_Z4aAK | DE0009 | 2024-10-24T12:11:35.167Z | 2024-10-31T12:29:52.845Z |
5327876 | 5327876 | 20241020044019_SW1G5 | DE0009 | 2024-10-21T12:13:16.441Z | 2024-10-28T12:26:47.410Z |
5327782 | 5327782 | 20241020034947_LoNlo | DE0009 | 2024-10-21T12:13:07.560Z | 2024-10-28T12:26:46.744Z |
5327731 | 5327731 | 20241020033652_3AMf3 | DE0009 | 2024-10-21T12:12:58.732Z | 2024-10-28T12:26:46.554Z |
5321812 | 5321812 | 20241013030442_BryvO | DE0009 | 2024-10-19T12:24:02.307Z | 2024-10-21T12:24:18.180Z |
5319971 | 5319971 | 20241017222840_B7QyA | DE0009 | 2024-10-19T12:04:14.261Z | 2024-10-26T12:27:53.792Z |
5294241 | 5294241 | 20241012033052_zlRhg | DE0009 | 2024-10-13T12:18:26.185Z | 2024-10-20T12:25:09.533Z |
5294056 | 5294056 | 20241012025514_VOv8E | DE0009 | 2024-10-13T12:18:13.055Z | 2024-10-20T12:25:06.774Z |
5293998 | 5293998 | 20241012024725_Wm3mK | DE0009 | 2024-10-13T12:18:06.829Z | 2024-10-20T12:25:05.966Z |
5293956 | 5293956 | 20241012024406_uBHE6 | DE0009 | 2024-10-13T12:18:03.888Z | 2024-10-20T12:25:05.510Z |
5293954 | 5293954 | 20241012024356_zAxFZ | DE0009 | 2024-10-13T12:18:03.824Z | 2024-10-20T12:25:05.509Z |
5293843 | 5293843 | 20241012022511_IqGbT | DE0009 | 2024-10-13T12:17:55.706Z | 2024-10-20T12:25:04.337Z |
5293760 | 5293760 | 20241012021418_52zRD | DE0009 | 2024-10-13T12:17:50.450Z | 2024-10-20T12:25:03.680Z |
5293661 | 5293661 | 20241012020352_OUBCd | DE0009 | 2024-10-13T12:17:44.482Z | 2024-10-20T12:25:02.758Z |
5293598 | 5293598 | 20241012015512_QhLc6 | DE0009 | 2024-10-13T12:17:40.251Z | 2024-10-20T12:25:02.264Z |
5293220 | 5293220 | 20241012010622_cBb79 | DE0009 | 2024-10-13T12:17:12.474Z | 2024-10-20T12:24:56.699Z |
5293208 | 5293208 | 20241012010323_PRKMW | DE0009 | 2024-10-13T12:17:11.512Z | 2024-10-20T12:24:56.592Z |
5292993 | 5292993 | 20241012004204_ZCfuv | DE0009 | 2024-10-13T12:16:51.601Z | 2024-10-20T12:24:54.133Z |
5292974 | 5292974 | 20241012003949_jka3c | DE0009 | 2024-10-13T12:16:50.619Z | 2024-10-20T12:24:54.018Z |
5292908 | 5292908 | 20241012003418_YAgVI | DE0009 | 2024-10-13T12:16:43.797Z | 2024-10-20T12:24:53.228Z |
5292394 | 5292394 | 20241011232157_vyceU | DE0009 | 2024-10-13T12:15:57.381Z | 2024-10-20T12:24:44.867Z |
5291823 | 5291823 | 20241011220340_txvTh | DE0009 | 2024-10-13T12:15:17.272Z | 2024-10-20T12:24:36.755Z |
5291818 | 5291818 | 20241011220327_3kyJ7 | DE0009 | 2024-10-13T12:15:16.850Z | 2024-10-20T12:24:36.745Z |
5291632 | 5291632 | 20241011213349_3yWYg | DE0009 | 2024-10-13T12:14:54.779Z | 2024-10-20T12:24:34.093Z |
5291220 | 5291220 | 20241011201948_3xQ1z | DE0009 | 2024-10-13T12:14:08.153Z | 2024-10-20T12:24:28.241Z |
5290711 | 5290711 | 20241011184253_EwY0A | DE0009 | 2024-10-13T12:13:09.535Z | 2024-10-20T12:24:19.204Z |
5285680 | 5285680 | 20241012043540_i3dMy | DE0009 | 2024-10-13T12:00:18.458Z | 2024-10-21T12:22:40.601Z |
5246599 | 5246599 | 20241006020518_cI04n | DE0009 | 2024-10-07T12:16:31.845Z | 2024-10-14T12:24:38.417Z |
5246555 | 5246555 | 20241006015812_2nG0q | DE0009 | 2024-10-07T12:16:30.876Z | 2024-10-14T12:24:38.355Z |
5246466 | 5246466 | 20241006014850_bgMJN | DE0009 | 2024-10-07T12:16:27.227Z | 2024-10-14T12:24:37.976Z |
5246443 | 5246443 | 20241006014558_2Y8Ot | DE0009 | 2024-10-07T12:16:26.565Z | 2024-10-14T12:24:37.963Z |
5246343 | 5246343 | 20241006013542_DC3ms | DE0009 | 2024-10-07T12:16:23.688Z | 2024-10-14T12:24:37.808Z |
5246202 | 5246202 | 20241006011508_RZfdO | DE0009 | 2024-10-07T12:16:17.214Z | 2024-10-14T12:24:37.455Z |
5246132 | 5246132 | 20241006010413_N2LIq | DE0009 | 2024-10-07T12:16:13.722Z | 2024-10-14T12:24:37.241Z |
5246006 | 5246006 | 20241006004427_2n1UL | DE0009 | 2024-10-07T12:16:08.846Z | 2024-10-14T12:24:37.048Z |
5245852 | 5245852 | 20241006001257_2j3u8 | DE0009 | 2024-10-07T12:16:00.218Z | 2024-10-14T12:24:36.511Z |
5245727 | 5245727 | 20241005235557_27tO5 | DE0009 | 2024-10-07T12:15:53.523Z | 2024-10-14T12:24:36.129Z |
5245284 | 5245284 | 20241005223109_tB2Kl | DE0009 | 2024-10-07T12:15:35.592Z | 2024-10-14T12:24:34.911Z |
5245235 | 5245235 | 20241005221916_97lqb | DE0009 | 2024-10-07T12:15:34.071Z | 2024-10-14T12:24:34.772Z |
5244230 | 5244230 | 20241005193401_kJhaf | DE0009 | 2024-10-07T12:14:38.002Z | 2024-10-14T12:24:33.076Z |
5239036 | 5239036 | 20241005032156_toPyj | DE0009 | 2024-10-07T12:05:39.838Z | 2024-10-14T12:24:18.045Z |
5238940 | 5238940 | 20241005031419_p8Nak | DE0009 | 2024-10-07T12:05:29.589Z | 2024-10-14T12:24:17.682Z |
5238368 | 5238368 | 20241005022844_hTrx3 | DE0009 | 2024-10-07T12:04:16.128Z | 2024-10-14T12:24:16.270Z |
5237360 | 5237360 | 20241006035630_RLO79 | DE0009 | 2024-10-07T12:01:24.769Z | 2024-10-15T12:28:41.548Z |
5237059 | 5237059 | 20241006025834_n5DdY | DE0009 | 2024-10-07T12:00:27.330Z | 2024-10-15T12:28:38.440Z |
5235237 | 5235237 | 20241004230932_ZdM6n | DE0009 | 2024-10-06T12:15:56.428Z | 2024-10-13T12:26:24.066Z |
5210082 | 5210082 | 20241001184838_81rsH | DE0009 | 2024-10-03T12:14:30.048Z | 2024-10-10T12:24:45.451Z |
5194729 | 5194729 | 20240930024318_LnhRG | DE0009 | 2024-10-01T12:01:58.384Z | 2024-10-09T12:29:00.813Z |
5192610 | 5192610 | 20240928225342_6OBQt | DE0009 | 2024-09-30T12:18:48.748Z | 2024-10-06T12:28:25.978Z |
5192248 | 5192248 | 20240928221421_ovdNs | DE0009 | 2024-09-30T12:18:32.882Z | 2024-10-06T12:28:25.331Z |
5192053 | 5192053 | 20240928213530_jkYQ0 | DE0009 | 2024-09-30T12:18:23.462Z | 2024-10-06T12:28:24.939Z |
5191489 | 5191489 | 20240928201024_fSOO0 | DE0009 | 2024-09-30T12:17:49.683Z | 2024-10-06T12:28:22.742Z |
5191336 | 5191336 | 20240928194915_pYiQ2 | DE0009 | 2024-09-30T12:17:41.743Z | 2024-10-06T12:28:22.400Z |
5191219 | 5191219 | 20240928192957_Nelqb | DE0009 | 2024-09-30T12:17:34.696Z | 2024-10-06T12:28:22.094Z |
5190999 | 5190999 | 20240928190333_Fcq2q | DE0009 | 2024-09-30T12:17:22.541Z | 2024-10-06T12:28:21.507Z |
5186583 | 5186583 | 20240929042903_LJxbr | DE0009 | 2024-09-30T12:07:20.634Z | 2024-10-07T12:21:20.969Z |
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);