participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,213 rows where station_code = "CA002J" 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 |
---|---|---|---|---|---|
5134461 | 5134461 | 20240916092757_SYjYn | CA002J | 2024-09-19T12:17:45.207Z | 2024-09-19T12:17:45.207Z |
5134373 | 5134373 | 20240916083923_LMwfx | CA002J | 2024-09-19T12:17:39.966Z | 2024-09-19T12:17:39.966Z |
5134367 | 5134367 | 20240916083820_G6H4u | CA002J | 2024-09-19T12:17:39.820Z | 2024-09-19T12:17:39.820Z |
5134350 | 5134350 | 20240916082930_NWG9b | CA002J | 2024-09-19T12:17:38.656Z | 2024-09-19T12:17:38.656Z |
5134332 | 5134332 | 20240916081806_2ic8S | CA002J | 2024-09-19T12:17:37.238Z | 2024-09-19T12:17:37.238Z |
5134309 | 5134309 | 20240916080055_rOACK | CA002J | 2024-09-19T12:17:36.369Z | 2024-09-19T12:17:36.369Z |
5134255 | 5134255 | 20240916073252_nWmDU | CA002J | 2024-09-19T12:17:34.003Z | 2024-09-19T12:17:34.003Z |
5134247 | 5134247 | 20240916072508_TqzUi | CA002J | 2024-09-19T12:17:33.055Z | 2024-09-19T12:17:33.055Z |
5134212 | 5134212 | 20240916064345_5d5eh | CA002J | 2024-09-19T12:17:30.703Z | 2024-09-19T12:17:30.703Z |
5134199 | 5134199 | 20240916063828_yF6nP | CA002J | 2024-09-19T12:17:29.731Z | 2024-09-19T12:17:29.731Z |
5134193 | 5134193 | 20240916063306_Af36P | CA002J | 2024-09-19T12:17:29.387Z | 2024-09-19T12:17:29.387Z |
5134167 | 5134167 | 20240916055350_VSWcX | CA002J | 2024-09-19T12:17:26.661Z | 2024-09-19T12:17:26.661Z |
5134156 | 5134156 | 20240916053923_DCtNg | CA002J | 2024-09-19T12:17:25.671Z | 2024-09-19T12:17:25.671Z |
5134136 | 5134136 | 20240916052803_XsJJH | CA002J | 2024-09-19T12:17:24.548Z | 2024-09-19T12:17:24.548Z |
5134121 | 5134121 | 20240916051534_2OiMn | CA002J | 2024-09-19T12:17:22.925Z | 2024-09-19T12:17:22.925Z |
5134083 | 5134083 | 20240916044547_Vimiv | CA002J | 2024-09-19T12:17:18.355Z | 2024-09-19T12:17:18.355Z |
5134017 | 5134017 | 20240916043136_19s2M | CA002J | 2024-09-19T12:17:16.338Z | 2024-09-19T12:17:16.338Z |
5133598 | 5133598 | 20240916034443_TD4SI | CA002J | 2024-09-19T12:17:03.305Z | 2024-09-19T12:17:03.305Z |
5133129 | 5133129 | 20240916025959_Vkt3U | CA002J | 2024-09-19T12:16:44.854Z | 2024-09-19T12:16:44.854Z |
5132253 | 5132253 | 20240916001054_89yNL | CA002J | 2024-09-19T12:16:01.674Z | 2024-09-19T12:16:01.674Z |
5130127 | 5130127 | 20240917092033_y9Qi8 | CA002J | 2024-09-19T12:12:38.176Z | 2024-09-19T12:12:38.176Z |
5130118 | 5130118 | 20240917091511_Zn2dK | CA002J | 2024-09-19T12:12:36.643Z | 2024-09-19T12:12:36.643Z |
5130037 | 5130037 | 20240917082641_ng2Cd | CA002J | 2024-09-19T12:12:28.434Z | 2024-09-19T12:12:28.434Z |
5130026 | 5130026 | 20240917081703_WG00r | CA002J | 2024-09-19T12:12:27.476Z | 2024-09-19T12:12:27.476Z |
5130013 | 5130013 | 20240917075228_2nyVe | CA002J | 2024-09-19T12:12:25.794Z | 2024-09-19T12:12:25.794Z |
5129982 | 5129982 | 20240917072644_8Qayn | CA002J | 2024-09-19T12:12:22.484Z | 2024-09-19T12:12:22.484Z |
5129980 | 5129980 | 20240917072226_KYMQs | CA002J | 2024-09-19T12:12:22.295Z | 2024-09-19T12:12:22.295Z |
5129953 | 5129953 | 20240917065743_FyhMO | CA002J | 2024-09-19T12:12:19.397Z | 2024-09-19T12:12:19.397Z |
5129912 | 5129912 | 20240917060848_Dc4RM | CA002J | 2024-09-19T12:12:16.157Z | 2024-09-19T12:12:16.157Z |
5129909 | 5129909 | 20240917060321_BFHk2 | CA002J | 2024-09-19T12:12:15.596Z | 2024-09-19T12:12:15.596Z |
5129483 | 5129483 | 20240917040419_LhNRL | CA002J | 2024-09-19T12:11:42.826Z | 2024-09-19T12:11:42.826Z |
5129236 | 5129236 | 20240917033902_CpnEj | CA002J | 2024-09-19T12:11:23.872Z | 2024-09-19T12:11:23.872Z |
5128066 | 5128066 | 20240917003217_njnLv | CA002J | 2024-09-19T12:09:59.794Z | 2024-09-19T12:09:59.794Z |
5127895 | 5127895 | 20240917000031_5khTi | CA002J | 2024-09-19T12:09:45.956Z | 2024-09-19T12:09:45.956Z |
5126066 | 5126066 | 20240918074932_r1t40 | CA002J | 2024-09-19T12:04:53.060Z | 2024-09-19T12:06:42.134Z |
5126025 | 5126025 | 20240918065432_RvACq | CA002J | 2024-09-19T12:04:46.950Z | 2024-09-19T12:06:42.127Z |
5126023 | 5126023 | 20240918065234_MIiva | CA002J | 2024-09-19T12:04:46.651Z | 2024-09-19T12:06:42.126Z |
5125935 | 5125935 | 20240918045832_LVK1Q | CA002J | 2024-09-19T12:04:35.571Z | 2024-09-19T12:06:42.111Z |
5125915 | 5125915 | 20240918043440_koHP3 | CA002J | 2024-09-19T12:04:32.773Z | 2024-09-19T12:06:42.107Z |
5125912 | 5125912 | 20240918043354_Lfgg3 | CA002J | 2024-09-19T12:04:32.411Z | 2024-09-19T12:06:42.107Z |
5125627 | 5125627 | 20240918031148_Q3qOK | CA002J | 2024-09-19T12:03:45.643Z | 2024-09-19T12:06:42.060Z |
5125554 | 5125554 | 20240918025801_0WZ5Q | CA002J | 2024-09-19T12:03:31.144Z | 2024-09-19T12:06:42.050Z |
5122919 | 5122919 | 20240914082312_h66W8 | CA002J | 2024-09-18T12:11:34.144Z | 2024-09-19T12:20:06.693Z |
5122905 | 5122905 | 20240914081902_2qdYT | CA002J | 2024-09-18T12:11:33.774Z | 2024-09-19T12:20:06.663Z |
5122862 | 5122862 | 20240914081300_9MGjw | CA002J | 2024-09-18T12:11:32.779Z | 2024-09-19T12:20:06.515Z |
5122835 | 5122835 | 20240914080618_yRtYV | CA002J | 2024-09-18T12:11:32.240Z | 2024-09-19T12:20:06.399Z |
5122802 | 5122802 | 20240914080116_7os23 | CA002J | 2024-09-18T12:11:31.655Z | 2024-09-19T12:20:06.261Z |
5122793 | 5122793 | 20240914075944_a8fgY | CA002J | 2024-09-18T12:11:31.291Z | 2024-09-19T12:20:06.192Z |
5122719 | 5122719 | 20240914073721_RJsPi | CA002J | 2024-09-18T12:11:29.246Z | 2024-09-19T12:20:05.850Z |
5122659 | 5122659 | 20240914072757_21nck | CA002J | 2024-09-18T12:11:27.222Z | 2024-09-19T12:20:05.568Z |
5122585 | 5122585 | 20240914071533_Z36gL | CA002J | 2024-09-18T12:11:24.205Z | 2024-09-19T12:20:05.210Z |
5122532 | 5122532 | 20240914070334_ZZhxU | CA002J | 2024-09-18T12:11:22.267Z | 2024-09-19T12:20:04.821Z |
5122510 | 5122510 | 20240914065642_xln3w | CA002J | 2024-09-18T12:11:21.499Z | 2024-09-19T12:20:04.691Z |
5122499 | 5122499 | 20240914065300_M2h2W | CA002J | 2024-09-18T12:11:20.948Z | 2024-09-19T12:20:04.627Z |
5122425 | 5122425 | 20240914061911_3GGG2 | CA002J | 2024-09-18T12:11:18.054Z | 2024-09-19T12:20:04.269Z |
5122348 | 5122348 | 20240914054821_Wsne3 | CA002J | 2024-09-18T12:11:15.235Z | 2024-09-19T12:20:03.984Z |
5122327 | 5122327 | 20240914053949_KfIPL | CA002J | 2024-09-18T12:11:14.467Z | 2024-09-19T12:20:03.944Z |
5122248 | 5122248 | 20240914051445_wiOtp | CA002J | 2024-09-18T12:11:11.669Z | 2024-09-19T12:20:03.502Z |
5122201 | 5122201 | 20240914045330_OybMA | CA002J | 2024-09-18T12:11:09.582Z | 2024-09-19T12:20:03.127Z |
5122187 | 5122187 | 20240914044928_BQjFZ | CA002J | 2024-09-18T12:11:08.893Z | 2024-09-19T12:20:02.950Z |
5122182 | 5122182 | 20240914044616_rX35u | CA002J | 2024-09-18T12:11:08.639Z | 2024-09-19T12:20:02.926Z |
5122164 | 5122164 | 20240914044303_2VTRG | CA002J | 2024-09-18T12:11:07.949Z | 2024-09-19T12:20:02.900Z |
5122114 | 5122114 | 20240914043633_PAQy3 | CA002J | 2024-09-18T12:11:07.410Z | 2024-09-19T12:20:02.846Z |
5120989 | 5120989 | 20240914034358_DMLnJ | CA002J | 2024-09-18T12:10:49.092Z | 2024-09-19T12:20:01.088Z |
5120094 | 5120094 | 20240914025937_nc9gU | CA002J | 2024-09-18T12:10:32.024Z | 2024-09-19T12:19:59.401Z |
5119427 | 5119427 | 20240914023228_5AHia | CA002J | 2024-09-18T12:10:21.119Z | 2024-09-19T12:19:58.175Z |
5118169 | 5118169 | 20240915084550_EZ6yq | CA002J | 2024-09-18T12:08:28.141Z | 2024-09-19T12:19:21.006Z |
5118090 | 5118090 | 20240915082908_2lavT | CA002J | 2024-09-18T12:08:23.521Z | 2024-09-19T12:19:20.283Z |
5118072 | 5118072 | 20240915082408_VrZDx | CA002J | 2024-09-18T12:08:21.966Z | 2024-09-19T12:19:20.112Z |
5118065 | 5118065 | 20240915082229_tVCI6 | CA002J | 2024-09-18T12:08:21.353Z | 2024-09-19T12:19:20.026Z |
5118027 | 5118027 | 20240915080909_9MwPW | CA002J | 2024-09-18T12:08:18.921Z | 2024-09-19T12:19:19.833Z |
5117981 | 5117981 | 20240915080446_lkLdV | CA002J | 2024-09-18T12:08:15.304Z | 2024-09-19T12:19:19.486Z |
5117965 | 5117965 | 20240915080119_2a7tn | CA002J | 2024-09-18T12:08:13.395Z | 2024-09-19T12:19:19.385Z |
5117962 | 5117962 | 20240915080118_GYgi4 | CA002J | 2024-09-18T12:08:12.104Z | 2024-09-19T12:19:19.378Z |
5117828 | 5117828 | 20240915071416_NOJy2 | CA002J | 2024-09-18T12:08:02.137Z | 2024-09-19T12:19:18.313Z |
5117817 | 5117817 | 20240915071019_ghBGM | CA002J | 2024-09-18T12:08:01.361Z | 2024-09-19T12:19:18.176Z |
5117759 | 5117759 | 20240915064945_Or3vA | CA002J | 2024-09-18T12:07:56.568Z | 2024-09-19T12:19:17.620Z |
5117640 | 5117640 | 20240915055658_dAqUL | CA002J | 2024-09-18T12:07:50.540Z | 2024-09-19T12:19:16.668Z |
5117624 | 5117624 | 20240915055434_mQubC | CA002J | 2024-09-18T12:07:49.716Z | 2024-09-19T12:19:16.517Z |
5117513 | 5117513 | 20240915045058_W0kk4 | CA002J | 2024-09-18T12:07:44.312Z | 2024-09-19T12:19:15.568Z |
5117455 | 5117455 | 20240915043444_KxIxp | CA002J | 2024-09-18T12:07:41.883Z | 2024-09-19T12:19:15.119Z |
5116334 | 5116334 | 20240915032150_Qj5Vp | CA002J | 2024-09-18T12:06:58.105Z | 2024-09-19T12:19:10.507Z |
5110470 | 5110470 | 20240911071949_ZjPKr | CA002J | 2024-09-17T12:18:11.679Z | 2024-09-19T12:21:45.071Z |
5108954 | 5108954 | 20240913081327_BQJ3Z | CA002J | 2024-09-17T12:14:21.833Z | 2024-09-19T12:20:51.291Z |
5108747 | 5108747 | 20240913071902_P80ih | CA002J | 2024-09-17T12:14:04.086Z | 2024-09-19T12:20:50.586Z |
5108728 | 5108728 | 20240913071207_FCuPG | CA002J | 2024-09-17T12:14:00.920Z | 2024-09-19T12:20:50.508Z |
5108536 | 5108536 | 20240913062107_X7YlK | CA002J | 2024-09-17T12:13:50.313Z | 2024-09-19T12:20:49.405Z |
5108483 | 5108483 | 20240913055623_nQ6aq | CA002J | 2024-09-17T12:13:47.253Z | 2024-09-19T12:20:48.977Z |
5108351 | 5108351 | 20240913045821_z2o1W | CA002J | 2024-09-17T12:13:37.834Z | 2024-09-19T12:20:48.302Z |
5107700 | 5107700 | 20240913040833_2q0B4 | CA002J | 2024-09-17T12:13:21.967Z | 2024-09-19T12:20:47.470Z |
5106081 | 5106081 | 20240913030939_Fdo7Q | CA002J | 2024-09-17T12:12:41.779Z | 2024-09-19T12:20:45.471Z |
5104904 | 5104904 | 20240913022325_Azbhp | CA002J | 2024-09-17T12:11:46.378Z | 2024-09-19T12:20:43.108Z |
5104533 | 5104533 | 20240913021434_0qPQD | CA002J | 2024-09-17T12:11:38.543Z | 2024-09-19T12:20:41.682Z |
5103166 | 5103166 | 20240914020305_iJMB4 | CA002J | 2024-09-17T12:07:54.860Z | 2024-09-19T12:19:56.731Z |
5102287 | 5102287 | 20240914011609_Lg3rp | CA002J | 2024-09-17T12:06:58.670Z | 2024-09-19T12:19:53.373Z |
5102272 | 5102272 | 20240914011456_2WFha | CA002J | 2024-09-17T12:06:57.220Z | 2024-09-19T12:19:53.149Z |
5102103 | 5102103 | 20240914010614_GBxW6 | CA002J | 2024-09-17T12:06:48.875Z | 2024-09-19T12:19:52.477Z |
5101664 | 5101664 | 20240914004206_eZySK | CA002J | 2024-09-17T12:06:07.356Z | 2024-09-19T12:19:51.185Z |
5101335 | 5101335 | 20240914001958_nfc8A | CA002J | 2024-09-17T12:05:36.015Z | 2024-09-19T12:19:50.295Z |
5095496 | 5095496 | 20240912074907_sI0BC | CA002J | 2024-09-16T12:15:43.674Z | 2024-09-19T12:21:18.689Z |
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);