participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,150 rows where station_code = "UK007N" 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 |
---|---|---|---|---|---|
4680920 | 4680920 | 20240724011939_IfLPa | UK007N | 2024-07-25T12:02:58.635Z | 2024-08-01T12:12:02.929Z |
4680904 | 4680904 | 20240724011343_pZ3tF | UK007N | 2024-07-25T12:02:57.487Z | 2024-08-01T12:12:02.879Z |
4680895 | 4680895 | 20240724011209_ixDAO | UK007N | 2024-07-25T12:02:56.831Z | 2024-08-01T12:12:02.871Z |
4680773 | 4680773 | 20240724002509_Z8fMZ | UK007N | 2024-07-25T12:02:47.998Z | 2024-08-01T12:12:02.427Z |
4675767 | 4675767 | 20240722004933_TiX1K | UK007N | 2024-07-23T12:01:40.812Z | 2024-07-30T12:18:08.182Z |
4675685 | 4675685 | 20240722001351_ssjNv | UK007N | 2024-07-23T12:01:34.096Z | 2024-07-30T12:18:07.601Z |
4675681 | 4675681 | 20240722001248_ygm7V | UK007N | 2024-07-23T12:01:33.949Z | 2024-07-30T12:18:07.599Z |
4675477 | 4675477 | 20240721225240_ZnBn2 | UK007N | 2024-07-23T12:01:17.055Z | 2024-07-30T12:18:06.154Z |
4675443 | 4675443 | 20240721224000_JTJhd | UK007N | 2024-07-23T12:01:14.619Z | 2024-07-30T12:18:05.984Z |
4675424 | 4675424 | 20240721223357_9eYEx | UK007N | 2024-07-23T12:01:13.408Z | 2024-07-30T12:18:05.927Z |
4675413 | 4675413 | 20240721222825_Ir3Mh | UK007N | 2024-07-23T12:01:12.798Z | 2024-07-30T12:18:05.910Z |
4675396 | 4675396 | 20240721222526_QPmig | UK007N | 2024-07-23T12:01:12.186Z | 2024-07-30T12:18:05.874Z |
4675330 | 4675330 | 20240721220018_9iBi3 | UK007N | 2024-07-23T12:01:07.619Z | 2024-07-30T12:18:05.377Z |
4672835 | 4672835 | 20240720022922_2vTt2 | UK007N | 2024-07-21T12:04:22.474Z | 2024-07-28T12:14:57.250Z |
4672826 | 4672826 | 20240720022549_gusH3 | UK007N | 2024-07-21T12:04:21.823Z | 2024-07-28T12:14:57.228Z |
4672774 | 4672774 | 20240720020851_yLIyV | UK007N | 2024-07-21T12:04:16.434Z | 2024-07-28T12:14:57.036Z |
4672646 | 4672646 | 20240720015147_8wXjb | UK007N | 2024-07-21T12:04:09.513Z | 2024-07-28T12:14:56.649Z |
4672418 | 4672418 | 20240720012658_3enhT | UK007N | 2024-07-21T12:03:59.517Z | 2024-07-28T12:14:55.977Z |
4672398 | 4672398 | 20240720012547_CU2Yi | UK007N | 2024-07-21T12:03:59.177Z | 2024-07-28T12:14:55.949Z |
4672221 | 4672221 | 20240720010620_oM9nB | UK007N | 2024-07-21T12:03:50.842Z | 2024-07-28T12:14:55.444Z |
4672067 | 4672067 | 20240720004928_0o13m | UK007N | 2024-07-21T12:03:33.122Z | 2024-07-28T12:14:54.771Z |
4671948 | 4671948 | 20240720004025_MEvPF | UK007N | 2024-07-21T12:03:24.945Z | 2024-07-28T12:14:54.548Z |
4671917 | 4671917 | 20240720003939_u4gte | UK007N | 2024-07-21T12:03:22.690Z | 2024-07-28T12:14:54.494Z |
4671750 | 4671750 | 20240720001953_IqLYt | UK007N | 2024-07-21T12:03:10.051Z | 2024-07-28T12:14:54.043Z |
4671690 | 4671690 | 20240720000822_eWii9 | UK007N | 2024-07-21T12:03:06.357Z | 2024-07-28T12:14:53.947Z |
4671674 | 4671674 | 20240720000701_vS1QY | UK007N | 2024-07-21T12:03:05.598Z | 2024-07-28T12:14:53.832Z |
4671656 | 4671656 | 20240720000456_k4OZG | UK007N | 2024-07-21T12:03:04.424Z | 2024-07-28T12:14:53.771Z |
4671554 | 4671554 | 20240719235156_QUd9l | UK007N | 2024-07-21T12:03:00.079Z | 2024-07-28T12:14:53.312Z |
4671386 | 4671386 | 20240719233601_ee0HM | UK007N | 2024-07-21T12:02:53.652Z | 2024-07-28T12:14:52.844Z |
4671360 | 4671360 | 20240719233333_cVVW8 | UK007N | 2024-07-21T12:02:52.884Z | 2024-07-28T12:14:52.834Z |
4671330 | 4671330 | 20240719233047_vxL38 | UK007N | 2024-07-21T12:02:52.007Z | 2024-07-28T12:14:52.814Z |
4671303 | 4671303 | 20240719232855_ut6pT | UK007N | 2024-07-21T12:02:51.096Z | 2024-07-28T12:14:52.765Z |
4671280 | 4671280 | 20240719232620_z0p9l | UK007N | 2024-07-21T12:02:50.232Z | 2024-07-28T12:14:52.751Z |
4671110 | 4671110 | 20240719224907_QQeC0 | UK007N | 2024-07-21T12:02:29.206Z | 2024-07-28T12:14:52.314Z |
4671035 | 4671035 | 20240719223152_QxQd5 | UK007N | 2024-07-21T12:02:18.049Z | 2024-07-28T12:14:51.891Z |
4670954 | 4670954 | 20240719221821_IpddK | UK007N | 2024-07-21T12:02:10.344Z | 2024-07-28T12:14:51.522Z |
4668704 | 4668704 | 20240719022750_YcMEP | UK007N | 2024-07-20T12:04:53.043Z | 2024-07-27T12:17:18.718Z |
4668687 | 4668687 | 20240719021917_cdoAs | UK007N | 2024-07-20T12:04:50.455Z | 2024-07-27T12:17:18.598Z |
4668654 | 4668654 | 20240719021409_iMtTT | UK007N | 2024-07-20T12:04:48.361Z | 2024-07-27T12:17:18.473Z |
4668419 | 4668419 | 20240719014709_7Y7k9 | UK007N | 2024-07-20T12:04:34.306Z | 2024-07-27T12:17:17.380Z |
4668363 | 4668363 | 20240719014340_14AC8 | UK007N | 2024-07-20T12:04:29.434Z | 2024-07-27T12:17:17.117Z |
4668353 | 4668353 | 20240719014311_HPtQ1 | UK007N | 2024-07-20T12:04:29.033Z | 2024-07-27T12:17:17.063Z |
4668172 | 4668172 | 20240719013320_nqO1g | UK007N | 2024-07-20T12:04:21.487Z | 2024-07-27T12:17:15.076Z |
4668156 | 4668156 | 20240719013314_FrhE4 | UK007N | 2024-07-20T12:04:21.201Z | 2024-07-27T12:17:15.037Z |
4668115 | 4668115 | 20240719013032_fGKE7 | UK007N | 2024-07-20T12:04:18.143Z | 2024-07-27T12:17:14.571Z |
4668095 | 4668095 | 20240719012902_x76c7 | UK007N | 2024-07-20T12:04:17.268Z | 2024-07-27T12:17:14.437Z |
4668030 | 4668030 | 20240719012521_u3PTS | UK007N | 2024-07-20T12:04:13.172Z | 2024-07-27T12:17:14.198Z |
4667931 | 4667931 | 20240719011654_iqzuL | UK007N | 2024-07-20T12:04:08.320Z | 2024-07-27T12:17:13.852Z |
4667880 | 4667880 | 20240719011220_usCa1 | UK007N | 2024-07-20T12:04:06.610Z | 2024-07-27T12:17:13.592Z |
4667688 | 4667688 | 20240719010043_Qz43M | UK007N | 2024-07-20T12:03:59.358Z | 2024-07-27T12:17:12.781Z |
4667667 | 4667667 | 20240719005912_C71tn | UK007N | 2024-07-20T12:03:56.703Z | 2024-07-27T12:17:12.624Z |
4667509 | 4667509 | 20240719005138_2uFKu | UK007N | 2024-07-20T12:03:47.893Z | 2024-07-27T12:17:11.139Z |
4667474 | 4667474 | 20240719005043_Te77C | UK007N | 2024-07-20T12:03:46.915Z | 2024-07-27T12:17:11.052Z |
4667446 | 4667446 | 20240719004822_LBoz2 | UK007N | 2024-07-20T12:03:46.023Z | 2024-07-27T12:17:10.913Z |
4667358 | 4667358 | 20240719004110_7GcNO | UK007N | 2024-07-20T12:03:43.226Z | 2024-07-27T12:17:10.423Z |
4667196 | 4667196 | 20240719003613_KaEKR | UK007N | 2024-07-20T12:03:30.267Z | 2024-07-27T12:17:09.722Z |
4666994 | 4666994 | 20240719002432_29phw | UK007N | 2024-07-20T12:03:17.699Z | 2024-07-27T12:17:08.692Z |
4666831 | 4666831 | 20240719001100_ihtqj | UK007N | 2024-07-20T12:03:04.744Z | 2024-07-27T12:17:07.779Z |
4666760 | 4666760 | 20240719000540_tgBxM | UK007N | 2024-07-20T12:02:55.924Z | 2024-07-27T12:17:06.946Z |
4666710 | 4666710 | 20240719000247_kyZxE | UK007N | 2024-07-20T12:02:47.631Z | 2024-07-27T12:17:05.378Z |
4666672 | 4666672 | 20240718235924_NUeB2 | UK007N | 2024-07-20T12:02:45.975Z | 2024-07-27T12:17:04.920Z |
4666539 | 4666539 | 20240718234417_lvgcC | UK007N | 2024-07-20T12:02:33.681Z | 2024-07-27T12:17:03.176Z |
4666455 | 4666455 | 20240718233746_GA6J5 | UK007N | 2024-07-20T12:02:23.427Z | 2024-07-27T12:17:02.725Z |
4666199 | 4666199 | 20240718231536_Kxc3Y | UK007N | 2024-07-20T12:02:07.076Z | 2024-07-27T12:17:00.146Z |
4666148 | 4666148 | 20240718230602_jyXuO | UK007N | 2024-07-20T12:02:02.652Z | 2024-07-27T12:16:59.652Z |
4666141 | 4666141 | 20240718230525_I2F2D | UK007N | 2024-07-20T12:02:02.356Z | 2024-07-27T12:16:59.637Z |
4666119 | 4666119 | 20240718230226_qYHCK | UK007N | 2024-07-20T12:02:00.093Z | 2024-07-27T12:16:59.307Z |
4666068 | 4666068 | 20240718225020_i3ecB | UK007N | 2024-07-20T12:01:56.904Z | 2024-07-27T12:16:58.963Z |
4666049 | 4666049 | 20240718224535_18Gqh | UK007N | 2024-07-20T12:01:55.656Z | 2024-07-27T12:16:58.802Z |
4666040 | 4666040 | 20240718224354_rEL1T | UK007N | 2024-07-20T12:01:55.440Z | 2024-07-27T12:16:58.791Z |
4665935 | 4665935 | 20240718222350_aUybT | UK007N | 2024-07-20T12:01:45.394Z | 2024-07-27T12:16:57.559Z |
4665920 | 4665920 | 20240718222015_s4jEj | UK007N | 2024-07-20T12:01:42.482Z | 2024-07-27T12:16:57.096Z |
4665899 | 4665899 | 20240718221452_3wzPE | UK007N | 2024-07-20T12:01:40.007Z | 2024-07-27T12:16:56.844Z |
4665886 | 4665886 | 20240718220910_amtwx | UK007N | 2024-07-20T12:01:38.874Z | 2024-07-27T12:16:56.762Z |
4665784 | 4665784 | 20240718215525_2aKpE | UK007N | 2024-07-20T12:01:28.200Z | 2024-07-27T12:16:54.620Z |
4664837 | 4664837 | 20240717021636_Vh34j | UK007N | 2024-07-19T12:09:11.728Z | 2024-07-25T12:14:09.117Z |
4664769 | 4664769 | 20240717021040_vQFl3 | UK007N | 2024-07-19T12:09:09.551Z | 2024-07-25T12:14:08.787Z |
4664452 | 4664452 | 20240717014524_at3dG | UK007N | 2024-07-19T12:08:59.381Z | 2024-07-25T12:14:07.449Z |
4664329 | 4664329 | 20240717012854_383l2 | UK007N | 2024-07-19T12:08:52.110Z | 2024-07-25T12:14:06.412Z |
4664118 | 4664118 | 20240717011324_d4VjX | UK007N | 2024-07-19T12:08:44.431Z | 2024-07-25T12:14:05.413Z |
4664032 | 4664032 | 20240717010741_R08y5 | UK007N | 2024-07-19T12:08:41.709Z | 2024-07-25T12:14:04.782Z |
4663869 | 4663869 | 20240717005413_H5aH4 | UK007N | 2024-07-19T12:08:34.419Z | 2024-07-25T12:14:03.293Z |
4662217 | 4662217 | 20240718003055_ITADV | UK007N | 2024-07-19T12:04:16.036Z | 2024-07-26T12:17:38.544Z |
4661930 | 4661930 | 20240717235444_3Ydrg | UK007N | 2024-07-19T12:03:59.396Z | 2024-07-26T12:17:34.990Z |
4661839 | 4661839 | 20240717234452_3d4gZ | UK007N | 2024-07-19T12:03:47.888Z | 2024-07-26T12:17:33.825Z |
4661823 | 4661823 | 20240717234436_AjJ2X | UK007N | 2024-07-19T12:03:47.440Z | 2024-07-26T12:17:33.776Z |
4661797 | 4661797 | 20240717234117_lsYzE | UK007N | 2024-07-19T12:03:43.751Z | 2024-07-26T12:17:33.498Z |
4661744 | 4661744 | 20240717233441_ME3sx | UK007N | 2024-07-19T12:03:37.032Z | 2024-07-26T12:17:33.257Z |
4661639 | 4661639 | 20240717232003_0Fu8f | UK007N | 2024-07-19T12:03:24.790Z | 2024-07-26T12:17:32.671Z |
4661460 | 4661460 | 20240717224700_CwMSm | UK007N | 2024-07-19T12:03:12.785Z | 2024-07-26T12:17:30.677Z |
4661319 | 4661319 | 20240717221545_tfhlO | UK007N | 2024-07-19T12:03:02.504Z | 2024-07-26T12:17:28.828Z |
4655460 | 4655460 | 20240717004132_zbPAF | UK007N | 2024-07-18T12:05:56.156Z | 2024-07-25T12:14:02.254Z |
4655360 | 4655360 | 20240717002845_RfRfT | UK007N | 2024-07-18T12:05:51.070Z | 2024-07-25T12:14:01.753Z |
4655311 | 4655311 | 20240717002407_fD5G5 | UK007N | 2024-07-18T12:05:48.447Z | 2024-07-25T12:14:01.480Z |
4655247 | 4655247 | 20240717001942_PUz1T | UK007N | 2024-07-18T12:05:45.477Z | 2024-07-25T12:14:00.939Z |
4654376 | 4654376 | 20240716223803_5RmnG | UK007N | 2024-07-18T12:04:26.320Z | 2024-07-25T12:13:52.206Z |
4654289 | 4654289 | 20240716222109_pd3iz | UK007N | 2024-07-18T12:04:19.619Z | 2024-07-25T12:13:51.051Z |
4650942 | 4650942 | 20240715022606_P0wc3 | UK007N | 2024-07-17T12:09:36.304Z | 2024-07-23T12:08:48.324Z |
4650930 | 4650930 | 20240715022220_loYvK | UK007N | 2024-07-17T12:09:35.714Z | 2024-07-23T12:08:48.308Z |
4650918 | 4650918 | 20240715022022_zj2XJ | UK007N | 2024-07-17T12:09:35.348Z | 2024-07-23T12:08:48.276Z |
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);