participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,088 rows where station_code = "DE000M" 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 |
---|---|---|---|---|---|
5135655 | 5135655 | 20240914030411_GAnZK | DE000M | 2024-09-19T12:19:59.586Z | 2024-09-20T12:19:00.203Z |
5120576 | 5120576 | 20240914032820_z23NM | DE000M | 2024-09-18T12:10:43.236Z | 2024-09-20T12:19:02.068Z |
5120190 | 5120190 | 20240914030407_SADvz | DE000M | 2024-09-18T12:10:33.885Z | 2024-09-20T12:19:00.177Z |
5120173 | 5120173 | 20240914030354_CtrvC | DE000M | 2024-09-18T12:10:33.605Z | 2024-09-20T12:19:00.148Z |
5120080 | 5120080 | 20240914025856_KgBL8 | DE000M | 2024-09-18T12:10:31.818Z | 2024-09-20T12:18:59.797Z |
5119356 | 5119356 | 20240914022735_My7ON | DE000M | 2024-09-18T12:10:20.509Z | 2024-09-20T12:18:57.568Z |
5113671 | 5113671 | 20240915010501_KMGKK | DE000M | 2024-09-18T12:04:39.142Z | 2024-09-20T12:16:01.160Z |
5113545 | 5113545 | 20240915005745_zlMy0 | DE000M | 2024-09-18T12:04:27.870Z | 2024-09-20T12:15:58.805Z |
5113393 | 5113393 | 20240915004524_rfTc9 | DE000M | 2024-09-18T12:04:13.651Z | 2024-09-20T12:15:55.500Z |
5112946 | 5112946 | 20240915001038_630ac | DE000M | 2024-09-18T12:03:49.549Z | 2024-09-20T12:15:42.204Z |
5112800 | 5112800 | 20240914235647_V2N5Q | DE000M | 2024-09-18T12:03:36.137Z | 2024-09-20T12:15:38.554Z |
5112777 | 5112777 | 20240914235356_a5Yak | DE000M | 2024-09-18T12:03:32.401Z | 2024-09-20T12:15:37.640Z |
5112448 | 5112448 | 20240914231605_9Q8SX | DE000M | 2024-09-18T12:03:07.468Z | 2024-09-20T12:15:30.605Z |
5112366 | 5112366 | 20240914230556_nZ0TC | DE000M | 2024-09-18T12:03:01.476Z | 2024-09-20T12:15:29.380Z |
5112108 | 5112108 | 20240914221552_pvlWj | DE000M | 2024-09-18T12:02:48.158Z | 2024-09-20T12:15:24.783Z |
5111572 | 5111572 | 20240914204927_pYpEg | DE000M | 2024-09-18T12:02:04.077Z | 2024-09-20T12:15:12.661Z |
5106915 | 5106915 | 20240913033834_Q8NT4 | DE000M | 2024-09-17T12:13:03.954Z | 2024-09-20T12:20:42.860Z |
5106374 | 5106374 | 20240913032225_5M5sf | DE000M | 2024-09-17T12:12:51.500Z | 2024-09-20T12:20:41.586Z |
5105711 | 5105711 | 20240913025533_38VWk | DE000M | 2024-09-17T12:12:27.423Z | 2024-09-20T12:20:39.101Z |
5105692 | 5105692 | 20240913025507_ysyxn | DE000M | 2024-09-17T12:12:26.333Z | 2024-09-20T12:20:39.049Z |
5104599 | 5104599 | 20240913021716_vBA2s | DE000M | 2024-09-17T12:11:40.819Z | 2024-09-20T12:20:34.948Z |
5104531 | 5104531 | 20240913021431_jDVCK | DE000M | 2024-09-17T12:11:38.416Z | 2024-09-20T12:20:34.535Z |
5103215 | 5103215 | 20240914020539_EAPia | DE000M | 2024-09-17T12:07:58.984Z | 2024-09-20T12:18:56.235Z |
5103083 | 5103083 | 20240914020041_o3BAE | DE000M | 2024-09-17T12:07:51.353Z | 2024-09-20T12:18:55.826Z |
5098852 | 5098852 | 20240913194956_11jAi | DE000M | 2024-09-17T12:01:48.273Z | 2024-09-20T12:18:10.435Z |
5097971 | 5097971 | 20240913011045_NfJ4V | DE000M | 2024-09-16T12:17:17.448Z | 2024-09-20T12:20:28.987Z |
5097785 | 5097785 | 20240913010429_20v2O | DE000M | 2024-09-16T12:17:14.902Z | 2024-09-20T12:20:27.576Z |
5093093 | 5093093 | 20240912031059_LDP1l | DE000M | 2024-09-16T12:14:11.415Z | 2024-09-20T12:21:52.807Z |
5093044 | 5093044 | 20240912030901_iftFA | DE000M | 2024-09-16T12:14:10.620Z | 2024-09-20T12:21:52.687Z |
5092061 | 5092061 | 20240912023605_hC253 | DE000M | 2024-09-16T12:13:39.679Z | 2024-09-20T12:21:49.742Z |
5090248 | 5090248 | 20240912011827_uAsLR | DE000M | 2024-09-16T12:12:08.833Z | 2024-09-20T12:21:44.742Z |
5089694 | 5089694 | 20240912005340_An7gv | DE000M | 2024-09-16T12:11:37.236Z | 2024-09-20T12:21:43.319Z |
5088838 | 5088838 | 20240913002906_qbLEG | DE000M | 2024-09-16T12:08:32.668Z | 2024-09-20T12:20:23.371Z |
5088676 | 5088676 | 20240913002105_3705H | DE000M | 2024-09-16T12:08:20.130Z | 2024-09-20T12:20:22.904Z |
5087960 | 5087960 | 20240912235046_bge42 | DE000M | 2024-09-16T12:07:38.634Z | 2024-09-20T12:20:19.328Z |
5087764 | 5087764 | 20240912234252_2Db4I | DE000M | 2024-09-16T12:07:25.207Z | 2024-09-20T12:20:18.684Z |
5086759 | 5086759 | 20240912224703_aL5sW | DE000M | 2024-09-16T12:06:01.454Z | 2024-09-20T12:20:12.341Z |
5084597 | 5084597 | 20240912195501_zP2c3 | DE000M | 2024-09-16T12:02:37.033Z | 2024-09-20T12:19:56.519Z |
5075838 | 5075838 | 20240912000954_A8bJx | DE000M | 2024-09-15T12:10:17.965Z | 2024-09-20T12:21:41.168Z |
5075804 | 5075804 | 20240912000832_qCo8B | DE000M | 2024-09-15T12:10:15.106Z | 2024-09-20T12:21:41.106Z |
5075764 | 5075764 | 20240912000548_GzwQi | DE000M | 2024-09-15T12:10:12.338Z | 2024-09-20T12:21:41.051Z |
5075754 | 5075754 | 20240912000524_Bhm6g | DE000M | 2024-09-15T12:10:11.418Z | 2024-09-20T12:21:40.909Z |
5075531 | 5075531 | 20240911235323_t2a0a | DE000M | 2024-09-15T12:09:59.233Z | 2024-09-20T12:21:40.197Z |
5075520 | 5075520 | 20240911235254_ovN5e | DE000M | 2024-09-15T12:09:58.160Z | 2024-09-20T12:21:40.179Z |
4991345 | 4991345 | 20240901022329_Cr0F5 | DE000M | 2024-09-07T12:11:57.636Z | 2024-09-09T12:27:05.917Z |
4991334 | 4991334 | 20240901022139_SArts | DE000M | 2024-09-07T12:11:56.934Z | 2024-09-09T12:27:05.632Z |
4991021 | 4991021 | 20240901014843_EEMVN | DE000M | 2024-09-07T12:11:29.082Z | 2024-09-09T12:26:58.169Z |
4990854 | 4990854 | 20240901012127_bbvd0 | DE000M | 2024-09-07T12:11:13.497Z | 2024-09-09T12:26:49.332Z |
4990672 | 4990672 | 20240901005206_nYEUH | DE000M | 2024-09-07T12:10:54.351Z | 2024-09-09T12:26:27.374Z |
4990532 | 4990532 | 20240901002923_lemdt | DE000M | 2024-09-07T12:10:44.248Z | 2024-09-09T12:26:22.826Z |
4990466 | 4990466 | 20240901001912_4WJyU | DE000M | 2024-09-07T12:10:39.737Z | 2024-09-09T12:26:20.340Z |
4990390 | 4990390 | 20240901001053_aFHL4 | DE000M | 2024-09-07T12:10:29.244Z | 2024-09-09T12:26:18.523Z |
4990378 | 4990378 | 20240901000902_HRU0I | DE000M | 2024-09-07T12:10:28.215Z | 2024-09-09T12:26:18.167Z |
4990376 | 4990376 | 20240901000842_KIz1T | DE000M | 2024-09-07T12:10:28.007Z | 2024-09-09T12:26:18.068Z |
4990371 | 4990371 | 20240901000823_gMIsb | DE000M | 2024-09-07T12:10:27.663Z | 2024-09-09T12:26:17.949Z |
4990312 | 4990312 | 20240901000118_ub19t | DE000M | 2024-09-07T12:10:20.113Z | 2024-09-09T12:26:16.231Z |
4990201 | 4990201 | 20240831234139_b3Vnf | DE000M | 2024-09-07T12:10:10.410Z | 2024-09-09T12:26:13.287Z |
4983308 | 4983308 | 20240812004312_xBOfd | DE000M | 2024-09-06T12:15:26.119Z | 2024-09-06T12:15:26.119Z |
4983141 | 4983141 | 20240812004146_V5Hkh | DE000M | 2024-09-06T12:15:16.990Z | 2024-09-06T12:15:16.990Z |
4983099 | 4983099 | 20240812004124_ppUNw | DE000M | 2024-09-06T12:15:15.530Z | 2024-09-06T12:15:15.530Z |
4981835 | 4981835 | 20240812002740_Z2pc2 | DE000M | 2024-09-06T12:14:38.769Z | 2024-09-06T12:14:38.769Z |
4981643 | 4981643 | 20240812002445_IAiVp | DE000M | 2024-09-06T12:14:34.848Z | 2024-09-06T12:14:34.848Z |
4980913 | 4980913 | 20240812001658_Ow0qt | DE000M | 2024-09-06T12:14:23.899Z | 2024-09-06T12:14:23.899Z |
4980848 | 4980848 | 20240812001630_dvoNm | DE000M | 2024-09-06T12:14:20.514Z | 2024-09-06T12:14:20.514Z |
4980381 | 4980381 | 20240812001144_bApwf | DE000M | 2024-09-06T12:13:57.331Z | 2024-09-06T12:13:57.331Z |
4979936 | 4979936 | 20240812000629_Lwjo1 | DE000M | 2024-09-06T12:13:36.156Z | 2024-09-06T12:13:36.156Z |
4979728 | 4979728 | 20240812000359_Peh3b | DE000M | 2024-09-06T12:13:24.392Z | 2024-09-06T12:13:24.392Z |
4979680 | 4979680 | 20240812000331_h5fks | DE000M | 2024-09-06T12:13:22.249Z | 2024-09-06T12:13:22.249Z |
4978693 | 4978693 | 20240811235408_xCPHP | DE000M | 2024-09-06T12:12:41.068Z | 2024-09-06T12:12:41.068Z |
4977463 | 4977463 | 20240811234003_vunoA | DE000M | 2024-09-06T12:12:17.615Z | 2024-09-06T12:12:17.615Z |
4977443 | 4977443 | 20240811233941_LeOwh | DE000M | 2024-09-06T12:12:16.495Z | 2024-09-06T12:12:16.495Z |
4976898 | 4976898 | 20240811233439_WkpPB | DE000M | 2024-09-06T12:11:56.676Z | 2024-09-06T12:11:56.676Z |
4976315 | 4976315 | 20240811232855_Bgw5J | DE000M | 2024-09-06T12:11:25.429Z | 2024-09-06T12:11:25.429Z |
4976261 | 4976261 | 20240811232748_Tl8J9 | DE000M | 2024-09-06T12:11:21.411Z | 2024-09-06T12:11:21.411Z |
4975992 | 4975992 | 20240811232425_E2rMg | DE000M | 2024-09-06T12:11:00.883Z | 2024-09-06T12:11:00.883Z |
4975553 | 4975553 | 20240811231931_KsFw3 | DE000M | 2024-09-06T12:10:44.273Z | 2024-09-06T12:10:44.273Z |
4975158 | 4975158 | 20240811231540_bFsM7 | DE000M | 2024-09-05T12:11:41.225Z | 2024-09-06T12:10:38.246Z |
4975010 | 4975010 | 20240811231339_abEbB | DE000M | 2024-09-05T12:11:38.539Z | 2024-09-06T12:10:36.036Z |
4974891 | 4974891 | 20240811231240_oh2PU | DE000M | 2024-09-05T12:11:34.828Z | 2024-09-06T12:10:34.282Z |
4973801 | 4973801 | 20240811230018_RUuI6 | DE000M | 2024-09-05T12:11:10.567Z | 2024-09-06T12:10:05.567Z |
4973368 | 4973368 | 20240811225605_3Bu1h | DE000M | 2024-09-05T12:10:49.225Z | 2024-09-06T12:09:53.243Z |
4972595 | 4972595 | 20240811224823_pJ2ZQ | DE000M | 2024-09-05T12:10:28.863Z | 2024-09-06T12:09:19.622Z |
4972474 | 4972474 | 20240811224633_EFSpc | DE000M | 2024-09-05T12:10:25.624Z | 2024-09-06T12:09:14.375Z |
4970107 | 4970107 | 20240811222104_SX4B8 | DE000M | 2024-09-05T12:09:18.885Z | 2024-09-06T12:08:22.798Z |
4970027 | 4970027 | 20240811222006_sLLNO | DE000M | 2024-09-05T12:09:16.802Z | 2024-09-06T12:08:17.646Z |
4969254 | 4969254 | 20240811220835_O0S2f | DE000M | 2024-09-05T12:08:38.427Z | 2024-09-06T12:07:46.490Z |
4969020 | 4969020 | 20240811220603_8pGOL | DE000M | 2024-09-05T12:08:33.960Z | 2024-09-06T12:07:41.694Z |
4968982 | 4968982 | 20240811220532_oJKsU | DE000M | 2024-09-05T12:08:32.837Z | 2024-09-06T12:07:40.763Z |
4968877 | 4968877 | 20240811220349_DaZh7 | DE000M | 2024-09-05T12:08:29.149Z | 2024-09-06T12:07:37.997Z |
4967419 | 4967419 | 20240811214418_0IrVJ | DE000M | 2024-09-05T12:07:38.570Z | 2024-09-06T12:06:59.498Z |
4967344 | 4967344 | 20240811214239_BGzTY | DE000M | 2024-09-05T12:07:35.949Z | 2024-09-06T12:06:57.215Z |
4966811 | 4966811 | 20240811213351_QzlRa | DE000M | 2024-09-05T12:07:14.900Z | 2024-09-06T12:06:47.859Z |
4965995 | 4965995 | 20240811212144_29A7J | DE000M | 2024-09-04T12:07:15.834Z | 2024-09-06T12:06:09.157Z |
4965958 | 4965958 | 20240811212135_T5W50 | DE000M | 2024-09-04T12:07:13.308Z | 2024-09-06T12:06:08.646Z |
4965521 | 4965521 | 20240811211609_W81Rk | DE000M | 2024-09-04T12:07:00.002Z | 2024-09-06T12:05:58.806Z |
4964750 | 4964750 | 20240811210245_jeypm | DE000M | 2024-09-04T12:06:33.163Z | 2024-09-06T12:05:34.168Z |
4964616 | 4964616 | 20240811205922_elVB5 | DE000M | 2024-09-04T12:06:29.372Z | 2024-09-06T12:05:26.466Z |
4964480 | 4964480 | 20240811205547_NYW9d | DE000M | 2024-09-04T12:06:23.359Z | 2024-09-06T12:05:21.918Z |
4853401 | 4853401 | 20240805225442_1O02t | DE000M | 2024-08-17T12:17:20.381Z | 2024-08-19T12:24:57.423Z |
4853110 | 4853110 | 20240805223659_J2KRU | DE000M | 2024-08-17T12:16:58.619Z | 2024-08-19T12:24:42.067Z |
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);