participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
69 rows where station_code = "IE000M" 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 |
---|---|---|---|---|---|
5431997 | 5431997 | 20241029022847_CCEoq | IE000M | 2024-10-31T12:20:55.750Z | 2024-11-06T14:27:25.680Z |
5404567 | 5404567 | 20241026233828_rtpDu | IE000M | 2024-10-29T12:11:43.465Z | 2024-11-04T14:28:51.337Z |
5404047 | 5404047 | 20241026225451_yFFjL | IE000M | 2024-10-29T12:10:50.683Z | 2024-11-04T14:28:50.269Z |
5404015 | 5404015 | 20241026225303_S0K36 | IE000M | 2024-10-29T12:10:47.845Z | 2024-11-04T14:28:50.219Z |
5402802 | 5402802 | 20241026202736_W3UBC | IE000M | 2024-10-29T12:08:10.966Z | 2024-11-04T14:28:46.614Z |
5399782 | 5399782 | 20241026050217_EV6q3 | IE000M | 2024-10-28T12:20:11.091Z | 2024-11-03T14:27:40.510Z |
5399435 | 5399435 | 20241026041824_5KRJa | IE000M | 2024-10-28T12:19:59.470Z | 2024-11-03T14:27:39.708Z |
5397433 | 5397433 | 20241026012948_c3LLv | IE000M | 2024-10-28T12:18:21.760Z | 2024-11-03T14:27:32.916Z |
5397409 | 5397409 | 20241026012650_Yq5SP | IE000M | 2024-10-28T12:18:20.412Z | 2024-11-03T14:27:32.805Z |
5349590 | 5349590 | 20241022201530_9XGp6 | IE000M | 2024-10-24T12:14:06.756Z | 2024-10-31T12:29:55.884Z |
5344224 | 5344224 | 20241022041117_1p6js | IE000M | 2024-10-23T12:18:28.968Z | 2024-10-30T12:26:51.065Z |
5344210 | 5344210 | 20241022041028_Mt5xo | IE000M | 2024-10-23T12:18:28.187Z | 2024-10-30T12:26:51.017Z |
5340965 | 5340965 | 20241022010529_8Wwkx | IE000M | 2024-10-23T12:15:06.102Z | 2024-10-30T12:26:46.451Z |
5340934 | 5340934 | 20241022010148_gQXkG | IE000M | 2024-10-23T12:15:04.034Z | 2024-10-30T12:26:46.367Z |
5335567 | 5335567 | 20241021054237_J8U4D | IE000M | 2024-10-22T12:18:18.450Z | 2024-10-29T12:26:36.502Z |
5335375 | 5335375 | 20241021045011_BgAK3 | IE000M | 2024-10-22T12:18:10.138Z | 2024-10-29T12:26:36.222Z |
5335323 | 5335323 | 20241021043511_2EmYo | IE000M | 2024-10-22T12:18:08.202Z | 2024-10-29T12:26:36.181Z |
5334193 | 5334193 | 20241021020616_29xlq | IE000M | 2024-10-22T12:16:25.565Z | 2024-10-29T12:26:34.940Z |
5323323 | 5323323 | 20241019005307_lvsh4 | IE000M | 2024-10-20T12:05:45.857Z | 2024-10-27T12:28:50.533Z |
5323264 | 5323264 | 20241018235012_X6OTP | IE000M | 2024-10-20T12:05:34.021Z | 2024-10-27T12:28:50.126Z |
5323180 | 5323180 | 20241018223346_i2Fob | IE000M | 2024-10-20T12:05:22.271Z | 2024-10-27T12:28:49.708Z |
5313290 | 5313290 | 20241014044747_R79oi | IE000M | 2024-10-16T12:14:04.056Z | 2024-10-22T12:24:45.916Z |
5313269 | 5313269 | 20241014043431_Ev5W3 | IE000M | 2024-10-16T12:14:01.702Z | 2024-10-22T12:24:45.262Z |
5313224 | 5313224 | 20241014040840_DNscN | IE000M | 2024-10-16T12:13:57.169Z | 2024-10-22T12:24:44.545Z |
5313153 | 5313153 | 20241014033024_Ti2O2 | IE000M | 2024-10-16T12:13:47.211Z | 2024-10-22T12:24:41.877Z |
5313152 | 5313152 | 20241014033006_9g4B2 | IE000M | 2024-10-16T12:13:47.148Z | 2024-10-22T12:24:41.874Z |
5313138 | 5313138 | 20241014032402_xb6rV | IE000M | 2024-10-16T12:13:45.619Z | 2024-10-22T12:24:41.728Z |
5313131 | 5313131 | 20241014032032_3BVE3 | IE000M | 2024-10-16T12:13:44.574Z | 2024-10-22T12:24:41.583Z |
5307880 | 5307880 | 20241014053029_93HuM | IE000M | 2024-10-16T12:02:32.824Z | 2024-10-23T12:24:09.917Z |
5307863 | 5307863 | 20241014051456_UON6v | IE000M | 2024-10-16T12:02:27.172Z | 2024-10-23T12:24:09.044Z |
5307860 | 5307860 | 20241014051352_FmxD0 | IE000M | 2024-10-16T12:02:26.621Z | 2024-10-23T12:24:09.038Z |
5294397 | 5294397 | 20241012035814_Rm1R6 | IE000M | 2024-10-13T12:18:34.571Z | 2024-10-20T12:25:11.719Z |
5294340 | 5294340 | 20241012034621_BnbGQ | IE000M | 2024-10-13T12:18:31.432Z | 2024-10-20T12:25:10.353Z |
5293948 | 5293948 | 20241012024308_6fy31 | IE000M | 2024-10-13T12:18:03.153Z | 2024-10-20T12:25:05.377Z |
5293891 | 5293891 | 20241012023508_rYZ5p | IE000M | 2024-10-13T12:17:58.221Z | 2024-10-20T12:25:04.976Z |
5292875 | 5292875 | 20241012003003_j9Ll4 | IE000M | 2024-10-13T12:16:40.133Z | 2024-10-20T12:24:53.065Z |
5292449 | 5292449 | 20241011233347_C3C3N | IE000M | 2024-10-13T12:16:01.438Z | 2024-10-20T12:24:46.052Z |
5285543 | 5285543 | 20241011040400_5QEXj | IE000M | 2024-10-12T12:18:14.189Z | 2024-10-19T12:28:03.487Z |
5285028 | 5285028 | 20241011032819_vM3lb | IE000M | 2024-10-12T12:17:49.699Z | 2024-10-19T12:27:59.748Z |
5284549 | 5284549 | 20241011025229_1IIIf | IE000M | 2024-10-12T12:17:27.650Z | 2024-10-19T12:27:56.150Z |
5284087 | 5284087 | 20241011022039_5BOel | IE000M | 2024-10-12T12:17:07.630Z | 2024-10-19T12:27:53.954Z |
5283722 | 5283722 | 20241011014712_E9QZs | IE000M | 2024-10-12T12:16:53.972Z | 2024-10-19T12:27:52.605Z |
5283683 | 5283683 | 20241011014447_4TOqq | IE000M | 2024-10-12T12:16:50.932Z | 2024-10-19T12:27:52.413Z |
5283625 | 5283625 | 20241011014004_9wmjq | IE000M | 2024-10-12T12:16:48.547Z | 2024-10-19T12:27:52.260Z |
5283308 | 5283308 | 20241011011132_5JDuU | IE000M | 2024-10-12T12:16:35.565Z | 2024-10-19T12:27:50.377Z |
5282611 | 5282611 | 20241010223536_29923 | IE000M | 2024-10-12T12:15:47.295Z | 2024-10-19T12:27:44.879Z |
5269442 | 5269442 | 20241010053004_l4TWa | IE000M | 2024-10-11T12:01:44.601Z | 2024-10-19T12:26:50.403Z |
5269302 | 5269302 | 20241010050516_fPoZg | IE000M | 2024-10-11T12:01:12.637Z | 2024-10-19T12:26:48.979Z |
5269056 | 5269056 | 20241010040641_32uKX | IE000M | 2024-10-11T12:00:22.733Z | 2024-10-19T12:26:46.325Z |
5215558 | 5215558 | 20241002233818_GxR3V | IE000M | 2024-10-04T12:11:59.697Z | 2024-10-11T12:23:35.525Z |
5205420 | 5205420 | 20240930234230_zMyM7 | IE000M | 2024-10-02T12:12:42.093Z | 2024-10-09T12:29:16.288Z |
5205147 | 5205147 | 20240930221529_x60ig | IE000M | 2024-10-02T12:12:24.488Z | 2024-10-09T12:29:15.581Z |
5204360 | 5204360 | 20240930194055_Kuc7f | IE000M | 2024-10-02T12:11:30.145Z | 2024-10-09T12:29:13.833Z |
5200991 | 5200991 | 20241001044539_dpV3h | IE000M | 2024-10-02T12:03:26.587Z | 2024-10-10T12:24:33.245Z |
5200989 | 5200989 | 20241001044425_9G6sz | IE000M | 2024-10-02T12:03:26.010Z | 2024-10-10T12:24:33.244Z |
5200960 | 5200960 | 20241001043727_qTSdq | IE000M | 2024-10-02T12:03:17.515Z | 2024-10-10T12:24:33.144Z |
5200688 | 5200688 | 20241001035336_vFlca | IE000M | 2024-10-02T12:02:38.630Z | 2024-10-10T12:24:32.209Z |
5200546 | 5200546 | 20241001033327_1MdXN | IE000M | 2024-10-02T12:02:20.033Z | 2024-10-10T12:24:31.639Z |
5199710 | 5199710 | 20241001012331_3SLeG | IE000M | 2024-10-02T12:00:29.569Z | 2024-10-10T12:24:28.372Z |
5199560 | 5199560 | 20241001005257_1EGi3 | IE000M | 2024-10-02T12:00:13.168Z | 2024-10-10T12:24:27.819Z |
5199552 | 5199552 | 20241001005138_FuqR5 | IE000M | 2024-10-02T12:00:11.718Z | 2024-10-10T12:24:27.790Z |
5182792 | 5182792 | 20240927231718_tksRc | IE000M | 2024-09-29T12:16:16.337Z | 2024-10-05T12:29:09.104Z |
5182641 | 5182641 | 20240927230655_Rig39 | IE000M | 2024-09-29T12:16:09.921Z | 2024-10-05T12:29:08.924Z |
5181994 | 5181994 | 20240927215649_QgaKx | IE000M | 2024-09-29T12:15:39.483Z | 2024-10-05T12:29:07.666Z |
5181893 | 5181893 | 20240927214337_fvqjE | IE000M | 2024-09-29T12:15:32.511Z | 2024-10-05T12:29:07.379Z |
5179587 | 5179587 | 20240928042319_0Cb2v | IE000M | 2024-09-29T12:08:13.769Z | 2024-10-06T12:28:04.426Z |
5176471 | 5176471 | 20240928003733_3AV8f | IE000M | 2024-09-29T12:02:27.172Z | 2024-10-06T12:27:51.548Z |
5175903 | 5175903 | 20240928000000_mo8Ga | IE000M | 2024-09-29T12:01:07.760Z | 2024-10-06T12:27:49.217Z |
5175784 | 5175784 | 20240927234953_Q1vsL | IE000M | 2024-09-29T12:00:55.329Z | 2024-10-06T12:27:48.727Z |
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);