participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,297 rows where station_code = "US0019" 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 |
---|---|---|---|---|---|
5067876 | 5067876 | 20240910102322_Q3ioi | US0019 | 2024-09-14T12:19:01.839Z | 2024-09-18T12:15:25.003Z |
5067600 | 5067600 | 20240910094948_ZURDJ | US0019 | 2024-09-14T12:18:50.524Z | 2024-09-18T12:15:24.533Z |
5067389 | 5067389 | 20240910092253_wwnOf | US0019 | 2024-09-14T12:18:41.504Z | 2024-09-18T12:15:23.969Z |
5066394 | 5066394 | 20240910072302_LhnDX | US0019 | 2024-09-14T12:17:54.723Z | 2024-09-18T12:15:21.795Z |
5065896 | 5065896 | 20240910055723_NwBtl | US0019 | 2024-09-14T12:17:27.333Z | 2024-09-18T12:15:20.647Z |
5065755 | 5065755 | 20240910052749_IU7Vo | US0019 | 2024-09-14T12:17:22.669Z | 2024-09-18T12:15:20.315Z |
5055818 | 5055818 | 20240908090644_2otNd | US0019 | 2024-09-13T12:17:23.489Z | 2024-09-16T12:21:22.138Z |
5055723 | 5055723 | 20240908084901_L9F2h | US0019 | 2024-09-13T12:17:20.933Z | 2024-09-16T12:21:21.702Z |
5055650 | 5055650 | 20240908083406_J3Wrq | US0019 | 2024-09-13T12:17:19.358Z | 2024-09-16T12:21:21.380Z |
5054830 | 5054830 | 20240908041856_iUn3c | US0019 | 2024-09-13T12:16:56.614Z | 2024-09-16T12:21:16.964Z |
5054828 | 5054828 | 20240908041710_TfDXS | US0019 | 2024-09-13T12:16:56.575Z | 2024-09-16T12:21:16.961Z |
5049249 | 5049249 | 20240909102709_cyeIk | US0019 | 2024-09-13T12:11:49.545Z | 2024-09-17T12:19:09.607Z |
5049057 | 5049057 | 20240909095710_ukoln | US0019 | 2024-09-13T12:11:30.447Z | 2024-09-17T12:19:09.084Z |
5048736 | 5048736 | 20240909090332_gSOLm | US0019 | 2024-09-13T12:11:12.796Z | 2024-09-17T12:19:08.177Z |
5047454 | 5047454 | 20240909041323_6NLHG | US0019 | 2024-09-13T12:09:01.799Z | 2024-09-17T12:19:02.682Z |
5047379 | 5047379 | 20240909034551_DvsGF | US0019 | 2024-09-13T12:08:54.092Z | 2024-09-17T12:19:02.240Z |
5012277 | 5012277 | 20240904090551_OSe2g | US0019 | 2024-09-09T12:10:29.457Z | 2024-09-12T12:19:35.607Z |
5012142 | 5012142 | 20240904084458_YLVY3 | US0019 | 2024-09-09T12:10:23.284Z | 2024-09-12T12:19:34.897Z |
5011879 | 5011879 | 20240904081048_fKQZD | US0019 | 2024-09-09T12:10:07.199Z | 2024-09-12T12:19:34.019Z |
5011679 | 5011679 | 20240904073845_ePP6H | US0019 | 2024-09-09T12:09:57.826Z | 2024-09-12T12:19:33.151Z |
5011578 | 5011578 | 20240904071816_qy5ta | US0019 | 2024-09-09T12:09:52.976Z | 2024-09-12T12:19:32.609Z |
5011349 | 5011349 | 20240904061112_dLanu | US0019 | 2024-09-09T12:09:35.351Z | 2024-09-12T12:19:31.350Z |
5011078 | 5011078 | 20240904044524_u2O1C | US0019 | 2024-09-09T12:09:22.970Z | 2024-09-12T12:19:30.326Z |
5002517 | 5002517 | 20240904100842_6gbDr | US0019 | 2024-09-09T12:00:43.053Z | 2024-09-13T12:19:41.205Z |
5001885 | 5001885 | 20240902070356_NtcIg | US0019 | 2024-09-08T12:17:01.643Z | 2024-09-10T12:19:35.045Z |
5001844 | 5001844 | 20240902065505_SDjdV | US0019 | 2024-09-08T12:17:00.071Z | 2024-09-10T12:19:34.865Z |
5001340 | 5001340 | 20240902043628_scRmO | US0019 | 2024-09-08T12:16:20.365Z | 2024-09-10T12:19:32.853Z |
5001183 | 5001183 | 20240902034531_LXMH0 | US0019 | 2024-09-08T12:16:13.698Z | 2024-09-10T12:19:32.322Z |
5001143 | 5001143 | 20240902033900_YAln5 | US0019 | 2024-09-08T12:16:11.839Z | 2024-09-10T12:19:32.058Z |
5000620 | 5000620 | 20240902023118_XETet | US0019 | 2024-09-08T12:15:32.022Z | 2024-09-10T12:19:28.909Z |
4997928 | 4997928 | 20240903014623_ilCwr | US0019 | 2024-09-08T12:06:58.382Z | 2024-09-11T12:21:10.006Z |
4992765 | 4992765 | 20240902085300_j7eGb | US0019 | 2024-09-08T12:00:50.089Z | 2024-09-11T12:20:17.044Z |
4958220 | 4958220 | 20240811100526_VEK2z | US0019 | 2024-09-03T12:22:16.486Z | 2024-09-06T12:31:56.370Z |
4958159 | 4958159 | 20240811095959_ZRkfE | US0019 | 2024-09-03T12:22:11.767Z | 2024-09-06T12:31:54.287Z |
4957543 | 4957543 | 20240811085529_Lf0yV | US0019 | 2024-09-03T12:21:26.583Z | 2024-09-06T12:31:25.221Z |
4957475 | 4957475 | 20240811084758_xPScQ | US0019 | 2024-09-03T12:21:19.637Z | 2024-09-06T12:31:20.459Z |
4957443 | 4957443 | 20240811084435_t7lFi | US0019 | 2024-09-03T12:21:16.510Z | 2024-09-06T12:31:19.335Z |
4957358 | 4957358 | 20240811083216_lO2h3 | US0019 | 2024-09-03T12:21:08.051Z | 2024-09-06T12:31:15.964Z |
4957263 | 4957263 | 20240811082615_O1fqr | US0019 | 2024-09-03T12:21:01.188Z | 2024-09-06T12:31:11.275Z |
4956967 | 4956967 | 20240811080352_Zq3U2 | US0019 | 2024-09-03T12:20:45.140Z | 2024-09-06T12:30:56.439Z |
4956876 | 4956876 | 20240811075725_qUSa5 | US0019 | 2024-09-03T12:20:41.730Z | 2024-09-06T12:30:52.367Z |
4956822 | 4956822 | 20240811075206_az50o | US0019 | 2024-09-03T12:20:40.209Z | 2024-09-06T12:30:49.136Z |
4956779 | 4956779 | 20240811074724_TKlX5 | US0019 | 2024-09-03T12:20:38.634Z | 2024-09-06T12:30:47.117Z |
4956622 | 4956622 | 20240811073559_oGre1 | US0019 | 2024-09-03T12:20:33.617Z | 2024-09-06T12:30:41.972Z |
4956005 | 4956005 | 20240811063539_3sFaW | US0019 | 2024-09-03T12:19:43.557Z | 2024-09-06T12:30:07.022Z |
4955509 | 4955509 | 20240811051906_hAOxW | US0019 | 2024-09-03T12:19:16.836Z | 2024-09-06T12:29:45.519Z |
4952401 | 4952401 | 20240811022106_25VD8 | US0019 | 2024-09-03T12:16:57.196Z | 2024-09-06T12:28:00.056Z |
4931214 | 4931214 | 20240810100002_J2D5B | US0019 | 2024-08-31T12:24:24.257Z | 2024-09-02T12:30:44.507Z |
4931158 | 4931158 | 20240810095050_N2IqD | US0019 | 2024-08-31T12:24:18.272Z | 2024-09-02T12:30:41.270Z |
4931150 | 4931150 | 20240810094948_oOqyE | US0019 | 2024-08-31T12:24:18.015Z | 2024-09-02T12:30:41.084Z |
4931030 | 4931030 | 20240810093408_TVgWv | US0019 | 2024-08-31T12:24:10.856Z | 2024-09-02T12:30:36.439Z |
4930897 | 4930897 | 20240810091306_bfK2y | US0019 | 2024-08-31T12:24:01.869Z | 2024-09-02T12:30:30.798Z |
4930861 | 4930861 | 20240810090744_fv1sM | US0019 | 2024-08-31T12:24:00.101Z | 2024-09-02T12:30:29.453Z |
4930701 | 4930701 | 20240810085013_CoZFl | US0019 | 2024-08-31T12:23:49.484Z | 2024-09-02T12:30:23.531Z |
4930460 | 4930460 | 20240810081624_3NMxo | US0019 | 2024-08-31T12:23:32.039Z | 2024-09-02T12:30:13.729Z |
4930278 | 4930278 | 20240810075058_sYzGD | US0019 | 2024-08-31T12:23:16.026Z | 2024-09-02T12:30:06.447Z |
4930167 | 4930167 | 20240810074106_xmWov | US0019 | 2024-08-31T12:23:08.118Z | 2024-09-02T12:30:01.689Z |
4929984 | 4929984 | 20240810071021_zj61q | US0019 | 2024-08-31T12:23:00.235Z | 2024-09-02T12:29:53.686Z |
4929876 | 4929876 | 20240810064817_dBsSW | US0019 | 2024-08-31T12:22:52.860Z | 2024-09-02T12:29:49.828Z |
4929871 | 4929871 | 20240810064708_e5G7B | US0019 | 2024-08-31T12:22:52.689Z | 2024-09-02T12:29:49.627Z |
4929807 | 4929807 | 20240810062325_V4822 | US0019 | 2024-08-31T12:22:41.607Z | 2024-09-02T12:29:47.370Z |
4929792 | 4929792 | 20240810062123_wOuN3 | US0019 | 2024-08-31T12:22:40.747Z | 2024-09-02T12:29:46.539Z |
4929774 | 4929774 | 20240810061757_0m03p | US0019 | 2024-08-31T12:22:39.957Z | 2024-09-02T12:29:45.752Z |
4929739 | 4929739 | 20240810055653_0jS6D | US0019 | 2024-08-31T12:22:35.925Z | 2024-09-02T12:29:44.096Z |
4929669 | 4929669 | 20240810053502_APxNZ | US0019 | 2024-08-31T12:22:32.665Z | 2024-09-02T12:29:41.507Z |
4929612 | 4929612 | 20240810050330_VKliu | US0019 | 2024-08-31T12:22:29.710Z | 2024-09-02T12:29:39.427Z |
4929583 | 4929583 | 20240810045715_gypyb | US0019 | 2024-08-31T12:22:27.578Z | 2024-09-02T12:29:38.683Z |
4929432 | 4929432 | 20240810041002_7j5rP | US0019 | 2024-08-31T12:22:16.372Z | 2024-09-02T12:29:34.431Z |
4929424 | 4929424 | 20240810040839_PUZ0F | US0019 | 2024-08-31T12:22:15.626Z | 2024-09-02T12:29:34.124Z |
4905325 | 4905325 | 20240808091748_yaS8T | US0019 | 2024-08-28T12:21:20.868Z | 2024-08-28T12:21:20.868Z |
4904986 | 4904986 | 20240808080323_ZClz0 | US0019 | 2024-08-28T12:20:52.235Z | 2024-08-28T12:20:52.235Z |
4904968 | 4904968 | 20240808080004_9P0HG | US0019 | 2024-08-28T12:20:51.619Z | 2024-08-28T12:20:51.619Z |
4904735 | 4904735 | 20240808070605_6xMIU | US0019 | 2024-08-28T12:20:42.493Z | 2024-08-28T12:20:42.493Z |
4904394 | 4904394 | 20240808053821_KKxPb | US0019 | 2024-08-28T12:20:21.471Z | 2024-08-28T12:20:21.471Z |
4904157 | 4904157 | 20240808041834_UR3Rt | US0019 | 2024-08-28T12:20:08.015Z | 2024-08-28T12:20:08.015Z |
4903232 | 4903232 | 20240808024555_Uj9Zt | US0019 | 2024-08-28T12:19:32.762Z | 2024-08-28T12:19:32.762Z |
4893427 | 4893427 | 20240809093447_bIX3D | US0019 | 2024-08-28T12:11:26.626Z | 2024-08-30T12:22:57.040Z |
4893405 | 4893405 | 20240809093042_kwj2q | US0019 | 2024-08-28T12:11:25.663Z | 2024-08-30T12:22:56.453Z |
4893393 | 4893393 | 20240809092925_G3DOw | US0019 | 2024-08-28T12:11:25.138Z | 2024-08-30T12:22:56.122Z |
4893333 | 4893333 | 20240809092034_RlfhC | US0019 | 2024-08-28T12:11:17.528Z | 2024-08-30T12:22:54.217Z |
4893237 | 4893237 | 20240809090407_0HyUk | US0019 | 2024-08-28T12:11:09.172Z | 2024-08-30T12:22:50.721Z |
4893148 | 4893148 | 20240809084324_JUaot | US0019 | 2024-08-28T12:11:03.502Z | 2024-08-30T12:22:48.150Z |
4893032 | 4893032 | 20240809081145_3Xnnl | US0019 | 2024-08-28T12:10:57.498Z | 2024-08-30T12:22:43.486Z |
4892676 | 4892676 | 20240809060031_204A3 | US0019 | 2024-08-28T12:10:29.440Z | 2024-08-30T12:22:25.679Z |
4892666 | 4892666 | 20240809054217_A8AaH | US0019 | 2024-08-28T12:10:28.890Z | 2024-08-30T12:22:25.234Z |
4892607 | 4892607 | 20240809040505_SFOgg | US0019 | 2024-08-28T12:10:24.559Z | 2024-08-30T12:22:19.712Z |
4885195 | 4885195 | 20240807082544_paHsw | US0019 | 2024-08-20T12:16:21.685Z | 2024-08-27T12:16:59.980Z |
4885181 | 4885181 | 20240807081706_m9Dmc | US0019 | 2024-08-20T12:16:20.979Z | 2024-08-27T12:16:59.415Z |
4884907 | 4884907 | 20240807070649_3tBr4 | US0019 | 2024-08-20T12:16:06.640Z | 2024-08-27T12:16:38.484Z |
4884826 | 4884826 | 20240807063204_o2W26 | US0019 | 2024-08-20T12:16:03.265Z | 2024-08-27T12:16:35.136Z |
4882686 | 4882686 | 20240807021857_ul5wx | US0019 | 2024-08-20T12:14:35.953Z | 2024-08-27T12:15:37.563Z |
4879117 | 4879117 | 20240807085147_QLCNw | US0019 | 2024-08-20T12:00:11.702Z | 2024-08-28T12:11:47.127Z |
4879115 | 4879115 | 20240807085052_ZR08w | US0019 | 2024-08-20T12:00:11.471Z | 2024-08-28T12:11:46.971Z |
4867994 | 4867994 | 20240806051306_vcRXZ | US0019 | 2024-08-18T12:23:56.052Z | 2024-08-19T12:28:32.057Z |
4847635 | 4847635 | 20240805045951_w2t5F | US0019 | 2024-08-16T12:21:03.725Z | 2024-08-17T12:33:09.718Z |
4847471 | 4847471 | 20240805035903_FX3b7 | US0019 | 2024-08-16T12:20:56.395Z | 2024-08-17T12:33:03.499Z |
4837789 | 4837789 | 20240805074834_SE3Xo | US0019 | 2024-08-16T12:01:22.964Z | 2024-08-19T12:15:24.659Z |
4826608 | 4826608 | 20240804050055_Wbt2u | US0019 | 2024-08-14T12:21:15.979Z | 2024-08-15T12:26:22.560Z |
4818234 | 4818234 | 20240804085043_mUS20 | US0019 | 2024-08-14T12:02:18.399Z | 2024-08-17T12:24:26.850Z |
4818210 | 4818210 | 20240804084845_6ezbj | US0019 | 2024-08-14T12:02:15.608Z | 2024-08-17T12:24:25.240Z |
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);