participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,918 rows where station_code = "UK001X" 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 |
---|---|---|---|---|---|
3922053 | 3922053 | 20240205053129_c8PWc | UK001X | 2024-02-06T14:06:29.801Z | 2024-02-13T14:27:11.941Z |
3920411 | 3920411 | 20240204184423_A4KhV | UK001X | 2024-02-06T14:01:28.142Z | 2024-02-13T14:26:30.665Z |
3906715 | 3906715 | 20240201060749_YG49z | UK001X | 2024-02-02T14:06:25.619Z | 2024-02-09T14:20:28.182Z |
3906619 | 3906619 | 20240201054821_URCnK | UK001X | 2024-02-02T14:06:10.805Z | 2024-02-09T14:20:26.670Z |
3906491 | 3906491 | 20240201051029_SEI8U | UK001X | 2024-02-02T14:05:52.830Z | 2024-02-09T14:20:24.093Z |
3905909 | 3905909 | 20240201025506_KZtoI | UK001X | 2024-02-02T14:04:30.233Z | 2024-02-09T14:20:10.320Z |
3905583 | 3905583 | 20240201005350_iujPU | UK001X | 2024-02-02T14:03:38.165Z | 2024-02-09T14:20:03.543Z |
3905527 | 3905527 | 20240201003638_2tN9p | UK001X | 2024-02-02T14:03:21.571Z | 2024-02-09T14:20:02.641Z |
3905289 | 3905289 | 20240131231255_l1YHM | UK001X | 2024-02-02T14:02:34.661Z | 2024-02-09T14:19:56.246Z |
3901788 | 3901788 | 20240131025419_tIkXV | UK001X | 2024-02-01T14:04:27.888Z | 2024-02-08T14:20:18.513Z |
3901529 | 3901529 | 20240131011720_3ByAE | UK001X | 2024-02-01T14:03:37.806Z | 2024-02-08T14:20:14.689Z |
3901510 | 3901510 | 20240131010903_1Vy3s | UK001X | 2024-02-01T14:03:34.758Z | 2024-02-08T14:20:14.259Z |
3901496 | 3901496 | 20240131010345_CQHW5 | UK001X | 2024-02-01T14:03:32.784Z | 2024-02-08T14:20:14.141Z |
3901315 | 3901315 | 20240130235608_vm32X | UK001X | 2024-02-01T14:03:00.168Z | 2024-02-08T14:20:10.648Z |
3901103 | 3901103 | 20240130222805_q39ZP | UK001X | 2024-02-01T14:02:33.298Z | 2024-02-08T14:20:08.689Z |
3900534 | 3900534 | 20240130190312_iWl91 | UK001X | 2024-02-01T14:00:47.269Z | 2024-02-08T14:20:01.508Z |
3900395 | 3900395 | 20240130181356_2886x | UK001X | 2024-02-01T14:00:20.255Z | 2024-02-08T14:19:57.703Z |
3857039 | 3857039 | 20240118061045_Hdqmn | UK001X | 2024-01-21T14:10:22.988Z | 2024-01-26T14:21:32.235Z |
3856671 | 3856671 | 20240118055345_olqOF | UK001X | 2024-01-21T14:09:46.149Z | 2024-01-26T14:21:27.119Z |
3856261 | 3856261 | 20240118052855_59BBJ | UK001X | 2024-01-21T14:08:40.079Z | 2024-01-26T14:21:22.035Z |
3855913 | 3855913 | 20240118051141_9aZaW | UK001X | 2024-01-21T14:07:37.614Z | 2024-01-26T14:21:19.524Z |
3855603 | 3855603 | 20240118045908_eqRho | UK001X | 2024-01-21T14:06:47.915Z | 2024-01-26T14:21:16.866Z |
3855479 | 3855479 | 20240118045613_mZCQY | UK001X | 2024-01-21T14:06:29.236Z | 2024-01-26T14:21:16.288Z |
3854345 | 3854345 | 20240117223347_BRBMW | UK001X | 2024-01-20T14:14:50.193Z | 2024-01-21T14:21:47.358Z |
3854255 | 3854255 | 20240117222051_sa7Mo | UK001X | 2024-01-20T14:14:48.145Z | 2024-01-21T14:21:45.380Z |
3854201 | 3854201 | 20240117220819_xln63 | UK001X | 2024-01-20T14:14:43.549Z | 2024-01-21T14:21:43.317Z |
3853806 | 3853806 | 20240117202523_qteMF | UK001X | 2024-01-20T14:14:20.189Z | 2024-01-21T14:21:36.411Z |
3849126 | 3849126 | 20240118035314_N39jd | UK001X | 2024-01-20T14:05:41.835Z | 2024-01-26T14:21:07.856Z |
3848881 | 3848881 | 20240118034145_1HdOp | UK001X | 2024-01-20T14:05:31.061Z | 2024-01-26T14:21:06.365Z |
3848740 | 3848740 | 20240118033114_cr3XA | UK001X | 2024-01-20T14:05:14.536Z | 2024-01-26T14:21:04.607Z |
3848409 | 3848409 | 20240118030739_2X3QI | UK001X | 2024-01-20T14:04:42.993Z | 2024-01-26T14:21:01.557Z |
3848205 | 3848205 | 20240118030009_3QFw3 | UK001X | 2024-01-20T14:04:35.558Z | 2024-01-26T14:21:00.482Z |
3848193 | 3848193 | 20240118030008_zjau2 | UK001X | 2024-01-20T14:04:35.377Z | 2024-01-26T14:21:00.425Z |
3848048 | 3848048 | 20240118025059_H2BQo | UK001X | 2024-01-20T14:04:16.151Z | 2024-01-26T14:20:59.145Z |
3847919 | 3847919 | 20240118024446_n2xrg | UK001X | 2024-01-20T14:04:08.703Z | 2024-01-26T14:20:58.063Z |
3847800 | 3847800 | 20240118023718_vI48c | UK001X | 2024-01-20T14:03:56.126Z | 2024-01-26T14:20:56.965Z |
3847173 | 3847173 | 20240118013758_S2W2o | UK001X | 2024-01-20T14:02:45.007Z | 2024-01-26T14:20:47.132Z |
3847064 | 3847064 | 20240118013356_CLMF9 | UK001X | 2024-01-20T14:02:39.964Z | 2024-01-26T14:20:45.962Z |
3847025 | 3847025 | 20240118013008_B9h3y | UK001X | 2024-01-20T14:02:38.310Z | 2024-01-26T14:20:45.412Z |
3846697 | 3846697 | 20240118010437_QGyUP | UK001X | 2024-01-20T14:02:03.098Z | 2024-01-26T14:20:37.728Z |
3846581 | 3846581 | 20240118005857_oC4bV | UK001X | 2024-01-20T14:01:53.576Z | 2024-01-26T14:20:36.731Z |
3846191 | 3846191 | 20240118002152_EiYJ7 | UK001X | 2024-01-20T14:01:08.954Z | 2024-01-26T14:20:29.895Z |
3840156 | 3840156 | 20240116062647_UKb2r | UK001X | 2024-01-19T14:04:29.147Z | 2024-01-25T14:21:30.647Z |
3840000 | 3840000 | 20240116061216_W3uYj | UK001X | 2024-01-19T14:04:08.359Z | 2024-01-25T14:21:28.837Z |
3839882 | 3839882 | 20240116060258_sB2PZ | UK001X | 2024-01-19T14:03:58.598Z | 2024-01-25T14:21:26.526Z |
3838328 | 3838328 | 20240115232001_KQuHR | UK001X | 2024-01-18T14:15:15.975Z | 2024-01-24T14:19:18.487Z |
3838309 | 3838309 | 20240115230855_r3Jac | UK001X | 2024-01-18T14:15:14.634Z | 2024-01-24T14:19:18.420Z |
3836368 | 3836368 | 20240115191358_Qz11v | UK001X | 2024-01-18T14:13:25.008Z | 2024-01-24T14:19:08.918Z |
3835935 | 3835935 | 20240115183242_4LW28 | UK001X | 2024-01-18T14:12:54.978Z | 2024-01-24T14:19:06.014Z |
3675311 | 3675311 | 20231217053340_Zz7m3 | UK001X | 2024-01-06T00:05:36.132Z | 2024-01-06T00:05:36.132Z |
3675185 | 3675185 | 20231217050353_ZgXKN | UK001X | 2024-01-06T00:05:36.112Z | 2024-01-06T00:05:36.112Z |
3541351 | 3541351 | 20231208055105_UzfN6 | UK001X | 2024-01-06T00:05:05.798Z | 2024-01-06T00:05:05.798Z |
3541340 | 3541340 | 20231208055045_OqQu9 | UK001X | 2024-01-06T00:05:05.797Z | 2024-01-06T00:05:05.797Z |
3541051 | 3541051 | 20231208052848_696LN | UK001X | 2024-01-06T00:05:05.778Z | 2024-01-06T00:05:05.778Z |
3540929 | 3540929 | 20231208052049_6Ypvt | UK001X | 2024-01-06T00:05:05.769Z | 2024-01-06T00:05:05.769Z |
3540237 | 3540237 | 20231208042157_uxi6P | UK001X | 2024-01-06T00:05:05.715Z | 2024-01-06T00:05:05.715Z |
3539826 | 3539826 | 20231208033939_vlqCg | UK001X | 2024-01-06T00:05:05.679Z | 2024-01-06T00:05:05.679Z |
3539626 | 3539626 | 20231208032522_lZC0h | UK001X | 2024-01-06T00:05:05.661Z | 2024-01-06T00:05:05.661Z |
3539437 | 3539437 | 20231208030754_CvFkc | UK001X | 2024-01-06T00:05:05.642Z | 2024-01-06T00:05:05.642Z |
3539247 | 3539247 | 20231208024619_WBcS3 | UK001X | 2024-01-06T00:05:05.620Z | 2024-01-06T00:05:05.620Z |
3538800 | 3538800 | 20231208014659_PhELE | UK001X | 2024-01-06T00:05:05.570Z | 2024-01-06T00:05:05.570Z |
3538674 | 3538674 | 20231208013834_I6C3r | UK001X | 2024-01-06T00:05:05.557Z | 2024-01-06T00:05:05.557Z |
3538308 | 3538308 | 20231208003549_gRv8S | UK001X | 2024-01-06T00:05:05.511Z | 2024-01-06T00:05:05.511Z |
3538298 | 3538298 | 20231208003328_rplqK | UK001X | 2024-01-06T00:05:05.510Z | 2024-01-06T00:05:05.510Z |
3538199 | 3538199 | 20231208001054_pfUI2 | UK001X | 2024-01-06T00:05:05.498Z | 2024-01-06T00:05:05.498Z |
3538196 | 3538196 | 20231208001052_7hb3b | UK001X | 2024-01-06T00:05:05.497Z | 2024-01-06T00:05:05.497Z |
3538185 | 3538185 | 20231208000922_qA9uR | UK001X | 2024-01-06T00:05:05.496Z | 2024-01-06T00:05:05.496Z |
3537919 | 3537919 | 20231207225745_cHqL8 | UK001X | 2024-01-06T00:05:05.463Z | 2024-01-06T00:05:05.463Z |
3537855 | 3537855 | 20231207222914_EPoM7 | UK001X | 2024-01-06T00:05:05.455Z | 2024-01-06T00:05:05.455Z |
3537788 | 3537788 | 20231207215421_d83X2 | UK001X | 2024-01-06T00:05:05.447Z | 2024-01-06T00:05:05.447Z |
3537733 | 3537733 | 20231207212458_MYgQX | UK001X | 2024-01-06T00:05:05.439Z | 2024-01-06T00:05:05.439Z |
3524315 | 3524315 | 20231206045256_qRKcV | UK001X | 2024-01-06T00:05:01.369Z | 2024-01-06T00:05:01.369Z |
3524145 | 3524145 | 20231206044100_6R7lB | UK001X | 2024-01-06T00:05:01.357Z | 2024-01-06T00:05:01.357Z |
3524108 | 3524108 | 20231206043853_DIVDf | UK001X | 2024-01-06T00:05:01.353Z | 2024-01-06T00:05:01.353Z |
3524043 | 3524043 | 20231206043514_rcyFe | UK001X | 2024-01-06T00:05:01.348Z | 2024-01-06T00:05:01.348Z |
3523827 | 3523827 | 20231206042230_VEajj | UK001X | 2024-01-06T00:05:01.330Z | 2024-01-06T00:05:01.330Z |
3523566 | 3523566 | 20231206040503_BeLFA | UK001X | 2024-01-06T00:05:01.311Z | 2024-01-06T00:05:01.311Z |
3523525 | 3523525 | 20231206040339_sjSIJ | UK001X | 2024-01-06T00:05:01.307Z | 2024-01-06T00:05:01.307Z |
3523400 | 3523400 | 20231206035253_3lRxc | UK001X | 2024-01-06T00:05:01.296Z | 2024-01-06T00:05:01.296Z |
3523361 | 3523361 | 20231206034854_2dytk | UK001X | 2024-01-06T00:05:01.292Z | 2024-01-06T00:05:01.292Z |
3523190 | 3523190 | 20231206033756_hm5uH | UK001X | 2024-01-06T00:05:01.278Z | 2024-01-06T00:05:01.278Z |
3522884 | 3522884 | 20231206031630_axlS4 | UK001X | 2024-01-06T00:05:01.257Z | 2024-01-06T00:05:01.257Z |
3522306 | 3522306 | 20231206023654_xXrRc | UK001X | 2024-01-06T00:05:01.213Z | 2024-01-06T00:05:01.213Z |
3522215 | 3522215 | 20231206022835_qXzgn | UK001X | 2024-01-06T00:05:01.204Z | 2024-01-06T00:05:01.204Z |
3522143 | 3522143 | 20231206022419_qJduQ | UK001X | 2024-01-06T00:05:01.198Z | 2024-01-06T00:05:01.198Z |
3521897 | 3521897 | 20231206020707_l0mUh | UK001X | 2024-01-06T00:05:01.180Z | 2024-01-06T00:05:01.180Z |
3521807 | 3521807 | 20231206020133_xtp2i | UK001X | 2024-01-06T00:05:01.173Z | 2024-01-06T00:05:01.173Z |
3521645 | 3521645 | 20231206014905_fs0b5 | UK001X | 2024-01-06T00:05:01.160Z | 2024-01-06T00:05:01.160Z |
3521262 | 3521262 | 20231206012113_63I3h | UK001X | 2024-01-06T00:05:01.128Z | 2024-01-06T00:05:01.128Z |
3521142 | 3521142 | 20231206011443_BVm0k | UK001X | 2024-01-06T00:05:01.121Z | 2024-01-06T00:05:01.121Z |
3520901 | 3520901 | 20231206010409_7REk8 | UK001X | 2024-01-06T00:05:01.103Z | 2024-01-06T00:05:01.103Z |
3520352 | 3520352 | 20231206002137_VYxBj | UK001X | 2024-01-06T00:05:01.060Z | 2024-01-06T00:05:01.060Z |
3519326 | 3519326 | 20231205223655_AkFD8 | UK001X | 2024-01-06T00:05:00.980Z | 2024-01-06T00:05:00.980Z |
3519271 | 3519271 | 20231205222945_h9NWb | UK001X | 2024-01-06T00:05:00.976Z | 2024-01-06T00:05:00.976Z |
3519206 | 3519206 | 20231205222053_la6qH | UK001X | 2024-01-06T00:05:00.971Z | 2024-01-06T00:05:00.971Z |
3373535 | 3373535 | 20231111061203_bKisQ | UK001X | 2024-01-06T00:04:15.566Z | 2024-01-06T00:04:15.566Z |
3373526 | 3373526 | 20231111060750_BwnqU | UK001X | 2024-01-06T00:04:15.564Z | 2024-01-06T00:04:15.564Z |
3373487 | 3373487 | 20231111060259_5dBD4 | UK001X | 2024-01-06T00:04:15.560Z | 2024-01-06T00:04:15.560Z |
3372865 | 3372865 | 20231111053010_2Jpb6 | UK001X | 2024-01-06T00:04:15.511Z | 2024-01-06T00:04:15.511Z |
3372790 | 3372790 | 20231111052438_7mn0I | UK001X | 2024-01-06T00:04:15.505Z | 2024-01-06T00:04:15.505Z |
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);