participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,645 rows where station_code = "ES000Z" 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 |
---|---|---|---|---|---|
4357724 | 4357724 | 20240511032253_Tt9eS | ES000Z | 2024-05-22T12:12:10.553Z | 2024-05-22T12:12:10.553Z |
4357707 | 4357707 | 20240511031245_WRUH5 | ES000Z | 2024-05-22T12:12:09.534Z | 2024-05-22T12:12:09.534Z |
4351398 | 4351398 | 20240511023301_gLUqc | ES000Z | 2024-05-21T12:05:47.757Z | 2024-05-22T12:12:06.017Z |
4348178 | 4348178 | 20240510025231_T3zV2 | ES000Z | 2024-05-20T12:11:27.178Z | 2024-05-21T12:11:27.734Z |
4334528 | 4334528 | 20240509033455_233LY | ES000Z | 2024-05-18T12:12:04.058Z | 2024-05-19T12:15:26.582Z |
4333933 | 4333933 | 20240509011207_Dmjvt | ES000Z | 2024-05-18T12:10:55.912Z | 2024-05-19T12:15:07.251Z |
4322434 | 4322434 | 20240508034318_inziD | ES000Z | 2024-05-16T12:10:35.824Z | 2024-05-17T12:12:42.379Z |
4322252 | 4322252 | 20240508021952_PqlE9 | ES000Z | 2024-05-16T12:10:26.878Z | 2024-05-17T12:12:33.504Z |
4310226 | 4310226 | 20240507033111_TeCKK | ES000Z | 2024-05-14T12:11:05.277Z | 2024-05-16T12:13:38.645Z |
4310202 | 4310202 | 20240507032112_GjOVX | ES000Z | 2024-05-14T12:11:01.008Z | 2024-05-16T12:13:38.227Z |
4310124 | 4310124 | 20240507025115_CRm73 | ES000Z | 2024-05-14T12:10:45.782Z | 2024-05-16T12:13:36.578Z |
4296886 | 4296886 | 20240505033759_3GXqM | ES000Z | 2024-05-08T12:12:01.994Z | 2024-05-13T12:12:26.796Z |
4296770 | 4296770 | 20240505025657_5cKWr | ES000Z | 2024-05-08T12:11:57.521Z | 2024-05-13T12:12:24.987Z |
4290955 | 4290955 | 20240504033729_GY9GK | ES000Z | 2024-05-07T12:13:32.267Z | 2024-05-12T12:21:06.502Z |
4290949 | 4290949 | 20240504032907_YJo2M | ES000Z | 2024-05-07T12:13:31.974Z | 2024-05-12T12:21:06.134Z |
4290923 | 4290923 | 20240504031627_l3vRT | ES000Z | 2024-05-07T12:13:31.068Z | 2024-05-12T12:21:03.667Z |
4290914 | 4290914 | 20240504031609_FvDXN | ES000Z | 2024-05-07T12:13:30.852Z | 2024-05-12T12:21:03.453Z |
4290898 | 4290898 | 20240504030612_tAP5K | ES000Z | 2024-05-07T12:13:30.373Z | 2024-05-12T12:21:02.148Z |
4290887 | 4290887 | 20240504030138_L0wlc | ES000Z | 2024-05-07T12:13:29.806Z | 2024-05-12T12:21:01.432Z |
4290795 | 4290795 | 20240504024756_03cs6 | ES000Z | 2024-05-07T12:13:27.070Z | 2024-05-12T12:20:57.886Z |
4275880 | 4275880 | 20240503035429_m56LJ | ES000Z | 2024-05-05T12:12:01.677Z | 2024-05-11T12:28:24.624Z |
4275878 | 4275878 | 20240503035338_MNK7C | ES000Z | 2024-05-05T12:12:01.414Z | 2024-05-11T12:28:24.523Z |
4275847 | 4275847 | 20240503031121_Onqwo | ES000Z | 2024-05-05T12:11:58.947Z | 2024-05-11T12:28:23.009Z |
4275836 | 4275836 | 20240503024740_Fiz20 | ES000Z | 2024-05-05T12:11:57.947Z | 2024-05-11T12:28:22.224Z |
4275685 | 4275685 | 20240503000058_aZ4Bg | ES000Z | 2024-05-05T12:11:26.701Z | 2024-05-11T12:28:12.888Z |
4275675 | 4275675 | 20240502235146_LZE7A | ES000Z | 2024-05-05T12:11:24.933Z | 2024-05-11T12:28:12.547Z |
4275648 | 4275648 | 20240502231108_m9YZc | ES000Z | 2024-05-05T12:11:19.247Z | 2024-05-11T12:28:11.041Z |
4275636 | 4275636 | 20240502223437_AV3rB | ES000Z | 2024-05-05T12:11:15.023Z | 2024-05-11T12:28:09.344Z |
4266737 | 4266737 | 20240502033454_vJv3o | ES000Z | 2024-05-03T12:08:36.216Z | 2024-05-10T12:23:51.659Z |
4266727 | 4266727 | 20240502032049_vCWEK | ES000Z | 2024-05-03T12:08:34.984Z | 2024-05-10T12:23:51.356Z |
4266667 | 4266667 | 20240502021330_2OLrK | ES000Z | 2024-05-03T12:08:28.634Z | 2024-05-10T12:23:49.877Z |
4266664 | 4266664 | 20240502021205_LRFo6 | ES000Z | 2024-05-03T12:08:28.411Z | 2024-05-10T12:23:49.727Z |
4266623 | 4266623 | 20240502014854_y20VT | ES000Z | 2024-05-03T12:08:23.900Z | 2024-05-10T12:23:48.693Z |
4266574 | 4266574 | 20240502011739_ourbA | ES000Z | 2024-05-03T12:08:13.446Z | 2024-05-10T12:23:47.304Z |
4266566 | 4266566 | 20240502011305_4mfbs | ES000Z | 2024-05-03T12:08:09.229Z | 2024-05-10T12:23:47.018Z |
4257520 | 4257520 | 20240430013718_UX1Pn | ES000Z | 2024-05-01T12:13:42.323Z | 2024-05-08T12:25:02.200Z |
4237435 | 4237435 | 20240422225930_bTZZQ | ES000Z | 2024-04-26T12:11:50.881Z | 2024-04-30T12:17:55.636Z |
4237414 | 4237414 | 20240422224403_evS2L | ES000Z | 2024-04-26T12:11:48.720Z | 2024-04-30T12:17:55.293Z |
4235668 | 4235668 | 20240423040833_ExhI4 | ES000Z | 2024-04-26T12:05:00.616Z | 2024-05-02T12:22:27.550Z |
4230861 | 4230861 | 20240422035442_sBUYT | ES000Z | 2024-04-23T12:10:01.014Z | 2024-04-30T12:17:05.347Z |
4223464 | 4223464 | 20240421035042_HbJZE | ES000Z | 2024-04-22T12:02:18.662Z | 2024-04-29T12:18:31.541Z |
4220340 | 4220340 | 20240419042531_jK5l6 | ES000Z | 2024-04-21T12:03:46.178Z | 2024-04-27T12:20:16.476Z |
4220143 | 4220143 | 20240420032234_O2sSb | ES000Z | 2024-04-21T12:02:51.203Z | 2024-04-28T12:21:26.908Z |
4214005 | 4214005 | 20240418032423_2Tpma | ES000Z | 2024-04-20T12:04:11.613Z | 2024-04-26T12:16:57.707Z |
4201350 | 4201350 | 20240417015947_DeJLd | ES000Z | 2024-04-18T12:03:16.090Z | 2024-04-25T12:21:16.736Z |
4201135 | 4201135 | 20240417012848_HzlRq | ES000Z | 2024-04-18T12:02:54.070Z | 2024-04-25T12:21:13.576Z |
4200998 | 4200998 | 20240417010933_TKWCZ | ES000Z | 2024-04-18T12:02:37.208Z | 2024-04-25T12:21:11.635Z |
4191166 | 4191166 | 20240415040805_2dI86 | ES000Z | 2024-04-16T12:05:42.466Z | 2024-04-23T12:24:56.020Z |
4191162 | 4191162 | 20240415035846_oMZY0 | ES000Z | 2024-04-16T12:05:41.765Z | 2024-04-23T12:24:55.964Z |
4191160 | 4191160 | 20240415035606_BuUeu | ES000Z | 2024-04-16T12:05:41.411Z | 2024-04-23T12:24:55.945Z |
4190832 | 4190832 | 20240415015915_0A1eg | ES000Z | 2024-04-16T12:04:42.304Z | 2024-04-23T12:24:50.803Z |
4190066 | 4190066 | 20240414231702_t3IaV | ES000Z | 2024-04-16T12:02:48.086Z | 2024-04-23T12:24:42.472Z |
4189922 | 4189922 | 20240414223211_N1Rnx | ES000Z | 2024-04-16T12:02:24.039Z | 2024-04-23T12:24:39.484Z |
4189687 | 4189687 | 20240414213125_t3BoA | ES000Z | 2024-04-16T12:01:55.710Z | 2024-04-23T12:24:36.460Z |
4185901 | 4185901 | 20240414022833_AzZB5 | ES000Z | 2024-04-15T12:05:25.827Z | 2024-04-22T12:22:23.424Z |
4185857 | 4185857 | 20240414022011_i7lvh | ES000Z | 2024-04-15T12:05:18.407Z | 2024-04-22T12:22:22.766Z |
4185819 | 4185819 | 20240414021439_hZ0oZ | ES000Z | 2024-04-15T12:05:14.801Z | 2024-04-22T12:22:22.298Z |
4185064 | 4185064 | 20240413235154_sJB4N | ES000Z | 2024-04-15T12:03:30.476Z | 2024-04-22T12:22:13.724Z |
4184909 | 4184909 | 20240413230711_u7Qsc | ES000Z | 2024-04-15T12:03:00.741Z | 2024-04-22T12:22:11.819Z |
4184773 | 4184773 | 20240413215442_bhYLY | ES000Z | 2024-04-15T12:02:35.437Z | 2024-04-22T12:22:09.767Z |
4180265 | 4180265 | 20240413031618_pLyEI | ES000Z | 2024-04-14T12:04:32.600Z | 2024-04-21T12:21:45.082Z |
4180185 | 4180185 | 20240413024950_aRLUq | ES000Z | 2024-04-14T12:04:13.830Z | 2024-04-21T12:21:42.963Z |
4180160 | 4180160 | 20240413024030_fqV8m | ES000Z | 2024-04-14T12:04:10.147Z | 2024-04-21T12:21:41.629Z |
4180135 | 4180135 | 20240413023237_Nw313 | ES000Z | 2024-04-14T12:04:05.692Z | 2024-04-21T12:21:41.105Z |
4179731 | 4179731 | 20240413002802_mAKND | ES000Z | 2024-04-14T12:02:46.589Z | 2024-04-21T12:21:33.759Z |
4179383 | 4179383 | 20240412211215_k8Vzk | ES000Z | 2024-04-14T12:01:26.745Z | 2024-04-21T12:21:26.579Z |
4175705 | 4175705 | 20240412031446_qFLS1 | ES000Z | 2024-04-13T12:06:37.630Z | 2024-04-20T12:25:31.239Z |
4175557 | 4175557 | 20240412024759_GzPyr | ES000Z | 2024-04-13T12:06:19.073Z | 2024-04-20T12:25:29.857Z |
4175491 | 4175491 | 20240412023052_yXjQ7 | ES000Z | 2024-04-13T12:06:07.843Z | 2024-04-20T12:25:29.374Z |
4175242 | 4175242 | 20240412013413_i2QGk | ES000Z | 2024-04-13T12:05:21.985Z | 2024-04-20T12:25:24.280Z |
4175170 | 4175170 | 20240412011230_md7Ie | ES000Z | 2024-04-13T12:05:09.379Z | 2024-04-20T12:25:23.737Z |
4175028 | 4175028 | 20240412002442_nU8F1 | ES000Z | 2024-04-13T12:04:39.035Z | 2024-04-20T12:25:21.874Z |
4174994 | 4174994 | 20240412000118_hHg32 | ES000Z | 2024-04-13T12:04:28.517Z | 2024-04-20T12:25:21.284Z |
4171933 | 4171933 | 20240410032031_d4l0E | ES000Z | 2024-04-12T12:08:38.027Z | 2024-04-18T12:21:21.022Z |
4171744 | 4171744 | 20240410025623_LvF5F | ES000Z | 2024-04-12T12:08:07.599Z | 2024-04-18T12:21:19.780Z |
4171541 | 4171541 | 20240410023157_2larV | ES000Z | 2024-04-12T12:07:50.900Z | 2024-04-18T12:21:18.428Z |
4169597 | 4169597 | 20240410014259_jCriL | ES000Z | 2024-04-11T12:14:53.823Z | 2024-04-18T12:21:15.566Z |
4169322 | 4169322 | 20240410010436_755Cp | ES000Z | 2024-04-11T12:14:34.216Z | 2024-04-18T12:21:14.095Z |
4169215 | 4169215 | 20240410004905_vOOYA | ES000Z | 2024-04-11T12:14:19.156Z | 2024-04-18T12:21:13.249Z |
4166908 | 4166908 | 20240409042019_hlpqm | ES000Z | 2024-04-11T12:07:58.834Z | 2024-04-17T12:21:12.249Z |
4166888 | 4166888 | 20240409034842_wW4vB | ES000Z | 2024-04-11T12:07:56.206Z | 2024-04-17T12:21:11.563Z |
4166882 | 4166882 | 20240409034202_rOQX5 | ES000Z | 2024-04-11T12:07:55.524Z | 2024-04-17T12:21:11.504Z |
4165810 | 4165810 | 20240409212908_2T4SN | ES000Z | 2024-04-11T12:04:14.563Z | 2024-04-18T12:21:04.056Z |
4165538 | 4165538 | 20240409205850_Lk42F | ES000Z | 2024-04-11T12:03:38.895Z | 2024-04-18T12:21:01.728Z |
4165361 | 4165361 | 20240409202323_gTNOU | ES000Z | 2024-04-11T12:03:05.705Z | 2024-04-18T12:21:00.135Z |
4162288 | 4162288 | 20240409030218_So0Rk | ES000Z | 2024-04-10T12:04:32.834Z | 2024-04-17T12:21:09.443Z |
4162286 | 4162286 | 20240409030131_C5mgd | ES000Z | 2024-04-10T12:04:32.456Z | 2024-04-17T12:21:09.431Z |
4162258 | 4162258 | 20240409023426_xKj0R | ES000Z | 2024-04-10T12:04:26.199Z | 2024-04-17T12:21:08.365Z |
4162222 | 4162222 | 20240409015252_6g1gb | ES000Z | 2024-04-10T12:04:20.890Z | 2024-04-17T12:21:07.105Z |
4162164 | 4162164 | 20240409011740_DBmu2 | ES000Z | 2024-04-10T12:04:12.495Z | 2024-04-17T12:21:05.144Z |
4162162 | 4162162 | 20240409011724_ONXkq | ES000Z | 2024-04-10T12:04:12.124Z | 2024-04-17T12:21:04.994Z |
4162133 | 4162133 | 20240409004203_OJdok | ES000Z | 2024-04-10T12:04:07.086Z | 2024-04-17T12:21:03.583Z |
4162078 | 4162078 | 20240408231321_hawRM | ES000Z | 2024-04-10T12:03:52.186Z | 2024-04-17T12:21:01.964Z |
4150327 | 4150327 | 20240406034108_YGRs9 | ES000Z | 2024-04-07T12:04:00.895Z | 2024-04-14T12:20:48.987Z |
4146934 | 4146934 | 20240405024130_25D2b | ES000Z | 2024-04-06T12:05:07.181Z | 2024-04-13T12:21:25.757Z |
4143056 | 4143056 | 20240404043103_Oe3Cp | ES000Z | 2024-04-05T12:04:04.817Z | 2024-04-12T12:19:47.752Z |
4143018 | 4143018 | 20240404040349_f57nm | ES000Z | 2024-04-05T12:03:59.944Z | 2024-04-12T12:19:47.447Z |
4135507 | 4135507 | 20240401231137_wvjVW | ES000Z | 2024-04-03T12:05:01.415Z | 2024-04-10T12:17:47.733Z |
4086279 | 4086279 | 20240318025731_Y1wRP | ES000Z | 2024-03-19T12:08:20.169Z | 2024-03-26T12:21:03.553Z |
4086276 | 4086276 | 20240318025454_zLUvj | ES000Z | 2024-03-19T12:08:19.765Z | 2024-03-26T12:21:03.517Z |
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);