participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,188 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 |
---|---|---|---|---|---|
5592545 | 5592545 | 20241123034740_RpCBg | ES001A | 2024-11-24T14:21:07.946Z | 2024-11-24T14:21:11.809Z |
5592524 | 5592524 | 20241123034435_6C06l | ES001A | 2024-11-24T14:21:06.673Z | 2024-11-24T14:21:11.803Z |
5592447 | 5592447 | 20241123032758_awVUw | ES001A | 2024-11-24T14:21:02.013Z | 2024-11-24T14:21:11.781Z |
5592422 | 5592422 | 20241123032403_tPLnF | ES001A | 2024-11-24T14:21:01.180Z | 2024-11-24T14:21:11.775Z |
5592394 | 5592394 | 20241123031802_jghIW | ES001A | 2024-11-24T14:20:59.561Z | 2024-11-24T14:21:11.767Z |
5592372 | 5592372 | 20241123031456_FMXGU | ES001A | 2024-11-24T14:20:58.215Z | 2024-11-24T14:21:11.762Z |
5592309 | 5592309 | 20241123030134_mCkkr | ES001A | 2024-11-24T14:20:53.179Z | 2024-11-24T14:21:11.744Z |
5592280 | 5592280 | 20241123025243_kjyjG | ES001A | 2024-11-24T14:20:51.343Z | 2024-11-24T14:21:11.735Z |
5592276 | 5592276 | 20241123025210_6iBEy | ES001A | 2024-11-24T14:20:51.220Z | 2024-11-24T14:21:11.734Z |
5592239 | 5592239 | 20241123024313_2EvwH | ES001A | 2024-11-24T14:20:48.720Z | 2024-11-24T14:21:11.722Z |
5592223 | 5592223 | 20241123023939_Ir35U | ES001A | 2024-11-24T14:20:47.592Z | 2024-11-24T14:21:11.718Z |
5592096 | 5592096 | 20241123021317_7gKEK | ES001A | 2024-11-24T14:20:37.921Z | 2024-11-24T14:21:11.682Z |
5591969 | 5591969 | 20241123014336_32DhU | ES001A | 2024-11-24T14:20:30.085Z | 2024-11-24T14:21:11.646Z |
5591902 | 5591902 | 20241123012817_qOFVn | ES001A | 2024-11-24T14:20:25.354Z | 2024-11-24T14:21:11.627Z |
5591880 | 5591880 | 20241123012032_aI4rz | ES001A | 2024-11-24T14:20:22.697Z | 2024-11-24T14:21:11.621Z |
5591872 | 5591872 | 20241123011713_xa6QU | ES001A | 2024-11-24T14:20:21.630Z | 2024-11-24T14:21:11.618Z |
5591835 | 5591835 | 20241123010742_0UsFR | ES001A | 2024-11-24T14:20:20.022Z | 2024-11-24T14:21:11.607Z |
5591730 | 5591730 | 20241123003952_J5Kt2 | ES001A | 2024-11-24T14:20:14.769Z | 2024-11-24T14:21:11.575Z |
5591696 | 5591696 | 20241123003306_Hza6W | ES001A | 2024-11-24T14:20:10.902Z | 2024-11-24T14:21:11.564Z |
5584706 | 5584706 | 20241123055353_Pkppy | ES001A | 2024-11-24T14:02:08.848Z | 2024-11-24T14:02:08.848Z |
5584583 | 5584583 | 20241123050815_EG5h6 | ES001A | 2024-11-24T14:01:34.753Z | 2024-11-24T14:01:34.753Z |
5584533 | 5584533 | 20241123045937_Dd2UV | ES001A | 2024-11-24T14:01:25.397Z | 2024-11-24T14:01:25.397Z |
5584290 | 5584290 | 20241123040914_rj9Y3 | ES001A | 2024-11-24T14:00:31.286Z | 2024-11-24T14:00:31.286Z |
5584269 | 5584269 | 20241123040729_97kv2 | ES001A | 2024-11-24T14:00:25.964Z | 2024-11-24T14:00:25.964Z |
5583448 | 5583448 | 20241119223024_UUxE9 | ES001A | 2024-11-23T14:24:26.707Z | 2024-11-24T14:24:29.811Z |
5565398 | 5565398 | 20241120042237_DOX4A | ES001A | 2024-11-21T14:18:47.867Z | 2024-11-24T14:24:47.001Z |
5565174 | 5565174 | 20241120035951_lvcLY | ES001A | 2024-11-21T14:18:37.818Z | 2024-11-24T14:24:46.153Z |
5565154 | 5565154 | 20241120035739_ODnD1 | ES001A | 2024-11-21T14:18:34.060Z | 2024-11-24T14:24:46.055Z |
5565090 | 5565090 | 20241120035126_SkYHj | ES001A | 2024-11-21T14:18:28.753Z | 2024-11-24T14:24:45.788Z |
5565052 | 5565052 | 20241120034715_7lL6Y | ES001A | 2024-11-21T14:18:24.700Z | 2024-11-24T14:24:45.666Z |
5565050 | 5565050 | 20241120034709_9eHpf | ES001A | 2024-11-21T14:18:23.981Z | 2024-11-24T14:24:45.666Z |
5564794 | 5564794 | 20241120032718_gls07 | ES001A | 2024-11-21T14:18:04.118Z | 2024-11-24T14:24:43.963Z |
5564421 | 5564421 | 20241120025536_FTFJ2 | ES001A | 2024-11-21T14:17:34.416Z | 2024-11-24T14:24:43.012Z |
5563551 | 5563551 | 20241120014106_qGQgD | ES001A | 2024-11-21T14:16:17.038Z | 2024-11-24T14:24:37.923Z |
5563318 | 5563318 | 20241120011621_2Kg0g | ES001A | 2024-11-21T14:15:53.185Z | 2024-11-24T14:24:37.123Z |
5561585 | 5561585 | 20241119211026_kvZZG | ES001A | 2024-11-21T14:13:30.505Z | 2024-11-24T14:24:27.699Z |
5544067 | 5544067 | 20241114051938_zivHD | ES001A | 2024-11-16T14:10:51.296Z | 2024-11-22T14:24:21.340Z |
5544065 | 5544065 | 20241114051754_e5UDI | ES001A | 2024-11-16T14:10:50.935Z | 2024-11-22T14:24:21.258Z |
5537179 | 5537179 | 20241112204913_rxFul | ES001A | 2024-11-14T14:11:12.767Z | 2024-11-21T14:26:09.514Z |
5532587 | 5532587 | 20241112054055_ocYJ6 | ES001A | 2024-11-13T14:17:01.876Z | 2024-11-20T14:26:24.982Z |
5532238 | 5532238 | 20241112045429_lWhQ1 | ES001A | 2024-11-13T14:16:29.958Z | 2024-11-20T14:26:21.242Z |
5531658 | 5531658 | 20241112035806_QQ3gg | ES001A | 2024-11-13T14:15:49.031Z | 2024-11-20T14:26:13.045Z |
5531461 | 5531461 | 20241112034044_0J1Rr | ES001A | 2024-11-13T14:15:40.737Z | 2024-11-20T14:26:11.554Z |
5531146 | 5531146 | 20241112031745_yYgCr | ES001A | 2024-11-13T14:15:19.595Z | 2024-11-20T14:26:08.302Z |
5530546 | 5530546 | 20241112022746_bROCI | ES001A | 2024-11-13T14:14:21.486Z | 2024-11-20T14:26:01.556Z |
5530518 | 5530518 | 20241112022551_9mbsk | ES001A | 2024-11-13T14:14:20.097Z | 2024-11-20T14:26:01.091Z |
5529257 | 5529257 | 20241111235443_3S2Xr | ES001A | 2024-11-13T14:12:16.620Z | 2024-11-20T14:25:42.275Z |
5529125 | 5529125 | 20241111233205_sFjfh | ES001A | 2024-11-13T14:12:06.769Z | 2024-11-20T14:25:40.231Z |
5528623 | 5528623 | 20241111215744_JZGkh | ES001A | 2024-11-13T14:11:10.995Z | 2024-11-20T14:25:32.861Z |
5524982 | 5524982 | 20241110050326_d2BZg | ES001A | 2024-11-12T14:21:57.144Z | 2024-11-18T14:26:38.644Z |
5524970 | 5524970 | 20241110040521_GneaR | ES001A | 2024-11-12T14:21:47.607Z | 2024-11-18T14:26:37.237Z |
5524968 | 5524968 | 20241110035911_4Obuf | ES001A | 2024-11-12T14:21:45.567Z | 2024-11-18T14:26:37.007Z |
5524966 | 5524966 | 20241110035153_28B3g | ES001A | 2024-11-12T14:21:43.742Z | 2024-11-18T14:26:36.739Z |
5524951 | 5524951 | 20241110023644_zrqqT | ES001A | 2024-11-12T14:21:27.940Z | 2024-11-18T14:26:34.325Z |
5524937 | 5524937 | 20241110015325_1XXQv | ES001A | 2024-11-12T14:21:17.908Z | 2024-11-18T14:26:33.129Z |
5524933 | 5524933 | 20241110014759_x0Aeq | ES001A | 2024-11-12T14:21:16.921Z | 2024-11-18T14:26:32.946Z |
5524925 | 5524925 | 20241110012656_masN5 | ES001A | 2024-11-12T14:21:12.846Z | 2024-11-18T14:26:32.266Z |
5524923 | 5524923 | 20241110012005_meDHT | ES001A | 2024-11-12T14:21:11.520Z | 2024-11-18T14:26:31.955Z |
5524921 | 5524921 | 20241110010428_VB5Ur | ES001A | 2024-11-12T14:21:06.553Z | 2024-11-18T14:26:31.372Z |
5524919 | 5524919 | 20241110005109_4UQR3 | ES001A | 2024-11-12T14:21:04.035Z | 2024-11-18T14:26:30.943Z |
5524915 | 5524915 | 20241110001819_R6EDX | ES001A | 2024-11-12T14:20:55.515Z | 2024-11-18T14:26:30.217Z |
5524911 | 5524911 | 20241109235157_8z2Hs | ES001A | 2024-11-12T14:20:50.377Z | 2024-11-18T14:26:29.544Z |
5524906 | 5524906 | 20241109233204_w9huD | ES001A | 2024-11-12T14:20:46.809Z | 2024-11-18T14:26:28.902Z |
5524900 | 5524900 | 20241109223938_FiH42 | ES001A | 2024-11-12T14:20:37.395Z | 2024-11-18T14:26:27.920Z |
5524897 | 5524897 | 20241109223017_v6r4m | ES001A | 2024-11-12T14:20:35.390Z | 2024-11-18T14:26:27.732Z |
5524895 | 5524895 | 20241109222421_TJ7pd | ES001A | 2024-11-12T14:20:33.941Z | 2024-11-18T14:26:27.554Z |
5505675 | 5505675 | 20241106040919_jsrbZ | ES001A | 2024-11-09T14:20:12.126Z | 2024-11-14T14:23:26.350Z |
5505673 | 5505673 | 20241106034907_g2mqT | ES001A | 2024-11-09T14:20:10.976Z | 2024-11-14T14:23:26.101Z |
5505671 | 5505671 | 20241106034650_Zcg47 | ES001A | 2024-11-09T14:20:10.803Z | 2024-11-14T14:23:26.084Z |
5505669 | 5505669 | 20241106034613_mfRz0 | ES001A | 2024-11-09T14:20:10.748Z | 2024-11-14T14:23:26.068Z |
5505663 | 5505663 | 20241106033459_xWdp6 | ES001A | 2024-11-09T14:20:10.163Z | 2024-11-14T14:23:26.000Z |
5505659 | 5505659 | 20241106032436_99DyO | ES001A | 2024-11-09T14:20:09.587Z | 2024-11-14T14:23:25.855Z |
5505645 | 5505645 | 20241106021648_lBp6V | ES001A | 2024-11-09T14:20:04.934Z | 2024-11-14T14:23:24.159Z |
5505622 | 5505622 | 20241105223609_U3Izo | ES001A | 2024-11-09T14:19:54.879Z | 2024-11-14T14:23:19.302Z |
5505618 | 5505618 | 20241105214356_YUle3 | ES001A | 2024-11-09T14:19:52.715Z | 2024-11-14T14:23:18.323Z |
5505614 | 5505614 | 20241105194125_dfty7 | ES001A | 2024-11-09T14:19:45.923Z | 2024-11-14T14:23:15.277Z |
5485412 | 5485412 | 20241105053011_rBNqI | ES001A | 2024-11-06T14:18:14.321Z | 2024-11-13T14:27:42.264Z |
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 |
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);