participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,515 rows where station_code = "UK00A5" 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 |
---|---|---|---|---|---|
5134063 | 5134063 | 20240916043818_grZ1z | UK00A5 | 2024-09-19T12:17:17.543Z | 2024-09-19T12:17:17.543Z |
5134029 | 5134029 | 20240916043241_NJB1J | UK00A5 | 2024-09-19T12:17:16.536Z | 2024-09-19T12:17:16.536Z |
5133918 | 5133918 | 20240916041805_DQZme | UK00A5 | 2024-09-19T12:17:13.076Z | 2024-09-19T12:17:13.076Z |
5133846 | 5133846 | 20240916040939_Jnajp | UK00A5 | 2024-09-19T12:17:10.291Z | 2024-09-19T12:17:10.291Z |
5133787 | 5133787 | 20240916040518_Xlwwt | UK00A5 | 2024-09-19T12:17:07.990Z | 2024-09-19T12:17:07.990Z |
5129774 | 5129774 | 20240917042607_3EGWz | UK00A5 | 2024-09-19T12:12:03.111Z | 2024-09-19T12:12:03.111Z |
5129571 | 5129571 | 20240917041005_9rpd9 | UK00A5 | 2024-09-19T12:11:49.455Z | 2024-09-19T12:11:49.455Z |
5129441 | 5129441 | 20240917035609_0Sfo9 | UK00A5 | 2024-09-19T12:11:37.165Z | 2024-09-19T12:11:37.165Z |
5129111 | 5129111 | 20240917032028_UjnSk | UK00A5 | 2024-09-19T12:11:15.591Z | 2024-09-19T12:11:15.591Z |
5129066 | 5129066 | 20240917031357_oPadb | UK00A5 | 2024-09-19T12:11:13.301Z | 2024-09-19T12:11:13.301Z |
5129041 | 5129041 | 20240917031052_3eyt5 | UK00A5 | 2024-09-19T12:11:12.365Z | 2024-09-19T12:11:12.365Z |
5128994 | 5128994 | 20240917030403_9ogEu | UK00A5 | 2024-09-19T12:11:10.636Z | 2024-09-19T12:11:10.636Z |
5128940 | 5128940 | 20240917030039_A2uES | UK00A5 | 2024-09-19T12:11:08.818Z | 2024-09-19T12:11:08.818Z |
5128868 | 5128868 | 20240917024843_8lfcr | UK00A5 | 2024-09-19T12:11:04.080Z | 2024-09-19T12:11:04.080Z |
5128735 | 5128735 | 20240917023003_iFHPa | UK00A5 | 2024-09-19T12:10:59.443Z | 2024-09-19T12:10:59.443Z |
5128727 | 5128727 | 20240917022613_J2bup | UK00A5 | 2024-09-19T12:10:58.950Z | 2024-09-19T12:10:58.950Z |
5128663 | 5128663 | 20240917022323_SqLcF | UK00A5 | 2024-09-19T12:10:54.702Z | 2024-09-19T12:10:54.702Z |
5128623 | 5128623 | 20240917020932_OGMRa | UK00A5 | 2024-09-19T12:10:48.280Z | 2024-09-19T12:10:48.280Z |
5128575 | 5128575 | 20240917020531_29WjF | UK00A5 | 2024-09-19T12:10:44.194Z | 2024-09-19T12:10:44.194Z |
5128480 | 5128480 | 20240917014807_us3hY | UK00A5 | 2024-09-19T12:10:37.365Z | 2024-09-19T12:10:37.365Z |
5128446 | 5128446 | 20240917014244_XuzZ7 | UK00A5 | 2024-09-19T12:10:34.657Z | 2024-09-19T12:10:34.657Z |
5128216 | 5128216 | 20240917010746_jVw0C | UK00A5 | 2024-09-19T12:10:20.295Z | 2024-09-19T12:10:20.295Z |
5128143 | 5128143 | 20240917004738_p3zvx | UK00A5 | 2024-09-19T12:10:08.468Z | 2024-09-19T12:10:08.468Z |
5127993 | 5127993 | 20240917001818_Y0BQQ | UK00A5 | 2024-09-19T12:09:53.011Z | 2024-09-19T12:09:53.011Z |
5127848 | 5127848 | 20240916234900_vT2pR | UK00A5 | 2024-09-19T12:09:43.415Z | 2024-09-19T12:09:43.415Z |
5127763 | 5127763 | 20240916232351_gO9sb | UK00A5 | 2024-09-19T12:09:36.753Z | 2024-09-19T12:09:36.753Z |
5127657 | 5127657 | 20240916224526_M9Tpa | UK00A5 | 2024-09-19T12:09:29.558Z | 2024-09-19T12:09:29.558Z |
5127637 | 5127637 | 20240916223824_kxTy6 | UK00A5 | 2024-09-19T12:09:27.862Z | 2024-09-19T12:09:27.862Z |
5127285 | 5127285 | 20240916211259_3j3gG | UK00A5 | 2024-09-19T12:08:47.030Z | 2024-09-19T12:08:47.030Z |
5127256 | 5127256 | 20240916210951_JbHKt | UK00A5 | 2024-09-19T12:08:42.565Z | 2024-09-19T12:08:42.565Z |
5127172 | 5127172 | 20240916204128_qXLJc | UK00A5 | 2024-09-19T12:08:24.167Z | 2024-09-19T12:08:24.167Z |
5127080 | 5127080 | 20240916202243_nzBeZ | UK00A5 | 2024-09-19T12:08:06.736Z | 2024-09-19T12:08:06.736Z |
5126981 | 5126981 | 20240916200135_rzLZ6 | UK00A5 | 2024-09-19T12:07:49.259Z | 2024-09-19T12:07:49.259Z |
5126901 | 5126901 | 20240916194827_mMq2i | UK00A5 | 2024-09-19T12:07:36.456Z | 2024-09-19T12:07:36.456Z |
5125007 | 5125007 | 20240917232204_e03pO | UK00A5 | 2024-09-19T12:01:55.675Z | 2024-09-19T12:06:41.960Z |
5124993 | 5124993 | 20240917232025_Apysy | UK00A5 | 2024-09-19T12:01:54.932Z | 2024-09-19T12:06:41.959Z |
5124887 | 5124887 | 20240917223523_WW6Ik | UK00A5 | 2024-09-19T12:01:44.005Z | 2024-09-19T12:06:41.946Z |
5124768 | 5124768 | 20240917215838_vwtSd | UK00A5 | 2024-09-19T12:01:33.138Z | 2024-09-19T12:06:41.932Z |
5124753 | 5124753 | 20240917215732_2fFnj | UK00A5 | 2024-09-19T12:01:32.185Z | 2024-09-19T12:06:41.931Z |
5124671 | 5124671 | 20240917214605_w34ej | UK00A5 | 2024-09-19T12:01:18.321Z | 2024-09-19T12:06:41.923Z |
5124505 | 5124505 | 20240917205352_VHVXe | UK00A5 | 2024-09-19T12:01:03.842Z | 2024-09-19T12:06:41.905Z |
5124327 | 5124327 | 20240917193253_dDDn1 | UK00A5 | 2024-09-19T12:00:34.172Z | 2024-09-19T12:06:41.877Z |
5122178 | 5122178 | 20240914044427_G92Nh | UK00A5 | 2024-09-18T12:11:08.491Z | 2024-09-19T12:20:02.923Z |
5122078 | 5122078 | 20240914043057_QqBh3 | UK00A5 | 2024-09-18T12:11:05.320Z | 2024-09-19T12:20:02.721Z |
5122036 | 5122036 | 20240914042820_mJEfX | UK00A5 | 2024-09-18T12:11:05.023Z | 2024-09-19T12:20:02.705Z |
5121983 | 5121983 | 20240914042323_4l1UM | UK00A5 | 2024-09-18T12:11:03.681Z | 2024-09-19T12:20:02.557Z |
5121729 | 5121729 | 20240914041316_4Y90Q | UK00A5 | 2024-09-18T12:11:00.978Z | 2024-09-19T12:20:02.318Z |
5121687 | 5121687 | 20240914041207_LDHts | UK00A5 | 2024-09-18T12:10:59.349Z | 2024-09-19T12:20:02.212Z |
5121586 | 5121586 | 20240914040948_nTfFQ | UK00A5 | 2024-09-18T12:10:58.551Z | 2024-09-19T12:20:02.140Z |
5121510 | 5121510 | 20240914040632_tqKgU | UK00A5 | 2024-09-18T12:10:57.679Z | 2024-09-19T12:20:02.011Z |
5121399 | 5121399 | 20240914035911_Tv6J3 | UK00A5 | 2024-09-18T12:10:54.723Z | 2024-09-19T12:20:01.708Z |
5121102 | 5121102 | 20240914035213_piLCa | UK00A5 | 2024-09-18T12:10:51.213Z | 2024-09-19T12:20:01.362Z |
5120974 | 5120974 | 20240914034301_pu1Yj | UK00A5 | 2024-09-18T12:10:48.931Z | 2024-09-19T12:20:01.080Z |
5120574 | 5120574 | 20240914032806_ymlDa | UK00A5 | 2024-09-18T12:10:43.226Z | 2024-09-19T12:20:00.607Z |
5120514 | 5120514 | 20240914032557_QEKEm | UK00A5 | 2024-09-18T12:10:42.495Z | 2024-09-19T12:20:00.512Z |
5120425 | 5120425 | 20240914032020_biyKl | UK00A5 | 2024-09-18T12:10:39.710Z | 2024-09-19T12:20:00.207Z |
5120188 | 5120188 | 20240914030406_bq1eN | UK00A5 | 2024-09-18T12:10:33.621Z | 2024-09-19T12:19:59.538Z |
5119968 | 5119968 | 20240914025452_2jk3k | UK00A5 | 2024-09-18T12:10:30.091Z | 2024-09-19T12:19:59.202Z |
5119876 | 5119876 | 20240914025122_ie63A | UK00A5 | 2024-09-18T12:10:28.275Z | 2024-09-19T12:19:59.033Z |
5119739 | 5119739 | 20240914024608_v3ZnX | UK00A5 | 2024-09-18T12:10:24.624Z | 2024-09-19T12:19:58.797Z |
5119702 | 5119702 | 20240914024409_2ORk2 | UK00A5 | 2024-09-18T12:10:24.337Z | 2024-09-19T12:19:58.751Z |
5119577 | 5119577 | 20240914023927_OhmTT | UK00A5 | 2024-09-18T12:10:22.440Z | 2024-09-19T12:19:58.542Z |
5119192 | 5119192 | 20240914021639_pPkX5 | UK00A5 | 2024-09-18T12:10:18.066Z | 2024-09-19T12:19:57.353Z |
5117468 | 5117468 | 20240915043603_zgEHc | UK00A5 | 2024-09-18T12:07:42.150Z | 2024-09-19T12:19:15.157Z |
5117305 | 5117305 | 20240915041701_tua1A | UK00A5 | 2024-09-18T12:07:37.382Z | 2024-09-19T12:19:14.189Z |
5117264 | 5117264 | 20240915041543_32kqX | UK00A5 | 2024-09-18T12:07:36.388Z | 2024-09-19T12:19:14.055Z |
5117242 | 5117242 | 20240915041438_lwds4 | UK00A5 | 2024-09-18T12:07:35.964Z | 2024-09-19T12:19:13.959Z |
5117170 | 5117170 | 20240915040711_ETWrb | UK00A5 | 2024-09-18T12:07:34.310Z | 2024-09-19T12:19:13.674Z |
5117092 | 5117092 | 20240915040200_ac18K | UK00A5 | 2024-09-18T12:07:32.511Z | 2024-09-19T12:19:13.307Z |
5116920 | 5116920 | 20240915035049_22WOy | UK00A5 | 2024-09-18T12:07:26.246Z | 2024-09-19T12:19:12.762Z |
5116815 | 5116815 | 20240915034322_raSAp | UK00A5 | 2024-09-18T12:07:21.765Z | 2024-09-19T12:19:12.427Z |
5116719 | 5116719 | 20240915033724_p3md7 | UK00A5 | 2024-09-18T12:07:17.601Z | 2024-09-19T12:19:12.115Z |
5116455 | 5116455 | 20240915032640_CI2LX | UK00A5 | 2024-09-18T12:07:03.972Z | 2024-09-19T12:19:11.202Z |
5116358 | 5116358 | 20240915032341_RXHs5 | UK00A5 | 2024-09-18T12:06:59.896Z | 2024-09-19T12:19:10.635Z |
5115415 | 5115415 | 20240915023653_YvvWz | UK00A5 | 2024-09-18T12:06:13.123Z | 2024-09-19T12:19:04.541Z |
5114268 | 5114268 | 20240915013416_YFd5H | UK00A5 | 2024-09-18T12:05:09.097Z | 2024-09-19T12:18:57.332Z |
5114204 | 5114204 | 20240915013034_k8F25 | UK00A5 | 2024-09-18T12:05:06.105Z | 2024-09-19T12:18:56.698Z |
5114130 | 5114130 | 20240915012759_VBJvG | UK00A5 | 2024-09-18T12:05:03.190Z | 2024-09-19T12:18:56.190Z |
5114050 | 5114050 | 20240915012349_L3tux | UK00A5 | 2024-09-18T12:04:59.893Z | 2024-09-19T12:18:55.472Z |
5113819 | 5113819 | 20240915011405_FkSd0 | UK00A5 | 2024-09-18T12:04:51.278Z | 2024-09-19T12:18:52.849Z |
5113727 | 5113727 | 20240915010931_FdGLR | UK00A5 | 2024-09-18T12:04:47.259Z | 2024-09-19T12:18:51.793Z |
5113519 | 5113519 | 20240915005446_Yn58m | UK00A5 | 2024-09-18T12:04:25.457Z | 2024-09-19T12:18:49.833Z |
5113308 | 5113308 | 20240915003646_pb17F | UK00A5 | 2024-09-18T12:04:06.691Z | 2024-09-19T12:18:48.424Z |
5113206 | 5113206 | 20240915003144_fsUq3 | UK00A5 | 2024-09-18T12:04:02.988Z | 2024-09-19T12:18:47.997Z |
5112420 | 5112420 | 20240914230850_lknFa | UK00A5 | 2024-09-18T12:03:03.041Z | 2024-09-19T12:18:40.896Z |
5112410 | 5112410 | 20240914230809_UazIM | UK00A5 | 2024-09-18T12:03:02.637Z | 2024-09-19T12:18:40.822Z |
5112336 | 5112336 | 20240914225935_jTITy | UK00A5 | 2024-09-18T12:03:00.364Z | 2024-09-19T12:18:40.597Z |
5111618 | 5111618 | 20240914205333_QU30U | UK00A5 | 2024-09-18T12:02:07.598Z | 2024-09-19T12:18:32.533Z |
5111460 | 5111460 | 20240914203854_h2uv5 | UK00A5 | 2024-09-18T12:01:57.490Z | 2024-09-19T12:18:30.434Z |
5111430 | 5111430 | 20240914203608_z6s2s | UK00A5 | 2024-09-18T12:01:55.887Z | 2024-09-19T12:18:30.113Z |
5111407 | 5111407 | 20240914203244_ruBHL | UK00A5 | 2024-09-18T12:01:55.176Z | 2024-09-19T12:18:30.041Z |
5111337 | 5111337 | 20240914202259_6rxme | UK00A5 | 2024-09-18T12:01:49.849Z | 2024-09-19T12:18:29.098Z |
5111203 | 5111203 | 20240914201029_UzkhC | UK00A5 | 2024-09-18T12:01:43.098Z | 2024-09-19T12:18:27.404Z |
5110972 | 5110972 | 20240914193533_21BcZ | UK00A5 | 2024-09-18T12:01:16.527Z | 2024-09-19T12:18:25.156Z |
5108106 | 5108106 | 20240913042319_y99Cu | UK00A5 | 2024-09-17T12:13:30.489Z | 2024-09-19T12:20:47.844Z |
5107989 | 5107989 | 20240913041805_2A8dr | UK00A5 | 2024-09-17T12:13:26.713Z | 2024-09-19T12:20:47.708Z |
5107928 | 5107928 | 20240913041500_M9G1b | UK00A5 | 2024-09-17T12:13:25.945Z | 2024-09-19T12:20:47.637Z |
5107874 | 5107874 | 20240913041258_mvVaL | UK00A5 | 2024-09-17T12:13:25.324Z | 2024-09-19T12:20:47.622Z |
5107648 | 5107648 | 20240913040744_ph42q | UK00A5 | 2024-09-17T12:13:20.693Z | 2024-09-19T12:20:47.439Z |
5107315 | 5107315 | 20240913035232_zyLs8 | UK00A5 | 2024-09-17T12:13:13.102Z | 2024-09-19T12:20:46.995Z |
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);