participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,781 rows where station_code = "ES000T" 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 |
---|---|---|---|---|---|
5133893 | 5133893 | 20240916041526_zDne5 | ES000T | 2024-09-19T12:17:12.538Z | 2024-09-19T12:17:12.538Z |
5133348 | 5133348 | 20240916032448_H8NU7 | ES000T | 2024-09-19T12:16:54.705Z | 2024-09-19T12:16:54.705Z |
5133235 | 5133235 | 20240916031130_6Ckxh | ES000T | 2024-09-19T12:16:51.064Z | 2024-09-19T12:16:51.064Z |
5133231 | 5133231 | 20240916031035_XIc1j | ES000T | 2024-09-19T12:16:50.554Z | 2024-09-19T12:16:50.554Z |
5133048 | 5133048 | 20240916024800_ZyJb2 | ES000T | 2024-09-19T12:16:42.531Z | 2024-09-19T12:16:42.531Z |
5121868 | 5121868 | 20240914041747_txPHp | ES000T | 2024-09-18T12:11:02.390Z | 2024-09-19T12:20:02.450Z |
5121859 | 5121859 | 20240914041722_M932h | ES000T | 2024-09-18T12:11:02.317Z | 2024-09-19T12:20:02.442Z |
5121776 | 5121776 | 20240914041359_aVaNw | ES000T | 2024-09-18T12:11:01.269Z | 2024-09-19T12:20:02.367Z |
5121701 | 5121701 | 20240914041222_obvdM | ES000T | 2024-09-18T12:10:59.681Z | 2024-09-19T12:20:02.240Z |
5121132 | 5121132 | 20240914035334_7vL26 | ES000T | 2024-09-18T12:10:51.426Z | 2024-09-19T12:20:01.415Z |
5120867 | 5120867 | 20240914033857_Xndsn | ES000T | 2024-09-18T12:10:48.201Z | 2024-09-19T12:20:00.978Z |
5120330 | 5120330 | 20240914031553_sNrSK | ES000T | 2024-09-18T12:10:37.437Z | 2024-09-19T12:19:59.911Z |
5119994 | 5119994 | 20240914025553_WI4HT | ES000T | 2024-09-18T12:10:30.916Z | 2024-09-19T12:19:59.296Z |
5119861 | 5119861 | 20240914025121_DN3pM | ES000T | 2024-09-18T12:10:28.256Z | 2024-09-19T12:19:59.029Z |
5119455 | 5119455 | 20240914023532_WBQtQ | ES000T | 2024-09-18T12:10:21.516Z | 2024-09-19T12:19:58.284Z |
5119453 | 5119453 | 20240914023510_BA16A | ES000T | 2024-09-18T12:10:21.466Z | 2024-09-19T12:19:58.274Z |
5119430 | 5119430 | 20240914023258_bNw2l | ES000T | 2024-09-18T12:10:21.215Z | 2024-09-19T12:19:58.237Z |
5119055 | 5119055 | 20240914020659_pD930 | ES000T | 2024-09-18T12:10:15.442Z | 2024-09-19T12:19:56.995Z |
5116878 | 5116878 | 20240915034541_uwNSY | ES000T | 2024-09-18T12:07:24.126Z | 2024-09-19T12:19:12.514Z |
5115755 | 5115755 | 20240915025213_4NbTm | ES000T | 2024-09-18T12:06:23.005Z | 2024-09-19T12:19:06.768Z |
5115440 | 5115440 | 20240915023829_MqzOW | ES000T | 2024-09-18T12:06:14.366Z | 2024-09-19T12:19:04.746Z |
5115048 | 5115048 | 20240915021601_RsBR2 | ES000T | 2024-09-18T12:05:53.796Z | 2024-09-19T12:19:01.236Z |
5114949 | 5114949 | 20240915020928_gJ2y4 | ES000T | 2024-09-18T12:05:45.498Z | 2024-09-19T12:19:00.727Z |
5114365 | 5114365 | 20240915013924_3nyDT | ES000T | 2024-09-18T12:05:13.530Z | 2024-09-19T12:18:57.827Z |
5114239 | 5114239 | 20240915013334_Reifx | ES000T | 2024-09-18T12:05:08.503Z | 2024-09-19T12:18:57.226Z |
5113539 | 5113539 | 20240915005645_9B7oY | ES000T | 2024-09-18T12:04:26.900Z | 2024-09-19T12:18:50.079Z |
5107997 | 5107997 | 20240913041825_Dtvff | ES000T | 2024-09-17T12:13:27.419Z | 2024-09-19T12:20:47.735Z |
5107995 | 5107995 | 20240913041818_y5fTz | ES000T | 2024-09-17T12:13:27.322Z | 2024-09-19T12:20:47.722Z |
5107690 | 5107690 | 20240913040820_b3BVG | ES000T | 2024-09-17T12:13:21.598Z | 2024-09-19T12:20:47.455Z |
5106848 | 5106848 | 20240913033721_TG6lE | ES000T | 2024-09-17T12:13:03.139Z | 2024-09-19T12:20:46.494Z |
5105791 | 5105791 | 20240913025841_nHxS3 | ES000T | 2024-09-17T12:12:29.168Z | 2024-09-19T12:20:44.923Z |
5105106 | 5105106 | 20240913023046_k7cdz | ES000T | 2024-09-17T12:11:55.414Z | 2024-09-19T12:20:43.673Z |
5102933 | 5102933 | 20240914015509_19C6N | ES000T | 2024-09-17T12:07:44.484Z | 2024-09-19T12:19:56.168Z |
5102313 | 5102313 | 20240914011907_yhbAh | ES000T | 2024-09-17T12:07:00.185Z | 2024-09-19T12:19:53.408Z |
5102262 | 5102262 | 20240914011315_71MhS | ES000T | 2024-09-17T12:06:56.299Z | 2024-09-19T12:19:53.120Z |
5101555 | 5101555 | 20240914003441_Ybq5R | ES000T | 2024-09-17T12:06:01.092Z | 2024-09-19T12:19:50.925Z |
5101045 | 5101045 | 20240913235832_49enY | ES000T | 2024-09-17T12:05:16.072Z | 2024-09-19T12:19:49.568Z |
5100121 | 5100121 | 20240913225355_0FT0e | ES000T | 2024-09-17T12:03:59.854Z | 2024-09-19T12:19:46.955Z |
5087680 | 5087680 | 20240912233930_gaIFF | ES000T | 2024-09-16T12:07:13.540Z | 2024-09-19T12:20:35.554Z |
5085752 | 5085752 | 20240912214823_uz8Mj | ES000T | 2024-09-16T12:04:52.408Z | 2024-09-19T12:20:29.572Z |
5046654 | 5046654 | 20240909003452_jikDH | ES000T | 2024-09-13T12:07:14.058Z | 2024-09-17T12:18:59.647Z |
5025713 | 5025713 | 20240905005926_3Ac6s | ES000T | 2024-09-11T12:10:50.571Z | 2024-09-13T12:19:55.239Z |
5020130 | 5020130 | 20240905005926_TSEiD | ES000T | 2024-09-10T12:13:57.697Z | 2024-09-13T12:19:55.241Z |
4983019 | 4983019 | 20240812004032_C6yFe | ES000T | 2024-09-06T12:15:11.809Z | 2024-09-06T12:15:11.809Z |
4982468 | 4982468 | 20240812003346_2cJiF | ES000T | 2024-09-06T12:14:52.622Z | 2024-09-06T12:14:52.622Z |
4980058 | 4980058 | 20240812000758_vjYpI | ES000T | 2024-09-06T12:13:45.468Z | 2024-09-06T12:13:45.468Z |
4979089 | 4979089 | 20240811235920_qkpwE | ES000T | 2024-09-06T12:12:57.034Z | 2024-09-06T12:12:57.034Z |
4978676 | 4978676 | 20240811235331_sb31J | ES000T | 2024-09-06T12:12:40.646Z | 2024-09-06T12:12:40.646Z |
4978635 | 4978635 | 20240811235311_37JbL | ES000T | 2024-09-06T12:12:38.205Z | 2024-09-06T12:12:38.205Z |
4978496 | 4978496 | 20240811235141_794A3 | ES000T | 2024-09-06T12:12:34.932Z | 2024-09-06T12:12:34.932Z |
4976587 | 4976587 | 20240811233206_dGxhf | ES000T | 2024-09-06T12:11:40.214Z | 2024-09-06T12:11:40.214Z |
4975936 | 4975936 | 20240811232329_uKnu8 | ES000T | 2024-09-06T12:10:57.152Z | 2024-09-06T12:10:57.152Z |
4974681 | 4974681 | 20240811230947_cmO2v | ES000T | 2024-09-05T12:11:29.435Z | 2024-09-06T12:10:30.480Z |
4974382 | 4974382 | 20240811230629_BhbxR | ES000T | 2024-09-05T12:11:23.853Z | 2024-09-06T12:10:26.123Z |
4974243 | 4974243 | 20240811230450_O207e | ES000T | 2024-09-05T12:11:21.230Z | 2024-09-06T12:10:24.047Z |
4973968 | 4973968 | 20240811230213_bcsw6 | ES000T | 2024-09-05T12:11:15.366Z | 2024-09-06T12:10:13.322Z |
4970501 | 4970501 | 20240811222614_AZ34t | ES000T | 2024-09-05T12:09:27.608Z | 2024-09-06T12:08:41.265Z |
4970308 | 4970308 | 20240811222355_oTySk | ES000T | 2024-09-05T12:09:24.251Z | 2024-09-06T12:08:36.950Z |
4970290 | 4970290 | 20240811222334_jZM2Z | ES000T | 2024-09-05T12:09:23.554Z | 2024-09-06T12:08:35.802Z |
4970135 | 4970135 | 20240811222126_sgilI | ES000T | 2024-09-05T12:09:19.433Z | 2024-09-06T12:08:25.535Z |
4969736 | 4969736 | 20240811221534_j3eJ4 | ES000T | 2024-09-05T12:08:58.215Z | 2024-09-06T12:08:01.012Z |
4967357 | 4967357 | 20240811214301_2MsWq | ES000T | 2024-09-05T12:07:36.466Z | 2024-09-06T12:06:57.609Z |
4965333 | 4965333 | 20240811211323_RW3ix | ES000T | 2024-09-04T12:06:54.939Z | 2024-09-06T12:05:54.021Z |
4964966 | 4964966 | 20240811210635_MN2eL | ES000T | 2024-09-04T12:06:40.153Z | 2024-09-06T12:05:44.306Z |
4964454 | 4964454 | 20240811205446_oU02n | ES000T | 2024-09-04T12:06:22.305Z | 2024-09-06T12:05:20.574Z |
4964038 | 4964038 | 20240811204349_pzHuo | ES000T | 2024-09-04T12:06:05.067Z | 2024-09-06T12:05:09.102Z |
4955124 | 4955124 | 20240811034319_UXgM0 | ES000T | 2024-09-03T12:18:45.990Z | 2024-09-06T12:29:19.911Z |
4954989 | 4954989 | 20240811032125_6YPSJ | ES000T | 2024-09-03T12:18:33.360Z | 2024-09-06T12:29:14.273Z |
4954980 | 4954980 | 20240811032055_y63ee | ES000T | 2024-09-03T12:18:32.592Z | 2024-09-06T12:29:13.972Z |
4954856 | 4954856 | 20240811031304_lOVMv | ES000T | 2024-09-03T12:18:22.030Z | 2024-09-06T12:29:10.163Z |
4954616 | 4954616 | 20240811030610_bQfC3 | ES000T | 2024-09-03T12:18:17.724Z | 2024-09-06T12:29:04.862Z |
4954340 | 4954340 | 20240811025802_wub3P | ES000T | 2024-09-03T12:18:12.045Z | 2024-09-06T12:28:57.424Z |
4953611 | 4953611 | 20240811024152_ymQzy | ES000T | 2024-09-03T12:17:50.913Z | 2024-09-06T12:28:32.514Z |
4952596 | 4952596 | 20240811022434_LucJ5 | ES000T | 2024-09-03T12:17:02.530Z | 2024-09-06T12:28:06.037Z |
4952434 | 4952434 | 20240811022136_gTMa5 | ES000T | 2024-09-03T12:16:58.055Z | 2024-09-06T12:28:01.503Z |
4950313 | 4950313 | 20240811020512_6WDcK | ES000T | 2024-09-02T12:16:21.853Z | 2024-09-06T12:27:43.163Z |
4947570 | 4947570 | 20240811012048_HtScU | ES000T | 2024-09-02T12:14:37.717Z | 2024-09-06T12:26:54.782Z |
4946894 | 4946894 | 20240811010938_vYprG | ES000T | 2024-09-02T12:14:11.038Z | 2024-09-06T12:26:39.189Z |
4946875 | 4946875 | 20240811010901_MRH2N | ES000T | 2024-09-02T12:14:10.478Z | 2024-09-06T12:26:38.631Z |
4946575 | 4946575 | 20240811010259_52kFM | ES000T | 2024-09-02T12:14:01.183Z | 2024-09-06T12:26:27.073Z |
4945681 | 4945681 | 20240811005017_tdK8r | ES000T | 2024-09-02T12:13:23.177Z | 2024-09-06T12:26:02.344Z |
4944183 | 4944183 | 20240811002503_YJ7el | ES000T | 2024-09-02T12:12:24.346Z | 2024-09-06T12:25:15.102Z |
4942661 | 4942661 | 20240810235515_mdhPo | ES000T | 2024-09-02T12:11:25.690Z | 2024-09-06T12:24:25.285Z |
4941738 | 4941738 | 20240810233841_hOOMK | ES000T | 2024-09-02T12:10:44.644Z | 2024-09-06T12:23:52.361Z |
4937852 | 4937852 | 20240810220136_fzTzy | ES000T | 2024-09-01T12:08:39.715Z | 2024-09-06T12:22:34.629Z |
4936952 | 4936952 | 20240810213607_CnbRW | ES000T | 2024-09-01T12:07:57.356Z | 2024-09-06T12:21:53.976Z |
4936693 | 4936693 | 20240810212704_9812V | ES000T | 2024-09-01T12:07:41.542Z | 2024-09-06T12:21:44.191Z |
4936280 | 4936280 | 20240810210902_i2qV6 | ES000T | 2024-09-01T12:07:23.239Z | 2024-09-06T12:21:25.390Z |
4935819 | 4935819 | 20240810204602_UNF2J | ES000T | 2024-09-01T12:06:55.024Z | 2024-09-06T12:21:00.540Z |
4929346 | 4929346 | 20240810034044_Rj5jv | ES000T | 2024-08-31T12:22:02.180Z | 2024-09-02T12:29:32.173Z |
4929266 | 4929266 | 20240810032046_Ljwez | ES000T | 2024-08-31T12:21:56.093Z | 2024-09-02T12:29:30.466Z |
4929219 | 4929219 | 20240810031341_6HzoU | ES000T | 2024-08-31T12:21:54.627Z | 2024-09-02T12:29:29.646Z |
4929191 | 4929191 | 20240810031027_NEYJe | ES000T | 2024-08-31T12:21:53.821Z | 2024-09-02T12:29:29.079Z |
4928787 | 4928787 | 20240810024941_FZfat | ES000T | 2024-08-31T12:21:39.610Z | 2024-09-02T12:29:18.526Z |
4926397 | 4926397 | 20240810014824_Nl7dR | ES000T | 2024-08-31T12:19:37.719Z | 2024-09-02T12:27:48.682Z |
4923267 | 4923267 | 20240810013727_qaT4j | ES000T | 2024-08-30T12:15:19.662Z | 2024-09-02T12:27:39.725Z |
4923243 | 4923243 | 20240810013634_bO5BH | ES000T | 2024-08-30T12:15:16.364Z | 2024-09-02T12:27:38.865Z |
4921567 | 4921567 | 20240810005846_TZt7w | ES000T | 2024-08-30T12:14:15.023Z | 2024-09-02T12:27:06.094Z |
4921306 | 4921306 | 20240810005143_wTjtz | ES000T | 2024-08-30T12:14:03.984Z | 2024-09-02T12:26:55.640Z |
4921251 | 4921251 | 20240810005030_WN2PI | ES000T | 2024-08-30T12:14:01.057Z | 2024-09-02T12:26:54.341Z |
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);