participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0001" 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 |
---|---|---|---|---|---|
5599736 | 5599736 | 20241124023007_qe8fX | US0001 | 2024-11-25T14:17:21.309Z | 2024-11-25T14:17:38.703Z |
5599717 | 5599717 | 20241124022547_LtWyD | US0001 | 2024-11-25T14:17:20.115Z | 2024-11-25T14:17:38.698Z |
5599627 | 5599627 | 20241124020657_ptTX0 | US0001 | 2024-11-25T14:17:15.612Z | 2024-11-25T14:17:38.676Z |
5595808 | 5595808 | 20241124124958_xm352 | US0001 | 2024-11-25T14:08:55.657Z | 2024-11-25T14:08:55.657Z |
5595629 | 5595629 | 20241124123517_yOQGV | US0001 | 2024-11-25T14:08:38.099Z | 2024-11-25T14:08:38.099Z |
5595575 | 5595575 | 20241124123230_2oLsa | US0001 | 2024-11-25T14:08:33.696Z | 2024-11-25T14:08:33.696Z |
5595555 | 5595555 | 20241124123215_LiMMR | US0001 | 2024-11-25T14:08:32.143Z | 2024-11-25T14:08:32.143Z |
5595339 | 5595339 | 20241124120816_CWSdv | US0001 | 2024-11-25T14:07:59.937Z | 2024-11-25T14:07:59.937Z |
5595322 | 5595322 | 20241124120756_e01rI | US0001 | 2024-11-25T14:07:58.649Z | 2024-11-25T14:07:58.649Z |
5595318 | 5595318 | 20241124120755_MSMfU | US0001 | 2024-11-25T14:07:58.255Z | 2024-11-25T14:07:58.255Z |
5595200 | 5595200 | 20241124115335_6uG0G | US0001 | 2024-11-25T14:07:44.910Z | 2024-11-25T14:07:44.910Z |
5594940 | 5594940 | 20241124112150_o4En7 | US0001 | 2024-11-25T14:07:00.914Z | 2024-11-25T14:07:00.914Z |
5594331 | 5594331 | 20241124101742_fo7Jn | US0001 | 2024-11-25T14:05:28.111Z | 2024-11-25T14:05:28.111Z |
5594134 | 5594134 | 20241124094526_mEfw2 | US0001 | 2024-11-25T14:04:47.554Z | 2024-11-25T14:04:47.554Z |
5593828 | 5593828 | 20241124085429_kz68e | US0001 | 2024-11-25T14:03:53.223Z | 2024-11-25T14:03:53.223Z |
5593777 | 5593777 | 20241124084918_fM2BG | US0001 | 2024-11-25T14:03:47.147Z | 2024-11-25T14:03:47.147Z |
5593675 | 5593675 | 20241124082527_DnTp3 | US0001 | 2024-11-25T14:03:21.490Z | 2024-11-25T14:03:21.490Z |
5593643 | 5593643 | 20241124081944_0fwYu | US0001 | 2024-11-25T14:03:16.340Z | 2024-11-25T14:03:16.340Z |
5593577 | 5593577 | 20241124080327_aCO6S | US0001 | 2024-11-25T14:03:06.602Z | 2024-11-25T14:03:06.602Z |
5593568 | 5593568 | 20241124080054_4q3G1 | US0001 | 2024-11-25T14:03:05.794Z | 2024-11-25T14:03:05.794Z |
5593398 | 5593398 | 20241124070051_gef9k | US0001 | 2024-11-25T14:02:29.022Z | 2024-11-25T14:02:29.022Z |
5593368 | 5593368 | 20241124065158_sZDUY | US0001 | 2024-11-25T14:02:24.640Z | 2024-11-25T14:02:24.640Z |
5593336 | 5593336 | 20241124064350_IBx53 | US0001 | 2024-11-25T14:02:20.185Z | 2024-11-25T14:02:20.185Z |
5593327 | 5593327 | 20241124063759_OIP7Q | US0001 | 2024-11-25T14:02:18.650Z | 2024-11-25T14:02:18.650Z |
5593313 | 5593313 | 20241124063157_x2tnC | US0001 | 2024-11-25T14:02:16.805Z | 2024-11-25T14:02:16.805Z |
5593299 | 5593299 | 20241124062955_zh47i | US0001 | 2024-11-25T14:02:15.198Z | 2024-11-25T14:02:15.198Z |
5593193 | 5593193 | 20241124054305_2H7Oi | US0001 | 2024-11-25T14:01:39.931Z | 2024-11-25T14:01:39.931Z |
5593166 | 5593166 | 20241124053439_KcMmq | US0001 | 2024-11-25T14:01:36.187Z | 2024-11-25T14:01:36.187Z |
5593067 | 5593067 | 20241124045441_0bTg3 | US0001 | 2024-11-25T14:01:14.796Z | 2024-11-25T14:01:14.796Z |
5593037 | 5593037 | 20241124044116_P6Ack | US0001 | 2024-11-25T14:01:07.695Z | 2024-11-25T14:01:07.695Z |
5593027 | 5593027 | 20241124043824_8KG02 | US0001 | 2024-11-25T14:01:05.872Z | 2024-11-25T14:01:05.872Z |
5593018 | 5593018 | 20241124043729_yew2e | US0001 | 2024-11-25T14:01:04.738Z | 2024-11-25T14:01:04.738Z |
5592992 | 5592992 | 20241124043315_PHiTk | US0001 | 2024-11-25T14:01:00.600Z | 2024-11-25T14:01:00.600Z |
5592836 | 5592836 | 20241124035656_nPmwl | US0001 | 2024-11-25T14:00:27.702Z | 2024-11-25T14:00:27.702Z |
5592237 | 5592237 | 20241123024304_nhDzK | US0001 | 2024-11-24T14:20:48.645Z | 2024-11-25T14:19:29.077Z |
5592179 | 5592179 | 20241123022911_pEf6P | US0001 | 2024-11-24T14:20:44.059Z | 2024-11-25T14:19:28.511Z |
5586663 | 5586663 | 20241123130015_j5RVo | US0001 | 2024-11-24T14:08:33.172Z | 2024-11-25T14:17:37.961Z |
5586619 | 5586619 | 20241123125331_VCT2p | US0001 | 2024-11-24T14:08:25.120Z | 2024-11-25T14:17:37.950Z |
5586517 | 5586517 | 20241123122327_ua7t5 | US0001 | 2024-11-24T14:08:08.336Z | 2024-11-25T14:17:37.925Z |
5586506 | 5586506 | 20241123122209_XrIKY | US0001 | 2024-11-24T14:08:07.084Z | 2024-11-25T14:17:37.922Z |
5586394 | 5586394 | 20241123115851_vTkaH | US0001 | 2024-11-24T14:07:48.947Z | 2024-11-25T14:17:37.896Z |
5586253 | 5586253 | 20241123113929_CFWic | US0001 | 2024-11-24T14:07:21.708Z | 2024-11-25T14:17:37.861Z |
5586247 | 5586247 | 20241123113925_pLWCL | US0001 | 2024-11-24T14:07:21.558Z | 2024-11-25T14:17:37.860Z |
5586217 | 5586217 | 20241123113046_64I8j | US0001 | 2024-11-24T14:07:16.970Z | 2024-11-25T14:17:37.853Z |
5586088 | 5586088 | 20241123110342_fsFe2 | US0001 | 2024-11-24T14:07:01.039Z | 2024-11-25T14:17:37.821Z |
5586042 | 5586042 | 20241123105712_T33a3 | US0001 | 2024-11-24T14:06:57.096Z | 2024-11-25T14:17:37.810Z |
5585999 | 5585999 | 20241123104645_NZD0p | US0001 | 2024-11-24T14:06:43.403Z | 2024-11-25T14:17:37.797Z |
5585979 | 5585979 | 20241123104339_LtTHk | US0001 | 2024-11-24T14:06:36.047Z | 2024-11-25T14:17:37.792Z |
5585841 | 5585841 | 20241123102602_8ogK3 | US0001 | 2024-11-24T14:06:16.944Z | 2024-11-25T14:17:37.756Z |
5585731 | 5585731 | 20241123100421_X6rSM | US0001 | 2024-11-24T14:06:01.527Z | 2024-11-25T14:17:37.728Z |
5585672 | 5585672 | 20241123095406_9RdR2 | US0001 | 2024-11-24T14:05:42.682Z | 2024-11-25T14:17:37.714Z |
5585636 | 5585636 | 20241123094500_cCAUZ | US0001 | 2024-11-24T14:05:33.789Z | 2024-11-25T14:17:37.704Z |
5585594 | 5585594 | 20241123093916_rBMZT | US0001 | 2024-11-24T14:05:26.116Z | 2024-11-25T14:17:37.693Z |
5585538 | 5585538 | 20241123092428_5quzE | US0001 | 2024-11-24T14:05:09.770Z | 2024-11-25T14:17:37.679Z |
5585527 | 5585527 | 20241123092258_vdL02 | US0001 | 2024-11-24T14:05:07.949Z | 2024-11-25T14:17:37.677Z |
5585441 | 5585441 | 20241123090310_u0YbO | US0001 | 2024-11-24T14:04:52.767Z | 2024-11-25T14:17:37.657Z |
5585415 | 5585415 | 20241123085714_CmUM7 | US0001 | 2024-11-24T14:04:48.105Z | 2024-11-25T14:17:37.651Z |
5585372 | 5585372 | 20241123084930_ZR7nh | US0001 | 2024-11-24T14:04:32.386Z | 2024-11-25T14:17:37.642Z |
5585336 | 5585336 | 20241123083659_H33Fj | US0001 | 2024-11-24T14:04:24.071Z | 2024-11-25T14:17:37.630Z |
5585298 | 5585298 | 20241123083135_JZgGu | US0001 | 2024-11-24T14:04:16.723Z | 2024-11-25T14:17:37.616Z |
5585160 | 5585160 | 20241123075228_oU5JT | US0001 | 2024-11-24T14:03:39.181Z | 2024-11-25T14:17:37.578Z |
5585102 | 5585102 | 20241123074207_iERyK | US0001 | 2024-11-24T14:03:31.698Z | 2024-11-25T14:17:37.566Z |
5585062 | 5585062 | 20241123073511_6d7sz | US0001 | 2024-11-24T14:03:26.921Z | 2024-11-25T14:17:37.559Z |
5585060 | 5585060 | 20241123073347_hHRP9 | US0001 | 2024-11-24T14:03:26.613Z | 2024-11-25T14:17:37.559Z |
5584925 | 5584925 | 20241123065642_pM3wH | US0001 | 2024-11-24T14:02:58.957Z | 2024-11-25T14:17:37.529Z |
5584890 | 5584890 | 20241123064959_XVVOt | US0001 | 2024-11-24T14:02:53.337Z | 2024-11-25T14:17:37.521Z |
5584847 | 5584847 | 20241123063705_J2boE | US0001 | 2024-11-24T14:02:42.722Z | 2024-11-25T14:17:37.511Z |
5584782 | 5584782 | 20241123062434_T2oS1 | US0001 | 2024-11-24T14:02:30.657Z | 2024-11-25T14:17:37.497Z |
5584732 | 5584732 | 20241123060552_h5N2G | US0001 | 2024-11-24T14:02:16.683Z | 2024-11-25T14:17:37.486Z |
5584507 | 5584507 | 20241123045450_Em2HI | US0001 | 2024-11-24T14:01:19.287Z | 2024-11-25T14:17:37.429Z |
5584452 | 5584452 | 20241123044105_AIwaq | US0001 | 2024-11-24T14:01:06.712Z | 2024-11-25T14:17:37.415Z |
5583730 | 5583730 | 20241118115142_AOsTO | US0001 | 2024-11-23T14:24:58.483Z | 2024-11-25T14:22:13.079Z |
5582943 | 5582943 | 20241120093546_wl2v5 | US0001 | 2024-11-23T14:22:09.757Z | 2024-11-25T14:21:02.270Z |
5582490 | 5582490 | 20241122033842_8b8dq | US0001 | 2024-11-23T14:21:06.619Z | 2024-11-25T14:20:46.589Z |
5582418 | 5582418 | 20241122033303_wQRgW | US0001 | 2024-11-23T14:21:04.962Z | 2024-11-25T14:20:46.217Z |
5581852 | 5581852 | 20241122024120_TOpEu | US0001 | 2024-11-23T14:20:47.726Z | 2024-11-25T14:20:42.979Z |
5580826 | 5580826 | 20241122011653_2cmPN | US0001 | 2024-11-23T14:19:43.257Z | 2024-11-25T14:20:36.548Z |
5577179 | 5577179 | 20241121120708_2Fh00 | US0001 | 2024-11-23T14:13:52.606Z | 2024-11-25T14:19:59.970Z |
5577094 | 5577094 | 20241121080558_iMkc5 | US0001 | 2024-11-23T14:12:28.632Z | 2024-11-25T14:19:47.528Z |
5576649 | 5576649 | 20241122124538_fTfcB | US0001 | 2024-11-23T14:09:59.999Z | 2024-11-25T14:18:48.022Z |
5576553 | 5576553 | 20241122123031_QJKDw | US0001 | 2024-11-23T14:09:49.408Z | 2024-11-25T14:18:45.930Z |
5576466 | 5576466 | 20241122121635_lp3NQ | US0001 | 2024-11-23T14:09:32.790Z | 2024-11-25T14:18:43.276Z |
5576376 | 5576376 | 20241122115444_s2Z53 | US0001 | 2024-11-23T14:09:20.535Z | 2024-11-25T14:18:40.519Z |
5576231 | 5576231 | 20241122113456_jyIUI | US0001 | 2024-11-23T14:08:51.897Z | 2024-11-25T14:18:36.150Z |
5576106 | 5576106 | 20241122111538_x35He | US0001 | 2024-11-23T14:08:34.883Z | 2024-11-25T14:18:33.204Z |
5576097 | 5576097 | 20241122111508_lSuJ7 | US0001 | 2024-11-23T14:08:34.323Z | 2024-11-25T14:18:33.016Z |
5576067 | 5576067 | 20241122111234_P4YLx | US0001 | 2024-11-23T14:08:31.251Z | 2024-11-25T14:18:32.487Z |
5575897 | 5575897 | 20241122104333_8iymU | US0001 | 2024-11-23T14:08:00.438Z | 2024-11-25T14:18:28.860Z |
5575866 | 5575866 | 20241122103526_B2hYg | US0001 | 2024-11-23T14:07:56.052Z | 2024-11-25T14:18:26.938Z |
5575736 | 5575736 | 20241122100955_gxKw9 | US0001 | 2024-11-23T14:07:28.127Z | 2024-11-25T14:18:23.481Z |
5575707 | 5575707 | 20241122100345_azddy | US0001 | 2024-11-23T14:07:22.837Z | 2024-11-25T14:18:22.845Z |
5575469 | 5575469 | 20241122092806_u1f2c | US0001 | 2024-11-23T14:06:37.965Z | 2024-11-25T14:18:17.111Z |
5575454 | 5575454 | 20241122092437_TMqmp | US0001 | 2024-11-23T14:06:36.618Z | 2024-11-25T14:18:16.831Z |
5575381 | 5575381 | 20241122091050_T4xYU | US0001 | 2024-11-23T14:06:21.408Z | 2024-11-25T14:18:15.828Z |
5575163 | 5575163 | 20241122082657_0KSRM | US0001 | 2024-11-23T14:05:39.247Z | 2024-11-25T14:18:12.934Z |
5575151 | 5575151 | 20241122082407_TS3sB | US0001 | 2024-11-23T14:05:37.268Z | 2024-11-25T14:18:12.679Z |
5575112 | 5575112 | 20241122081259_AQ2ks | US0001 | 2024-11-23T14:05:29.651Z | 2024-11-25T14:18:11.910Z |
5574763 | 5574763 | 20241122062456_mvmEe | US0001 | 2024-11-23T14:04:19.238Z | 2024-11-25T14:18:06.397Z |
5574608 | 5574608 | 20241122060404_lsyOD | US0001 | 2024-11-23T14:03:48.187Z | 2024-11-25T14:18:04.403Z |
5574573 | 5574573 | 20241122060106_q1nXe | US0001 | 2024-11-23T14:03:42.965Z | 2024-11-25T14:18:03.916Z |
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);