participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,503 rows where station_code = "ES0016" 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 |
---|---|---|---|---|---|
5134019 | 5134019 | 20240916043212_A3Tb8 | ES0016 | 2024-09-19T12:17:16.366Z | 2024-09-19T12:17:16.366Z |
5133912 | 5133912 | 20240916041754_3Gpsy | ES0016 | 2024-09-19T12:17:13.028Z | 2024-09-19T12:17:13.028Z |
5133840 | 5133840 | 20240916040938_huMHt | ES0016 | 2024-09-19T12:17:10.226Z | 2024-09-19T12:17:10.226Z |
5133838 | 5133838 | 20240916040902_71k3W | ES0016 | 2024-09-19T12:17:10.113Z | 2024-09-19T12:17:10.113Z |
5133778 | 5133778 | 20240916040506_mANCd | ES0016 | 2024-09-19T12:17:07.832Z | 2024-09-19T12:17:07.832Z |
5133647 | 5133647 | 20240916034958_V4ogL | ES0016 | 2024-09-19T12:17:04.874Z | 2024-09-19T12:17:04.874Z |
5133255 | 5133255 | 20240916031316_sRxgh | ES0016 | 2024-09-19T12:16:51.374Z | 2024-09-19T12:16:51.374Z |
5133223 | 5133223 | 20240916030747_YGGSo | ES0016 | 2024-09-19T12:16:49.795Z | 2024-09-19T12:16:49.795Z |
5133178 | 5133178 | 20240916030437_6pkxl | ES0016 | 2024-09-19T12:16:46.437Z | 2024-09-19T12:16:46.437Z |
5132948 | 5132948 | 20240916023146_zEaw8 | ES0016 | 2024-09-19T12:16:38.240Z | 2024-09-19T12:16:38.240Z |
5132508 | 5132508 | 20240916012250_C60Rp | ES0016 | 2024-09-19T12:16:16.087Z | 2024-09-19T12:16:16.087Z |
5129538 | 5129538 | 20240917040705_IODGv | ES0016 | 2024-09-19T12:11:47.911Z | 2024-09-19T12:11:47.911Z |
5128935 | 5128935 | 20240917025916_t89Ze | ES0016 | 2024-09-19T12:11:08.515Z | 2024-09-19T12:11:08.515Z |
5121135 | 5121135 | 20240914035415_Z23Va | ES0016 | 2024-09-18T12:10:51.994Z | 2024-09-19T12:20:01.456Z |
5119280 | 5119280 | 20240914022047_NXia6 | ES0016 | 2024-09-18T12:10:19.317Z | 2024-09-19T12:19:57.571Z |
5117532 | 5117532 | 20240915050314_Xm3Cq | ES0016 | 2024-09-18T12:07:45.521Z | 2024-09-19T12:19:15.719Z |
5117528 | 5117528 | 20240915050201_MC30r | ES0016 | 2024-09-18T12:07:45.161Z | 2024-09-19T12:19:15.666Z |
5116876 | 5116876 | 20240915034448_rLkXZ | ES0016 | 2024-09-18T12:07:23.966Z | 2024-09-19T12:19:12.495Z |
5116755 | 5116755 | 20240915033922_K2pfi | ES0016 | 2024-09-18T12:07:19.790Z | 2024-09-19T12:19:12.290Z |
5116484 | 5116484 | 20240915032926_ESqtS | ES0016 | 2024-09-18T12:07:06.213Z | 2024-09-19T12:19:11.327Z |
5115114 | 5115114 | 20240915022035_TNT8F | ES0016 | 2024-09-18T12:06:00.300Z | 2024-09-19T12:19:01.634Z |
5114695 | 5114695 | 20240915015451_jkr3v | ES0016 | 2024-09-18T12:05:29.052Z | 2024-09-19T12:18:59.383Z |
5112677 | 5112677 | 20240914234105_Ue1Vy | ES0016 | 2024-09-18T12:03:21.296Z | 2024-09-19T12:18:42.954Z |
5108317 | 5108317 | 20240913044844_B8QxG | ES0016 | 2024-09-17T12:13:36.262Z | 2024-09-19T12:20:48.121Z |
5102637 | 5102637 | 20240914013346_JAmEW | ES0016 | 2024-09-17T12:07:28.524Z | 2024-09-19T12:19:55.277Z |
5102635 | 5102635 | 20240914013344_qVx1M | ES0016 | 2024-09-17T12:07:28.252Z | 2024-09-19T12:19:55.272Z |
5102089 | 5102089 | 20240914010601_thyI8 | ES0016 | 2024-09-17T12:06:47.624Z | 2024-09-19T12:19:52.435Z |
5101852 | 5101852 | 20240914005036_2Ujaq | ES0016 | 2024-09-17T12:06:17.782Z | 2024-09-19T12:19:51.712Z |
5101204 | 5101204 | 20240914001305_dN6AC | ES0016 | 2024-09-17T12:05:26.387Z | 2024-09-19T12:19:50.035Z |
5097751 | 5097751 | 20240913010030_pdsdl | ES0016 | 2024-09-16T12:17:14.440Z | 2024-09-19T12:20:38.938Z |
5097210 | 5097210 | 20240913003626_uKC31 | ES0016 | 2024-09-16T12:17:07.962Z | 2024-09-19T12:20:37.854Z |
5091481 | 5091481 | 20240912021039_aPbLt | ES0016 | 2024-09-16T12:13:07.700Z | 2024-09-19T12:21:13.078Z |
5091308 | 5091308 | 20240912020425_CxQam | ES0016 | 2024-09-16T12:12:58.758Z | 2024-09-19T12:21:12.748Z |
5090351 | 5090351 | 20240912012215_H4VH0 | ES0016 | 2024-09-16T12:12:15.566Z | 2024-09-19T12:21:11.233Z |
5089282 | 5089282 | 20240912003210_bt9hm | ES0016 | 2024-09-16T12:11:18.899Z | 2024-09-19T12:21:09.863Z |
5086147 | 5086147 | 20240912221130_8dPOn | ES0016 | 2024-09-16T12:05:17.261Z | 2024-09-19T12:20:30.293Z |
5085932 | 5085932 | 20240912215816_3q7Qs | ES0016 | 2024-09-16T12:05:04.099Z | 2024-09-19T12:20:29.805Z |
5085096 | 5085096 | 20240912204519_TEL0u | ES0016 | 2024-09-16T12:03:31.382Z | 2024-09-19T12:20:27.997Z |
5080255 | 5080255 | 20240911034421_ekchB | ES0016 | 2024-09-15T12:16:55.152Z | 2024-09-19T12:21:43.139Z |
5078682 | 5078682 | 20240911021128_VOckh | ES0016 | 2024-09-15T12:15:49.509Z | 2024-09-19T12:21:40.668Z |
5076611 | 5076611 | 20240910235138_mdRR2 | ES0016 | 2024-09-15T12:13:47.946Z | 2024-09-19T12:21:37.388Z |
5065565 | 5065565 | 20240910044014_7VdgA | ES0016 | 2024-09-14T12:17:11.611Z | 2024-09-18T12:15:19.847Z |
5065424 | 5065424 | 20240910040435_roOMz | ES0016 | 2024-09-14T12:17:05.084Z | 2024-09-18T12:15:19.381Z |
5065366 | 5065366 | 20240910035552_Or3y2 | ES0016 | 2024-09-14T12:17:02.050Z | 2024-09-18T12:15:19.200Z |
5065311 | 5065311 | 20240910034033_V9zBJ | ES0016 | 2024-09-14T12:16:57.068Z | 2024-09-18T12:15:18.987Z |
5065139 | 5065139 | 20240910031117_2DkBe | ES0016 | 2024-09-14T12:16:28.276Z | 2024-09-18T12:15:18.486Z |
5064804 | 5064804 | 20240910020723_6Au5v | ES0016 | 2024-09-14T12:16:03.773Z | 2024-09-18T12:15:17.411Z |
5064775 | 5064775 | 20240910020255_CO2Fa | ES0016 | 2024-09-14T12:16:01.208Z | 2024-09-18T12:15:17.314Z |
5064605 | 5064605 | 20240910014116_03Cpw | ES0016 | 2024-09-14T12:15:45.609Z | 2024-09-18T12:15:16.868Z |
5064335 | 5064335 | 20240910005139_j3IKC | ES0016 | 2024-09-14T12:15:18.250Z | 2024-09-18T12:15:16.155Z |
5064138 | 5064138 | 20240910000802_ZGOKv | ES0016 | 2024-09-14T12:14:58.974Z | 2024-09-18T12:15:15.566Z |
5063488 | 5063488 | 20240909212418_Z5Gy6 | ES0016 | 2024-09-14T12:14:03.097Z | 2024-09-18T12:15:14.065Z |
5054883 | 5054883 | 20240908044712_WiaJV | ES0016 | 2024-09-13T12:16:57.910Z | 2024-09-16T12:21:17.096Z |
5054860 | 5054860 | 20240908043241_iTBoz | ES0016 | 2024-09-13T12:16:57.249Z | 2024-09-16T12:21:17.022Z |
5054843 | 5054843 | 20240908042734_Vr6pr | ES0016 | 2024-09-13T12:16:56.810Z | 2024-09-16T12:21:17.001Z |
5054713 | 5054713 | 20240908034211_netRK | ES0016 | 2024-09-13T12:16:53.647Z | 2024-09-16T12:21:16.658Z |
5054632 | 5054632 | 20240908032452_3pdlF | ES0016 | 2024-09-13T12:16:50.427Z | 2024-09-16T12:21:16.341Z |
5054264 | 5054264 | 20240908023347_b7uP3 | ES0016 | 2024-09-13T12:16:35.723Z | 2024-09-16T12:21:14.708Z |
5054217 | 5054217 | 20240908022834_G4Cb0 | ES0016 | 2024-09-13T12:16:34.204Z | 2024-09-16T12:21:14.391Z |
5054171 | 5054171 | 20240908021844_zfK6x | ES0016 | 2024-09-13T12:16:32.237Z | 2024-09-16T12:21:14.186Z |
5053848 | 5053848 | 20240908014058_GHSE4 | ES0016 | 2024-09-13T12:16:19.757Z | 2024-09-16T12:21:12.915Z |
5053797 | 5053797 | 20240908013159_yfyTb | ES0016 | 2024-09-13T12:16:17.713Z | 2024-09-16T12:21:12.787Z |
5053402 | 5053402 | 20240908003104_ojLBO | ES0016 | 2024-09-13T12:16:03.083Z | 2024-09-16T12:21:10.551Z |
5052869 | 5052869 | 20240907222711_OXk7Q | ES0016 | 2024-09-13T12:15:33.758Z | 2024-09-16T12:21:08.291Z |
5047638 | 5047638 | 20240909050339_x7Hgh | ES0016 | 2024-09-13T12:09:30.333Z | 2024-09-17T12:19:03.792Z |
5047501 | 5047501 | 20240909042953_OfY6Z | ES0016 | 2024-09-13T12:09:17.802Z | 2024-09-17T12:19:02.915Z |
5047367 | 5047367 | 20240909034315_V4DAJ | ES0016 | 2024-09-13T12:08:52.497Z | 2024-09-17T12:19:02.182Z |
5047332 | 5047332 | 20240909033126_Uo56d | ES0016 | 2024-09-13T12:08:48.695Z | 2024-09-17T12:19:02.058Z |
5047316 | 5047316 | 20240909032812_z9ZAK | ES0016 | 2024-09-13T12:08:47.091Z | 2024-09-17T12:19:01.997Z |
5047194 | 5047194 | 20240909030032_M23G2 | ES0016 | 2024-09-13T12:08:37.668Z | 2024-09-17T12:19:01.548Z |
5046808 | 5046808 | 20240909012554_LwFNn | ES0016 | 2024-09-13T12:07:34.929Z | 2024-09-17T12:19:00.387Z |
5046804 | 5046804 | 20240909012540_G1Qhh | ES0016 | 2024-09-13T12:07:34.567Z | 2024-09-17T12:19:00.385Z |
5046678 | 5046678 | 20240909004539_OOrCp | ES0016 | 2024-09-13T12:07:16.602Z | 2024-09-17T12:18:59.674Z |
5046586 | 5046586 | 20240909001710_huh5q | ES0016 | 2024-09-13T12:06:59.798Z | 2024-09-17T12:18:59.592Z |
5046118 | 5046118 | 20240908212326_2Jzte | ES0016 | 2024-09-13T12:05:57.535Z | 2024-09-17T12:18:58.610Z |
5040572 | 5040572 | 20240906045557_992Zb | ES0016 | 2024-09-12T12:16:16.776Z | 2024-09-14T12:23:09.971Z |
5040424 | 5040424 | 20240906040841_H42Pi | ES0016 | 2024-09-12T12:16:10.832Z | 2024-09-14T12:23:09.126Z |
5039960 | 5039960 | 20240906023603_A4MIG | ES0016 | 2024-09-12T12:15:52.901Z | 2024-09-14T12:23:06.261Z |
5039958 | 5039958 | 20240906023518_Hgs4l | ES0016 | 2024-09-12T12:15:52.859Z | 2024-09-14T12:23:06.260Z |
5039846 | 5039846 | 20240906020737_Ba4Az | ES0016 | 2024-09-12T12:15:47.361Z | 2024-09-14T12:23:05.355Z |
5039810 | 5039810 | 20240906020458_Ovm6c | ES0016 | 2024-09-12T12:15:45.829Z | 2024-09-14T12:23:04.936Z |
5039720 | 5039720 | 20240906015609_qaIK4 | ES0016 | 2024-09-12T12:15:43.327Z | 2024-09-14T12:23:04.389Z |
5039587 | 5039587 | 20240906013147_XzknH | ES0016 | 2024-09-12T12:15:38.325Z | 2024-09-14T12:23:03.589Z |
5039391 | 5039391 | 20240906004202_Lie06 | ES0016 | 2024-09-12T12:15:29.159Z | 2024-09-14T12:23:01.798Z |
5039219 | 5039219 | 20240905235452_VQUrm | ES0016 | 2024-09-12T12:15:21.569Z | 2024-09-14T12:23:00.986Z |
5038902 | 5038902 | 20240905223231_H3Gm2 | ES0016 | 2024-09-12T12:15:06.655Z | 2024-09-14T12:22:59.168Z |
5038864 | 5038864 | 20240905222251_Nwr1Q | ES0016 | 2024-09-12T12:15:05.127Z | 2024-09-14T12:22:58.866Z |
5033586 | 5033586 | 20240907031418_1FR0M | ES0016 | 2024-09-12T12:09:42.763Z | 2024-09-15T12:21:30.596Z |
5033537 | 5033537 | 20240907030701_qZ5Yw | ES0016 | 2024-09-12T12:09:38.161Z | 2024-09-15T12:21:30.409Z |
5033457 | 5033457 | 20240907030035_hy6rq | ES0016 | 2024-09-12T12:09:33.111Z | 2024-09-15T12:21:30.167Z |
5033172 | 5033172 | 20240907023310_bJEcT | ES0016 | 2024-09-12T12:08:54.575Z | 2024-09-15T12:21:29.155Z |
5032083 | 5032083 | 20240907000912_6LHFU | ES0016 | 2024-09-12T12:06:30.547Z | 2024-09-15T12:21:25.208Z |
5031922 | 5031922 | 20240906234225_yFLSE | ES0016 | 2024-09-12T12:06:05.899Z | 2024-09-15T12:21:24.686Z |
5031280 | 5031280 | 20240906211057_4TJZL | ES0016 | 2024-09-12T12:04:26.037Z | 2024-09-15T12:21:21.883Z |
5031026 | 5031026 | 20240906200602_7ZjLH | ES0016 | 2024-09-12T12:03:45.227Z | 2024-09-15T12:21:21.194Z |
5026503 | 5026503 | 20240905034459_2P6x8 | ES0016 | 2024-09-11T12:12:38.028Z | 2024-09-13T12:19:58.464Z |
5025992 | 5025992 | 20240905015538_xxr0K | ES0016 | 2024-09-11T12:11:41.580Z | 2024-09-13T12:19:56.505Z |
5025516 | 5025516 | 20240906020737_uPTPF | ES0016 | 2024-09-11T12:06:45.053Z | 2024-09-11T12:16:32.664Z |
5025480 | 5025480 | 20240906020458_q7U3x | ES0016 | 2024-09-11T12:06:41.594Z | 2024-09-11T12:16:32.649Z |
5025385 | 5025385 | 20240906015609_ig20k | ES0016 | 2024-09-11T12:06:24.217Z | 2024-09-11T12:16:32.609Z |
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);