participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,902 rows where station_code = "US0022" 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 |
---|---|---|---|---|---|
5126320 | 5126320 | 20240918105412_6xZf1 | US0022 | 2024-09-19T12:05:43.935Z | 2024-09-19T12:06:42.180Z |
5095993 | 5095993 | 20240912093843_kottO | US0022 | 2024-09-16T12:16:04.477Z | 2024-09-19T12:21:20.816Z |
5095745 | 5095745 | 20240912085306_s3pCg | US0022 | 2024-09-16T12:15:55.676Z | 2024-09-19T12:21:20.008Z |
5095741 | 5095741 | 20240912085225_rGPd6 | US0022 | 2024-09-16T12:15:55.467Z | 2024-09-19T12:21:19.985Z |
5095290 | 5095290 | 20240912070049_dPyyY | US0022 | 2024-09-16T12:15:29.988Z | 2024-09-19T12:21:17.970Z |
5081270 | 5081270 | 20240911070953_3gIvm | US0022 | 2024-09-15T12:17:28.810Z | 2024-09-19T12:21:44.974Z |
5065772 | 5065772 | 20240910053050_UjPs8 | US0022 | 2024-09-14T12:17:23.405Z | 2024-09-18T12:15:20.377Z |
5056535 | 5056535 | 20240908103921_h9rhb | US0022 | 2024-09-13T12:17:34.793Z | 2024-09-16T12:21:25.794Z |
5056489 | 5056489 | 20240908103409_4G2AS | US0022 | 2024-09-13T12:17:33.803Z | 2024-09-16T12:21:25.620Z |
5035113 | 5035113 | 20240907084435_0a11A | US0022 | 2024-09-12T12:11:52.965Z | 2024-09-15T12:21:38.282Z |
5035039 | 5035039 | 20240907083619_x1q7p | US0022 | 2024-09-12T12:11:50.075Z | 2024-09-15T12:21:37.955Z |
5034941 | 5034941 | 20240907082048_rMyjd | US0022 | 2024-09-12T12:11:45.914Z | 2024-09-15T12:21:37.711Z |
5034864 | 5034864 | 20240907081238_q7MIG | US0022 | 2024-09-12T12:11:37.239Z | 2024-09-15T12:21:37.124Z |
5034696 | 5034696 | 20240907074503_4weyt | US0022 | 2024-09-12T12:11:12.731Z | 2024-09-15T12:21:35.564Z |
5034574 | 5034574 | 20240907072156_J2OKH | US0022 | 2024-09-12T12:11:05.744Z | 2024-09-15T12:21:35.236Z |
5028561 | 5028561 | 20240905102220_I5YDd | US0022 | 2024-09-11T12:15:35.046Z | 2024-09-14T12:22:48.259Z |
5028513 | 5028513 | 20240905101823_9iDmp | US0022 | 2024-09-11T12:15:31.489Z | 2024-09-14T12:22:47.821Z |
5027325 | 5027325 | 20240905072330_CXd9u | US0022 | 2024-09-11T12:14:05.514Z | 2024-09-13T12:20:02.397Z |
5027101 | 5027101 | 20240905064144_CSqAs | US0022 | 2024-09-11T12:13:40.243Z | 2024-09-13T12:20:01.395Z |
5021778 | 5021778 | 20240905072330_IMZMj | US0022 | 2024-09-10T12:15:51.251Z | 2024-09-10T12:16:55.436Z |
5021557 | 5021557 | 20240905064144_9f9Kc | US0022 | 2024-09-10T12:15:40.584Z | 2024-09-10T12:16:55.396Z |
5013368 | 5013368 | 20240905102220_Ty3vj | US0022 | 2024-09-10T12:00:28.769Z | 2024-09-11T12:00:17.968Z |
5013320 | 5013320 | 20240905101823_u04oG | US0022 | 2024-09-10T12:00:21.936Z | 2024-09-11T12:00:15.666Z |
5011468 | 5011468 | 20240904064657_Ro6zt | US0022 | 2024-09-09T12:09:42.185Z | 2024-09-12T12:19:31.973Z |
5003934 | 5003934 | 20240903101642_KX2bZ | US0022 | 2024-09-09T12:02:13.395Z | 2024-09-12T12:19:00.188Z |
5002736 | 5002736 | 20240904103934_pU0ZO | US0022 | 2024-09-09T12:00:59.220Z | 2024-09-13T12:19:41.945Z |
5002680 | 5002680 | 20240904103143_NuP3Y | US0022 | 2024-09-09T12:00:55.856Z | 2024-09-13T12:19:41.749Z |
4992401 | 4992401 | 20240902080057_88A6q | US0022 | 2024-09-08T12:00:18.255Z | 2024-09-11T12:20:12.392Z |
4983558 | 4983558 | 20240901070816_r1dOl | US0022 | 2024-09-07T12:00:17.025Z | 2024-09-10T12:19:01.802Z |
4955444 | 4955444 | 20240811050026_uuu3P | US0022 | 2024-09-03T12:19:13.691Z | 2024-09-06T12:29:41.461Z |
4858976 | 4858976 | 20240806090810_PolhI | US0022 | 2024-08-18T12:01:24.512Z | 2024-08-27T12:01:32.833Z |
4818434 | 4818434 | 20240804092334_8NDCJ | US0022 | 2024-08-14T12:02:47.660Z | 2024-08-17T12:24:38.460Z |
4808625 | 4808625 | 20240803111151_lWxZK | US0022 | 2024-08-13T12:05:44.139Z | 2024-08-15T12:19:13.487Z |
4808458 | 4808458 | 20240803110246_DThAs | US0022 | 2024-08-13T12:05:31.293Z | 2024-08-15T12:19:07.073Z |
4807427 | 4807427 | 20240803095845_AnW3m | US0022 | 2024-08-13T12:03:15.431Z | 2024-08-15T12:18:28.744Z |
4797732 | 4797732 | 20240803071455_2TXLs | US0022 | 2024-08-12T12:01:28.551Z | 2024-08-15T12:17:19.356Z |
4797387 | 4797387 | 20240803051646_H6PWa | US0022 | 2024-08-12T12:00:24.145Z | 2024-08-15T12:17:08.262Z |
4788274 | 4788274 | 20240802085750_E6kNu | US0022 | 2024-08-11T12:04:09.821Z | 2024-08-13T12:15:47.011Z |
4765906 | 4765906 | 20240731113037_ctJ3e | US0022 | 2024-08-06T12:07:52.644Z | 2024-08-10T12:19:13.106Z |
4765399 | 4765399 | 20240731103530_Ye82J | US0022 | 2024-08-06T12:07:15.484Z | 2024-08-10T12:19:05.226Z |
4765290 | 4765290 | 20240731102139_3VV5m | US0022 | 2024-08-06T12:07:09.029Z | 2024-08-10T12:19:04.042Z |
4764738 | 4764738 | 20240731092411_p9zhl | US0022 | 2024-08-06T12:06:39.026Z | 2024-08-10T12:18:54.567Z |
4764141 | 4764141 | 20240731080018_kTiJV | US0022 | 2024-08-06T12:05:41.896Z | 2024-08-10T12:18:39.893Z |
4764024 | 4764024 | 20240731074756_Jvx6e | US0022 | 2024-08-06T12:05:36.229Z | 2024-08-10T12:18:37.238Z |
4763796 | 4763796 | 20240731070445_aUlXa | US0022 | 2024-08-06T12:05:16.277Z | 2024-08-10T12:18:28.592Z |
4763600 | 4763600 | 20240731062422_rE3VC | US0022 | 2024-08-06T12:04:48.201Z | 2024-08-10T12:18:22.720Z |
4723355 | 4723355 | 20240728084813_OxDoW | US0022 | 2024-07-31T12:09:18.615Z | 2024-08-05T12:20:13.052Z |
4629381 | 4629381 | 20240713112823_ooJW0 | US0022 | 2024-07-15T12:01:59.457Z | 2024-07-22T12:09:58.441Z |
4629038 | 4629038 | 20240713103309_udq9s | US0022 | 2024-07-15T12:01:34.080Z | 2024-07-22T12:09:57.273Z |
4628320 | 4628320 | 20240713074503_PyvpP | US0022 | 2024-07-15T12:00:29.616Z | 2024-07-22T12:09:53.848Z |
4604739 | 4604739 | 20240709060912_0qqPb | US0022 | 2024-07-12T12:03:00.454Z | 2024-07-18T12:16:29.262Z |
4580802 | 4580802 | 20240707095724_UdpoX | US0022 | 2024-07-09T12:03:46.760Z | 2024-07-15T12:12:15.685Z |
4580767 | 4580767 | 20240707095015_SUDjr | US0022 | 2024-07-09T12:03:45.011Z | 2024-07-15T12:12:15.494Z |
4536255 | 4536255 | 20240702110230_7vjI4 | US0022 | 2024-07-03T12:04:43.228Z | 2024-07-10T12:15:34.060Z |
4536140 | 4536140 | 20240702100844_VUNFV | US0022 | 2024-07-03T12:04:33.811Z | 2024-07-10T12:15:33.083Z |
4536051 | 4536051 | 20240702094628_dI4D9 | US0022 | 2024-07-03T12:04:24.976Z | 2024-07-10T12:15:32.726Z |
4535596 | 4535596 | 20240702071020_s4I4w | US0022 | 2024-07-03T12:03:31.162Z | 2024-07-10T12:15:30.666Z |
4465580 | 4465580 | 20240615103703_DJ8cM | US0022 | 2024-06-16T12:04:41.134Z | 2024-06-23T12:12:11.371Z |
4465357 | 4465357 | 20240615093131_Y56dx | US0022 | 2024-06-16T12:04:16.959Z | 2024-06-23T12:12:07.791Z |
4465099 | 4465099 | 20240615082841_WpIvw | US0022 | 2024-06-16T12:03:48.600Z | 2024-06-23T12:12:02.136Z |
4464875 | 4464875 | 20240615073858_E2K7z | US0022 | 2024-06-16T12:03:17.190Z | 2024-06-23T12:11:56.601Z |
4464705 | 4464705 | 20240615070348_uCL2q | US0022 | 2024-06-16T12:03:01.817Z | 2024-06-23T12:11:53.838Z |
4450813 | 4450813 | 20240612103946_8e2FZ | US0022 | 2024-06-13T12:03:07.612Z | 2024-06-20T12:12:02.039Z |
4450598 | 4450598 | 20240612093610_dOW3M | US0022 | 2024-06-13T12:02:55.496Z | 2024-06-20T12:11:59.676Z |
4450448 | 4450448 | 20240612085118_Nxts0 | US0022 | 2024-06-13T12:02:44.403Z | 2024-06-20T12:11:59.038Z |
4447330 | 4447330 | 20240611111516_ZUeeH | US0022 | 2024-06-12T12:04:01.922Z | 2024-06-19T12:13:43.908Z |
4447323 | 4447323 | 20240611111258_ran56 | US0022 | 2024-06-12T12:04:01.359Z | 2024-06-19T12:13:43.795Z |
4447273 | 4447273 | 20240611110305_oPH11 | US0022 | 2024-06-12T12:03:58.699Z | 2024-06-19T12:13:43.576Z |
4446828 | 4446828 | 20240611085556_O6CW7 | US0022 | 2024-06-12T12:03:26.079Z | 2024-06-19T12:13:37.866Z |
4446822 | 4446822 | 20240611084742_zD6k0 | US0022 | 2024-06-12T12:03:25.179Z | 2024-06-19T12:13:37.663Z |
4446690 | 4446690 | 20240611075218_wy7HE | US0022 | 2024-06-12T12:03:12.943Z | 2024-06-19T12:13:36.491Z |
4443053 | 4443053 | 20240610094338_v7vyG | US0022 | 2024-06-11T12:03:08.815Z | 2024-06-18T12:11:10.330Z |
4443036 | 4443036 | 20240610093657_yvdsk | US0022 | 2024-06-11T12:03:07.489Z | 2024-06-18T12:11:10.277Z |
4442705 | 4442705 | 20240610074323_nPXaE | US0022 | 2024-06-11T12:02:24.073Z | 2024-06-18T12:11:08.352Z |
4376173 | 4376173 | 20240519112548_Pjkz3 | US0022 | 2024-05-27T12:11:29.278Z | 2024-05-27T12:11:29.278Z |
4376129 | 4376129 | 20240519111455_IMxhp | US0022 | 2024-05-27T12:11:26.024Z | 2024-05-27T12:11:26.024Z |
4375957 | 4375957 | 20240519102707_RlJkc | US0022 | 2024-05-27T12:11:15.215Z | 2024-05-27T12:11:15.215Z |
4366596 | 4366596 | 20240519061650_G6fkb | US0022 | 2024-05-26T12:02:58.342Z | 2024-05-27T12:10:51.066Z |
4362065 | 4362065 | 20240516101229_2BZgG | US0022 | 2024-05-25T12:05:12.049Z | 2024-05-25T12:05:12.049Z |
4358990 | 4358990 | 20240511111129_JoOXn | US0022 | 2024-05-22T12:13:15.143Z | 2024-05-22T12:13:15.143Z |
4358940 | 4358940 | 20240511110408_JxeoU | US0022 | 2024-05-22T12:13:13.655Z | 2024-05-22T12:13:13.655Z |
4358747 | 4358747 | 20240511104319_fBNZt | US0022 | 2024-05-22T12:13:06.264Z | 2024-05-22T12:13:06.264Z |
4358602 | 4358602 | 20240511101119_3HaPa | US0022 | 2024-05-22T12:13:01.334Z | 2024-05-22T12:13:01.334Z |
4358548 | 4358548 | 20240511100118_aecqz | US0022 | 2024-05-22T12:12:59.894Z | 2024-05-22T12:12:59.894Z |
4358101 | 4358101 | 20240511081632_VO8d2 | US0022 | 2024-05-22T12:12:44.435Z | 2024-05-22T12:12:44.435Z |
4357550 | 4357550 | 20240512113754_khGgI | US0022 | 2024-05-22T12:08:49.534Z | 2024-05-22T12:08:49.534Z |
4357223 | 4357223 | 20240512102152_87J87 | US0022 | 2024-05-22T12:08:17.645Z | 2024-05-22T12:08:17.645Z |
4356942 | 4356942 | 20240512091534_nLlDT | US0022 | 2024-05-22T12:07:57.160Z | 2024-05-22T12:07:57.160Z |
4356727 | 4356727 | 20240512073934_PfxTb | US0022 | 2024-05-22T12:07:44.138Z | 2024-05-22T12:07:44.138Z |
4356439 | 4356439 | 20240512051846_bjjkf | US0022 | 2024-05-22T12:07:14.452Z | 2024-05-22T12:07:14.452Z |
4349236 | 4349236 | 20240510102737_50Bj5 | US0022 | 2024-05-20T12:13:30.853Z | 2024-05-21T12:12:25.026Z |
4349132 | 4349132 | 20240510100643_P46ob | US0022 | 2024-05-20T12:13:16.564Z | 2024-05-21T12:12:21.345Z |
4349066 | 4349066 | 20240510094640_pAqhe | US0022 | 2024-05-20T12:13:07.843Z | 2024-05-21T12:12:19.194Z |
4348978 | 4348978 | 20240510092309_2TWpS | US0022 | 2024-05-20T12:13:02.963Z | 2024-05-21T12:12:12.451Z |
4348497 | 4348497 | 20240510065621_7Hr60 | US0022 | 2024-05-20T12:12:13.316Z | 2024-05-21T12:11:49.359Z |
4336784 | 4336784 | 20240509112725_Wmkk8 | US0022 | 2024-05-18T12:15:26.110Z | 2024-05-19T12:16:23.529Z |
4335680 | 4335680 | 20240509094538_Iq23H | US0022 | 2024-05-18T12:14:08.509Z | 2024-05-19T12:16:02.345Z |
4334683 | 4334683 | 20240509061929_KN4DZ | US0022 | 2024-05-18T12:12:20.498Z | 2024-05-19T12:15:34.678Z |
4330460 | 4330460 | 20240509113745_KswHZ | US0022 | 2024-05-18T12:00:15.663Z | 2024-05-21T12:06:00.247Z |
4323532 | 4323532 | 20240508110708_Odt4T | US0022 | 2024-05-17T12:00:38.169Z | 2024-05-19T12:12:29.064Z |
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);