participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,518 rows where station_code = "UK0088" 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 |
---|---|---|---|---|---|
5502333 | 5502333 | 20241107180840_5cnXU | UK0088 | 2024-11-09T14:11:11.533Z | 2024-11-09T14:16:28.006Z |
5410893 | 5410893 | 20241027054715_Oo4Uh | UK0088 | 2024-10-29T12:18:09.425Z | 2024-11-04T14:29:05.992Z |
5410798 | 5410798 | 20241027053748_lNw7V | UK0088 | 2024-10-29T12:18:05.218Z | 2024-11-04T14:29:05.500Z |
5410655 | 5410655 | 20241027052553_C9o85 | UK0088 | 2024-10-29T12:18:02.170Z | 2024-11-04T14:29:05.201Z |
5410001 | 5410001 | 20241027044732_8VXYk | UK0088 | 2024-10-29T12:17:45.663Z | 2024-11-04T14:29:03.248Z |
5409912 | 5409912 | 20241027044129_WoBRi | UK0088 | 2024-10-29T12:17:43.926Z | 2024-11-04T14:29:02.919Z |
5409793 | 5409793 | 20241027043606_kmwok | UK0088 | 2024-10-29T12:17:41.045Z | 2024-11-04T14:29:02.641Z |
5409589 | 5409589 | 20241027042722_QJHXP | UK0088 | 2024-10-29T12:17:31.883Z | 2024-11-04T14:29:01.968Z |
5409039 | 5409039 | 20241027035620_lO7ic | UK0088 | 2024-10-29T12:17:02.522Z | 2024-11-04T14:29:00.975Z |
5409032 | 5409032 | 20241027035609_2adAb | UK0088 | 2024-10-29T12:17:02.016Z | 2024-11-04T14:29:00.946Z |
5408947 | 5408947 | 20241027035101_vr3cI | UK0088 | 2024-10-29T12:16:57.866Z | 2024-11-04T14:29:00.850Z |
5407860 | 5407860 | 20241027025540_jtxy4 | UK0088 | 2024-10-29T12:15:49.326Z | 2024-11-04T14:28:58.248Z |
5407673 | 5407673 | 20241027024651_pn9Md | UK0088 | 2024-10-29T12:15:33.945Z | 2024-11-04T14:28:58.025Z |
5407648 | 5407648 | 20241027024601_CRwBp | UK0088 | 2024-10-29T12:15:32.989Z | 2024-11-04T14:28:58.016Z |
5406914 | 5406914 | 20241027020859_wTtO3 | UK0088 | 2024-10-29T12:14:56.874Z | 2024-11-04T14:28:56.659Z |
5406867 | 5406867 | 20241027020507_Do6P0 | UK0088 | 2024-10-29T12:14:51.891Z | 2024-11-04T14:28:56.527Z |
5406636 | 5406636 | 20241027015121_e4x6F | UK0088 | 2024-10-29T12:14:27.693Z | 2024-11-04T14:28:55.961Z |
5406244 | 5406244 | 20241027012331_BbnsN | UK0088 | 2024-10-29T12:13:59.057Z | 2024-11-04T14:28:55.249Z |
5405792 | 5405792 | 20241027005853_nEioo | UK0088 | 2024-10-29T12:13:17.975Z | 2024-11-04T14:28:54.246Z |
5405744 | 5405744 | 20241027005515_H1z5l | UK0088 | 2024-10-29T12:13:11.528Z | 2024-11-04T14:28:54.130Z |
5405605 | 5405605 | 20241027004844_DqvRx | UK0088 | 2024-10-29T12:13:04.421Z | 2024-11-04T14:28:53.701Z |
5405213 | 5405213 | 20241027002342_FXWm3 | UK0088 | 2024-10-29T12:12:43.204Z | 2024-11-04T14:28:52.978Z |
5404785 | 5404785 | 20241026235232_SMQBs | UK0088 | 2024-10-29T12:11:57.674Z | 2024-11-04T14:28:51.938Z |
5404221 | 5404221 | 20241026230945_ODPQl | UK0088 | 2024-10-29T12:11:01.403Z | 2024-11-04T14:28:50.491Z |
5403495 | 5403495 | 20241026220427_0KW3z | UK0088 | 2024-10-29T12:09:37.703Z | 2024-11-04T14:28:49.028Z |
5403462 | 5403462 | 20241026220004_wpjIV | UK0088 | 2024-10-29T12:09:34.027Z | 2024-11-04T14:28:48.915Z |
5400095 | 5400095 | 20241026053911_5smiy | UK0088 | 2024-10-28T12:20:22.908Z | 2024-11-03T14:27:41.299Z |
5399939 | 5399939 | 20241026051353_U4dCz | UK0088 | 2024-10-28T12:20:17.249Z | 2024-11-03T14:27:40.882Z |
5399226 | 5399226 | 20241026040325_OaDjC | UK0088 | 2024-10-28T12:19:51.838Z | 2024-11-03T14:27:39.269Z |
5399225 | 5399225 | 20241026040252_3pRY3 | UK0088 | 2024-10-28T12:19:51.688Z | 2024-11-03T14:27:39.256Z |
5398944 | 5398944 | 20241026033952_Jb2a3 | UK0088 | 2024-10-28T12:19:40.960Z | 2024-11-03T14:27:38.686Z |
5398823 | 5398823 | 20241026033148_9GcLR | UK0088 | 2024-10-28T12:19:35.538Z | 2024-11-03T14:27:38.270Z |
5398369 | 5398369 | 20241026025037_OIqTF | UK0088 | 2024-10-28T12:19:12.907Z | 2024-11-03T14:27:36.106Z |
5385844 | 5385844 | 20241024233606_3fxZp | UK0088 | 2024-10-27T12:19:28.489Z | 2024-11-02T12:28:30.311Z |
5383933 | 5383933 | 20241024191617_ZbuQG | UK0088 | 2024-10-27T12:16:27.970Z | 2024-11-02T12:28:26.575Z |
5383887 | 5383887 | 20241024191228_4k21S | UK0088 | 2024-10-27T12:16:20.729Z | 2024-11-02T12:28:26.525Z |
5378137 | 5378137 | 20241024052921_lyz6U | UK0088 | 2024-10-26T12:22:55.124Z | 2024-11-01T12:27:03.297Z |
5378135 | 5378135 | 20241024052913_QUk3R | UK0088 | 2024-10-26T12:22:54.941Z | 2024-11-01T12:27:03.297Z |
5378090 | 5378090 | 20241024052655_F3qRJ | UK0088 | 2024-10-26T12:22:54.390Z | 2024-11-01T12:27:03.280Z |
5377938 | 5377938 | 20241024051807_eLxdM | UK0088 | 2024-10-26T12:22:50.359Z | 2024-11-01T12:27:03.168Z |
5377858 | 5377858 | 20241024051450_LIfqw | UK0088 | 2024-10-26T12:22:48.576Z | 2024-11-01T12:27:03.091Z |
5377405 | 5377405 | 20241024044851_3sB7h | UK0088 | 2024-10-26T12:22:36.503Z | 2024-11-01T12:27:02.420Z |
5376774 | 5376774 | 20241024041447_g1dqs | UK0088 | 2024-10-26T12:22:13.015Z | 2024-11-01T12:27:01.849Z |
5366273 | 5366273 | 20241024001322_dMdWv | UK0088 | 2024-10-25T12:18:20.087Z | 2024-11-01T12:26:56.831Z |
5365788 | 5365788 | 20241023234937_F5n1X | UK0088 | 2024-10-25T12:18:07.670Z | 2024-11-01T12:26:56.413Z |
5365434 | 5365434 | 20241023233222_vYaOe | UK0088 | 2024-10-25T12:17:57.898Z | 2024-11-01T12:26:56.128Z |
5365007 | 5365007 | 20241023231004_SAWXg | UK0088 | 2024-10-25T12:17:43.568Z | 2024-11-01T12:26:55.829Z |
5363777 | 5363777 | 20241023214338_AYt2h | UK0088 | 2024-10-25T12:16:44.485Z | 2024-11-01T12:26:53.619Z |
5351403 | 5351403 | 20241022232515_2gnTJ | UK0088 | 2024-10-24T12:17:30.131Z | 2024-10-31T12:30:00.300Z |
5348575 | 5348575 | 20241022183122_c2TXd | UK0088 | 2024-10-24T12:11:42.590Z | 2024-10-31T12:29:52.950Z |
5343855 | 5343855 | 20241022035054_h8CBA | UK0088 | 2024-10-23T12:18:11.021Z | 2024-10-30T12:26:50.650Z |
5327424 | 5327424 | 20241020020813_qHY3q | UK0088 | 2024-10-21T12:12:08.080Z | 2024-10-28T12:26:44.874Z |
5326609 | 5326609 | 20241019191011_jz1L0 | UK0088 | 2024-10-21T12:10:01.638Z | 2024-10-28T12:26:42.136Z |
5323576 | 5323576 | 20241019044524_qz43K | UK0088 | 2024-10-20T12:06:37.796Z | 2024-10-27T12:28:51.518Z |
5321639 | 5321639 | 20241018053309_AVwzO | UK0088 | 2024-10-19T12:07:58.188Z | 2024-10-26T12:27:57.082Z |
5321567 | 5321567 | 20241018051234_JO7TQ | UK0088 | 2024-10-19T12:07:48.983Z | 2024-10-26T12:27:56.987Z |
5321449 | 5321449 | 20241018045307_62oWP | UK0088 | 2024-10-19T12:07:29.561Z | 2024-10-26T12:27:56.843Z |
5321379 | 5321379 | 20241018044404_HeolF | UK0088 | 2024-10-19T12:07:18.696Z | 2024-10-26T12:27:56.587Z |
5321368 | 5321368 | 20241018044115_0Yr4k | UK0088 | 2024-10-19T12:07:15.610Z | 2024-10-26T12:27:56.565Z |
5321349 | 5321349 | 20241018043519_AsOp2 | UK0088 | 2024-10-19T12:07:14.248Z | 2024-10-26T12:27:56.558Z |
5321199 | 5321199 | 20241018040349_LES1C | UK0088 | 2024-10-19T12:07:00.620Z | 2024-10-26T12:27:56.336Z |
5321154 | 5321154 | 20241018035745_QCeMT | UK0088 | 2024-10-19T12:06:56.239Z | 2024-10-26T12:27:56.249Z |
5321067 | 5321067 | 20241018033901_cVYfr | UK0088 | 2024-10-19T12:06:38.209Z | 2024-10-26T12:27:56.095Z |
5321015 | 5321015 | 20241018033207_Nb5Fw | UK0088 | 2024-10-19T12:06:33.626Z | 2024-10-26T12:27:56.052Z |
5320971 | 5320971 | 20241018032737_vkuCS | UK0088 | 2024-10-19T12:06:27.437Z | 2024-10-26T12:27:56.002Z |
5320925 | 5320925 | 20241018031402_FJZw7 | UK0088 | 2024-10-19T12:06:21.366Z | 2024-10-26T12:27:55.757Z |
5320790 | 5320790 | 20241018024451_Rdutb | UK0088 | 2024-10-19T12:06:10.613Z | 2024-10-26T12:27:55.361Z |
5320766 | 5320766 | 20241018023727_FLhTw | UK0088 | 2024-10-19T12:06:00.443Z | 2024-10-26T12:27:55.202Z |
5320722 | 5320722 | 20241018023013_deW53 | UK0088 | 2024-10-19T12:05:55.773Z | 2024-10-26T12:27:55.163Z |
5320682 | 5320682 | 20241018022327_sS47V | UK0088 | 2024-10-19T12:05:48.271Z | 2024-10-26T12:27:55.116Z |
5320679 | 5320679 | 20241018022250_mc2GU | UK0088 | 2024-10-19T12:05:48.015Z | 2024-10-26T12:27:55.115Z |
5320659 | 5320659 | 20241018022100_kVswA | UK0088 | 2024-10-19T12:05:46.304Z | 2024-10-26T12:27:55.099Z |
5318809 | 5318809 | 20241017053050_2vIzs | UK0088 | 2024-10-18T12:04:33.876Z | 2024-10-25T12:24:36.952Z |
5313202 | 5313202 | 20241014040010_wUeyq | UK0088 | 2024-10-16T12:13:54.864Z | 2024-10-22T12:24:43.706Z |
5313101 | 5313101 | 20241014030022_V6UBA | UK0088 | 2024-10-16T12:13:40.812Z | 2024-10-22T12:24:40.928Z |
5312772 | 5312772 | 20241015050031_9f0TU | UK0088 | 2024-10-16T12:10:59.333Z | 2024-10-23T12:24:53.725Z |
5312585 | 5312585 | 20241015040224_Kx0O9 | UK0088 | 2024-10-16T12:10:49.679Z | 2024-10-23T12:24:52.070Z |
5312580 | 5312580 | 20241015040142_2gK5y | UK0088 | 2024-10-16T12:10:49.330Z | 2024-10-23T12:24:52.054Z |
5311524 | 5311524 | 20241015010106_GsCAV | UK0088 | 2024-10-16T12:09:00.313Z | 2024-10-23T12:24:43.732Z |
5311080 | 5311080 | 20241014225547_y7ifa | UK0088 | 2024-10-16T12:08:16.295Z | 2024-10-23T12:24:40.950Z |
5311035 | 5311035 | 20241014223738_GNaDC | UK0088 | 2024-10-16T12:08:11.097Z | 2024-10-23T12:24:40.686Z |
5310899 | 5310899 | 20241014213009_9tT6c | UK0088 | 2024-10-16T12:07:59.186Z | 2024-10-23T12:24:39.924Z |
5310892 | 5310892 | 20241014212413_kVdri | UK0088 | 2024-10-16T12:07:58.547Z | 2024-10-23T12:24:39.888Z |
5306893 | 5306893 | 20241014044723_3zBTC | UK0088 | 2024-10-15T12:08:42.225Z | 2024-10-22T12:24:45.908Z |
5306891 | 5306891 | 20241014044605_EBYot | UK0088 | 2024-10-15T12:08:41.856Z | 2024-10-22T12:24:45.896Z |
5306884 | 5306884 | 20241014044003_eeOSu | UK0088 | 2024-10-15T12:08:40.254Z | 2024-10-22T12:24:45.574Z |
5306861 | 5306861 | 20241014043233_D3jZz | UK0088 | 2024-10-15T12:08:36.639Z | 2024-10-22T12:24:45.253Z |
5306801 | 5306801 | 20241014040116_h8sfj | UK0088 | 2024-10-15T12:08:25.373Z | 2024-10-22T12:24:43.724Z |
5306790 | 5306790 | 20241014035749_coC2a | UK0088 | 2024-10-15T12:08:24.118Z | 2024-10-22T12:24:43.617Z |
5306740 | 5306740 | 20241014034730_1nmls | UK0088 | 2024-10-15T12:08:18.961Z | 2024-10-22T12:24:42.982Z |
5306710 | 5306710 | 20241014034102_m7rwO | UK0088 | 2024-10-15T12:08:15.565Z | 2024-10-22T12:24:42.265Z |
5306690 | 5306690 | 20241014033610_wiesS | UK0088 | 2024-10-15T12:08:13.322Z | 2024-10-22T12:24:42.015Z |
5306666 | 5306666 | 20241014032746_6rHBB | UK0088 | 2024-10-15T12:08:10.746Z | 2024-10-22T12:24:41.807Z |
5306567 | 5306567 | 20241014025352_7KoEy | UK0088 | 2024-10-15T12:07:57.728Z | 2024-10-22T12:24:40.747Z |
5306545 | 5306545 | 20241014024938_EfdDn | UK0088 | 2024-10-15T12:07:50.564Z | 2024-10-22T12:24:40.466Z |
5306501 | 5306501 | 20241014023909_HYV6s | UK0088 | 2024-10-15T12:07:39.250Z | 2024-10-22T12:24:40.190Z |
5306483 | 5306483 | 20241014023252_EnmHK | UK0088 | 2024-10-15T12:07:32.362Z | 2024-10-22T12:24:40.084Z |
5306409 | 5306409 | 20241014021553_2632i | UK0088 | 2024-10-15T12:07:21.160Z | 2024-10-22T12:24:39.147Z |
5306396 | 5306396 | 20241014021411_RxJLc | UK0088 | 2024-10-15T12:07:19.621Z | 2024-10-22T12:24:39.065Z |
5306383 | 5306383 | 20241014021205_4eCss | UK0088 | 2024-10-15T12:07:18.078Z | 2024-10-22T12:24:39.047Z |
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);