participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,139 rows where station_code = "ES001A" 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 |
---|---|---|---|---|---|
5524982 | 5524982 | 20241110050326_d2BZg | ES001A | 2024-11-12T14:21:57.144Z | 2024-11-12T14:21:57.144Z |
5524970 | 5524970 | 20241110040521_GneaR | ES001A | 2024-11-12T14:21:47.607Z | 2024-11-12T14:21:47.607Z |
5524968 | 5524968 | 20241110035911_4Obuf | ES001A | 2024-11-12T14:21:45.567Z | 2024-11-12T14:21:45.567Z |
5524966 | 5524966 | 20241110035153_28B3g | ES001A | 2024-11-12T14:21:43.742Z | 2024-11-12T14:21:43.742Z |
5524951 | 5524951 | 20241110023644_zrqqT | ES001A | 2024-11-12T14:21:27.940Z | 2024-11-12T14:21:27.940Z |
5524937 | 5524937 | 20241110015325_1XXQv | ES001A | 2024-11-12T14:21:17.908Z | 2024-11-12T14:21:17.908Z |
5524933 | 5524933 | 20241110014759_x0Aeq | ES001A | 2024-11-12T14:21:16.921Z | 2024-11-12T14:21:16.921Z |
5524925 | 5524925 | 20241110012656_masN5 | ES001A | 2024-11-12T14:21:12.846Z | 2024-11-12T14:21:12.846Z |
5524923 | 5524923 | 20241110012005_meDHT | ES001A | 2024-11-12T14:21:11.520Z | 2024-11-12T14:21:11.520Z |
5524921 | 5524921 | 20241110010428_VB5Ur | ES001A | 2024-11-12T14:21:06.553Z | 2024-11-12T14:21:06.553Z |
5524919 | 5524919 | 20241110005109_4UQR3 | ES001A | 2024-11-12T14:21:04.035Z | 2024-11-12T14:21:04.035Z |
5524915 | 5524915 | 20241110001819_R6EDX | ES001A | 2024-11-12T14:20:55.515Z | 2024-11-12T14:20:55.515Z |
5524911 | 5524911 | 20241109235157_8z2Hs | ES001A | 2024-11-12T14:20:50.377Z | 2024-11-12T14:20:50.377Z |
5524906 | 5524906 | 20241109233204_w9huD | ES001A | 2024-11-12T14:20:46.809Z | 2024-11-12T14:20:46.809Z |
5524900 | 5524900 | 20241109223938_FiH42 | ES001A | 2024-11-12T14:20:37.395Z | 2024-11-12T14:20:37.395Z |
5524897 | 5524897 | 20241109223017_v6r4m | ES001A | 2024-11-12T14:20:35.390Z | 2024-11-12T14:20:35.390Z |
5524895 | 5524895 | 20241109222421_TJ7pd | ES001A | 2024-11-12T14:20:33.941Z | 2024-11-12T14:20:33.941Z |
5505675 | 5505675 | 20241106040919_jsrbZ | ES001A | 2024-11-09T14:20:12.126Z | 2024-11-12T14:26:55.494Z |
5505673 | 5505673 | 20241106034907_g2mqT | ES001A | 2024-11-09T14:20:10.976Z | 2024-11-12T14:26:54.863Z |
5505671 | 5505671 | 20241106034650_Zcg47 | ES001A | 2024-11-09T14:20:10.803Z | 2024-11-12T14:26:54.831Z |
5505669 | 5505669 | 20241106034613_mfRz0 | ES001A | 2024-11-09T14:20:10.748Z | 2024-11-12T14:26:54.745Z |
5505663 | 5505663 | 20241106033459_xWdp6 | ES001A | 2024-11-09T14:20:10.163Z | 2024-11-12T14:26:54.677Z |
5505659 | 5505659 | 20241106032436_99DyO | ES001A | 2024-11-09T14:20:09.587Z | 2024-11-12T14:26:54.489Z |
5505645 | 5505645 | 20241106021648_lBp6V | ES001A | 2024-11-09T14:20:04.934Z | 2024-11-12T14:26:53.372Z |
5505622 | 5505622 | 20241105223609_U3Izo | ES001A | 2024-11-09T14:19:54.879Z | 2024-11-12T14:26:48.166Z |
5505618 | 5505618 | 20241105214356_YUle3 | ES001A | 2024-11-09T14:19:52.715Z | 2024-11-12T14:26:47.329Z |
5505614 | 5505614 | 20241105194125_dfty7 | ES001A | 2024-11-09T14:19:45.923Z | 2024-11-12T14:26:44.592Z |
5485412 | 5485412 | 20241105053011_rBNqI | ES001A | 2024-11-06T14:18:14.321Z | 2024-11-12T14:27:38.611Z |
5470092 | 5470092 | 20241103052834_togpH | ES001A | 2024-11-04T14:17:47.643Z | 2024-11-11T14:23:04.285Z |
5470060 | 5470060 | 20241103051804_8e6c4 | ES001A | 2024-11-04T14:17:41.863Z | 2024-11-11T14:23:03.839Z |
5470050 | 5470050 | 20241103051547_Eg2Tw | ES001A | 2024-11-04T14:17:39.738Z | 2024-11-11T14:23:03.810Z |
5469828 | 5469828 | 20241103042531_zfV6N | ES001A | 2024-11-04T14:17:06.910Z | 2024-11-11T14:23:02.337Z |
5469655 | 5469655 | 20241103035601_mn1ZF | ES001A | 2024-11-04T14:16:43.667Z | 2024-11-11T14:23:01.849Z |
5469653 | 5469653 | 20241103035600_vpDOz | ES001A | 2024-11-04T14:16:43.580Z | 2024-11-11T14:23:01.847Z |
5469594 | 5469594 | 20241103035047_aJh2C | ES001A | 2024-11-04T14:16:39.515Z | 2024-11-11T14:23:01.294Z |
5468965 | 5468965 | 20241103021603_xGpSl | ES001A | 2024-11-04T14:15:18.940Z | 2024-11-11T14:22:57.236Z |
5468880 | 5468880 | 20241103020420_VvM54 | ES001A | 2024-11-04T14:15:11.138Z | 2024-11-11T14:22:56.754Z |
5468736 | 5468736 | 20241103013552_XDOBw | ES001A | 2024-11-04T14:14:59.282Z | 2024-11-11T14:22:55.272Z |
5468697 | 5468697 | 20241103012854_VpeT3 | ES001A | 2024-11-04T14:14:55.987Z | 2024-11-11T14:22:54.972Z |
5468670 | 5468670 | 20241103012117_Ex067 | ES001A | 2024-11-04T14:14:52.569Z | 2024-11-11T14:22:54.599Z |
5468327 | 5468327 | 20241103001213_kGIie | ES001A | 2024-11-04T14:13:57.765Z | 2024-11-11T14:22:52.747Z |
5467430 | 5467430 | 20241102211231_LiMo5 | ES001A | 2024-11-04T14:11:29.214Z | 2024-11-11T14:22:47.087Z |
5467187 | 5467187 | 20241102202048_ERX8E | ES001A | 2024-11-04T14:11:04.279Z | 2024-11-11T14:22:45.555Z |
5467181 | 5467181 | 20241102202035_nr03I | ES001A | 2024-11-04T14:11:03.552Z | 2024-11-11T14:22:45.522Z |
5463882 | 5463882 | 20241102055812_OvGQ9 | ES001A | 2024-11-03T14:19:21.967Z | 2024-11-10T14:26:37.217Z |
5463741 | 5463741 | 20241102044851_vGsuJ | ES001A | 2024-11-03T14:19:12.570Z | 2024-11-10T14:26:36.609Z |
5463577 | 5463577 | 20241102040916_rwX5D | ES001A | 2024-11-03T14:18:58.859Z | 2024-11-10T14:26:35.586Z |
5463172 | 5463172 | 20241102024641_uumjk | ES001A | 2024-11-03T14:18:25.179Z | 2024-11-10T14:26:34.447Z |
5463126 | 5463126 | 20241102023752_3seNZ | ES001A | 2024-11-03T14:18:20.774Z | 2024-11-10T14:26:34.367Z |
5463102 | 5463102 | 20241102023503_ly120 | ES001A | 2024-11-03T14:18:18.562Z | 2024-11-10T14:26:34.265Z |
5453921 | 5453921 | 20241031031738_66IUE | ES001A | 2024-11-02T12:22:45.102Z | 2024-11-08T14:23:19.681Z |
5453845 | 5453845 | 20241031030935_YlPg7 | ES001A | 2024-11-02T12:22:43.719Z | 2024-11-08T14:23:19.531Z |
5453720 | 5453720 | 20241031025211_DkMqQ | ES001A | 2024-11-02T12:22:41.046Z | 2024-11-08T14:23:18.907Z |
5453567 | 5453567 | 20241031022604_n732r | ES001A | 2024-11-02T12:22:36.276Z | 2024-11-08T14:23:18.103Z |
5453517 | 5453517 | 20241031021801_lJVI9 | ES001A | 2024-11-02T12:22:35.021Z | 2024-11-08T14:23:17.653Z |
5453210 | 5453210 | 20241031015052_FQbVV | ES001A | 2024-11-02T12:22:29.874Z | 2024-11-08T14:23:16.167Z |
5444433 | 5444433 | 20241031012047_2sebY | ES001A | 2024-11-01T12:21:17.712Z | 2024-11-08T14:23:15.518Z |
5444041 | 5444041 | 20241031004053_dkvDL | ES001A | 2024-11-01T12:21:02.857Z | 2024-11-08T14:23:13.602Z |
5443830 | 5443830 | 20241031001929_rwcvo | ES001A | 2024-11-01T12:20:53.460Z | 2024-11-08T14:23:12.701Z |
5443652 | 5443652 | 20241030235947_A0ge5 | ES001A | 2024-11-01T12:20:44.732Z | 2024-11-08T14:23:11.927Z |
5440661 | 5440661 | 20241030224253_AR7hP | ES001A | 2024-11-01T12:15:42.596Z | 2024-11-08T14:23:10.231Z |
5440531 | 5440531 | 20241030222429_hVX6Q | ES001A | 2024-11-01T12:15:35.234Z | 2024-11-08T14:23:09.823Z |
5430615 | 5430615 | 20241028231225_MJTBZ | ES001A | 2024-10-31T12:18:43.428Z | 2024-11-06T14:27:20.720Z |
5430433 | 5430433 | 20241028223353_nw82A | ES001A | 2024-10-31T12:18:22.613Z | 2024-11-06T14:27:19.979Z |
5430216 | 5430216 | 20241028213724_km6qu | ES001A | 2024-10-31T12:17:53.665Z | 2024-11-06T14:27:19.353Z |
5430149 | 5430149 | 20241028211850_D1aST | ES001A | 2024-10-31T12:17:45.250Z | 2024-11-06T14:27:19.047Z |
5420802 | 5420802 | 20241028033849_dNl26 | ES001A | 2024-10-30T12:19:19.549Z | 2024-11-05T14:27:16.379Z |
5420775 | 5420775 | 20241028033501_fSRYl | ES001A | 2024-10-30T12:19:16.181Z | 2024-11-05T14:27:16.297Z |
5420522 | 5420522 | 20241028025322_ht6sE | ES001A | 2024-10-30T12:18:56.339Z | 2024-11-05T14:27:15.609Z |
5420344 | 5420344 | 20241028023144_IK5ub | ES001A | 2024-10-30T12:18:44.116Z | 2024-11-05T14:27:15.212Z |
5420097 | 5420097 | 20241028015700_pXx1e | ES001A | 2024-10-30T12:18:20.352Z | 2024-11-05T14:27:14.497Z |
5420006 | 5420006 | 20241028014304_3EAPD | ES001A | 2024-10-30T12:18:13.923Z | 2024-11-05T14:27:14.342Z |
5420001 | 5420001 | 20241028014231_GtbcP | ES001A | 2024-10-30T12:18:13.724Z | 2024-11-05T14:27:14.312Z |
5419505 | 5419505 | 20241028001150_iKEsv | ES001A | 2024-10-30T12:17:30.696Z | 2024-11-05T14:27:13.306Z |
5419367 | 5419367 | 20241027234410_baocg | ES001A | 2024-10-30T12:17:23.074Z | 2024-11-05T14:27:12.923Z |
5419353 | 5419353 | 20241027234210_XnCJA | ES001A | 2024-10-30T12:17:22.187Z | 2024-11-05T14:27:12.812Z |
5410929 | 5410929 | 20241027055436_R5JTz | ES001A | 2024-10-29T12:18:12.595Z | 2024-11-04T14:29:06.383Z |
5410717 | 5410717 | 20241027053056_VL6Ic | ES001A | 2024-10-29T12:18:03.265Z | 2024-11-04T14:29:05.300Z |
5410560 | 5410560 | 20241027051810_cjKom | ES001A | 2024-10-29T12:17:58.280Z | 2024-11-04T14:29:04.976Z |
5410310 | 5410310 | 20241027050605_8fmV8 | ES001A | 2024-10-29T12:17:52.803Z | 2024-11-04T14:29:04.323Z |
5410267 | 5410267 | 20241027050437_xwIho | ES001A | 2024-10-29T12:17:51.902Z | 2024-11-04T14:29:04.275Z |
5410253 | 5410253 | 20241027050304_Lrhsi | ES001A | 2024-10-29T12:17:51.575Z | 2024-11-04T14:29:04.250Z |
5409531 | 5409531 | 20241027042329_9DyGG | ES001A | 2024-10-29T12:17:28.849Z | 2024-11-04T14:29:01.939Z |
5409391 | 5409391 | 20241027041345_Na2L4 | ES001A | 2024-10-29T12:17:19.599Z | 2024-11-04T14:29:01.633Z |
5408187 | 5408187 | 20241027031420_BfpHi | ES001A | 2024-10-29T12:16:15.009Z | 2024-11-04T14:28:58.953Z |
5408008 | 5408008 | 20241027030212_KCYfk | ES001A | 2024-10-29T12:15:59.621Z | 2024-11-04T14:28:58.562Z |
5407972 | 5407972 | 20241027030049_SgbTc | ES001A | 2024-10-29T12:15:56.350Z | 2024-11-04T14:28:58.538Z |
5407693 | 5407693 | 20241027024712_QkYh5 | ES001A | 2024-10-29T12:15:34.436Z | 2024-11-04T14:28:58.052Z |
5406195 | 5406195 | 20241027012115_oAYJX | ES001A | 2024-10-29T12:13:56.740Z | 2024-11-04T14:28:55.201Z |
5406117 | 5406117 | 20241027011750_dQdmG | ES001A | 2024-10-29T12:13:52.745Z | 2024-11-04T14:28:55.148Z |
5404700 | 5404700 | 20241026234627_LBKTM | ES001A | 2024-10-29T12:11:53.214Z | 2024-11-04T14:28:51.658Z |
5399837 | 5399837 | 20241026050558_1ZemF | ES001A | 2024-10-28T12:20:13.001Z | 2024-11-03T14:27:40.597Z |
5399769 | 5399769 | 20241026050046_UDKW1 | ES001A | 2024-10-28T12:20:10.640Z | 2024-11-03T14:27:40.485Z |
5399700 | 5399700 | 20241026045217_QjYkI | ES001A | 2024-10-28T12:20:08.176Z | 2024-11-03T14:27:40.294Z |
5399469 | 5399469 | 20241026042300_8ejIv | ES001A | 2024-10-28T12:20:00.046Z | 2024-11-03T14:27:39.825Z |
5399279 | 5399279 | 20241026040738_NR0oq | ES001A | 2024-10-28T12:19:53.267Z | 2024-11-03T14:27:39.328Z |
5399116 | 5399116 | 20241026035416_mzaCf | ES001A | 2024-10-28T12:19:48.980Z | 2024-11-03T14:27:39.055Z |
5398380 | 5398380 | 20241026025157_jkPtP | ES001A | 2024-10-28T12:19:13.237Z | 2024-11-03T14:27:36.165Z |
5398336 | 5398336 | 20241026024518_oHpiL | ES001A | 2024-10-28T12:19:11.040Z | 2024-11-03T14:27:35.919Z |
5397925 | 5397925 | 20241026020728_Ydnu7 | ES001A | 2024-10-28T12:18:51.111Z | 2024-11-03T14:27:34.557Z |
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);