participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,181 rows where station_code = "US004B" 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 |
---|---|---|---|---|---|
5524857 | 5524857 | 20241111060355_ofjJO | US004B | 2024-11-12T14:18:03.690Z | 2024-11-12T14:18:08.805Z |
5524844 | 5524844 | 20241111060200_ESEKJ | US004B | 2024-11-12T14:18:03.464Z | 2024-11-12T14:18:08.801Z |
5524762 | 5524762 | 20241111053355_xn3m8 | US004B | 2024-11-12T14:18:00.158Z | 2024-11-12T14:18:08.769Z |
5524752 | 5524752 | 20241111052913_QMUK9 | US004B | 2024-11-12T14:17:59.564Z | 2024-11-12T14:18:08.764Z |
5524742 | 5524742 | 20241111052534_x30i0 | US004B | 2024-11-12T14:17:59.012Z | 2024-11-12T14:18:08.758Z |
5524557 | 5524557 | 20241111043426_tbVsz | US004B | 2024-11-12T14:17:40.449Z | 2024-11-12T14:18:08.680Z |
5524502 | 5524502 | 20241111042249_gojok | US004B | 2024-11-12T14:17:29.831Z | 2024-11-12T14:18:08.649Z |
5524453 | 5524453 | 20241111041543_UCsdH | US004B | 2024-11-12T14:17:22.408Z | 2024-11-12T14:18:08.630Z |
5524379 | 5524379 | 20241111040420_tSWpM | US004B | 2024-11-12T14:17:12.124Z | 2024-11-12T14:18:08.592Z |
5524359 | 5524359 | 20241111040035_vteRi | US004B | 2024-11-12T14:17:07.772Z | 2024-11-12T14:18:08.581Z |
5524333 | 5524333 | 20241111035701_Qming | US004B | 2024-11-12T14:17:03.190Z | 2024-11-12T14:18:08.566Z |
5524089 | 5524089 | 20241111031325_aHZPX | US004B | 2024-11-12T14:16:31.882Z | 2024-11-12T14:18:08.465Z |
5523266 | 5523266 | 20241111004954_CRYpM | US004B | 2024-11-12T14:15:11.419Z | 2024-11-12T14:18:08.116Z |
5519538 | 5519538 | 20241111115056_8yiUk | US004B | 2024-11-12T14:04:26.772Z | 2024-11-12T14:04:26.772Z |
5519463 | 5519463 | 20241111113216_NQUz5 | US004B | 2024-11-12T14:04:06.567Z | 2024-11-12T14:04:06.567Z |
5519375 | 5519375 | 20241111111216_aYugB | US004B | 2024-11-12T14:03:53.018Z | 2024-11-12T14:03:53.018Z |
5519319 | 5519319 | 20241111110018_Nxl4O | US004B | 2024-11-12T14:03:45.346Z | 2024-11-12T14:03:45.346Z |
5519295 | 5519295 | 20241111105547_AenMd | US004B | 2024-11-12T14:03:39.106Z | 2024-11-12T14:03:39.106Z |
5519191 | 5519191 | 20241111103838_e3Zow | US004B | 2024-11-12T14:03:18.657Z | 2024-11-12T14:03:18.657Z |
5519166 | 5519166 | 20241111103012_kr5Sq | US004B | 2024-11-12T14:03:14.419Z | 2024-11-12T14:03:14.419Z |
5519094 | 5519094 | 20241111101501_ixUL3 | US004B | 2024-11-12T14:03:03.267Z | 2024-11-12T14:03:03.267Z |
5519049 | 5519049 | 20241111100643_fX1Hp | US004B | 2024-11-12T14:02:56.619Z | 2024-11-12T14:02:56.619Z |
5519047 | 5519047 | 20241111100544_9ht1m | US004B | 2024-11-12T14:02:54.780Z | 2024-11-12T14:02:54.780Z |
5518908 | 5518908 | 20241111092948_7e19z | US004B | 2024-11-12T14:02:19.671Z | 2024-11-12T14:02:19.671Z |
5518751 | 5518751 | 20241111090213_crJAG | US004B | 2024-11-12T14:01:50.866Z | 2024-11-12T14:01:50.866Z |
5518739 | 5518739 | 20241111090151_WwKit | US004B | 2024-11-12T14:01:48.733Z | 2024-11-12T14:01:48.733Z |
5518716 | 5518716 | 20241111085528_udmWQ | US004B | 2024-11-12T14:01:46.180Z | 2024-11-12T14:01:46.180Z |
5518597 | 5518597 | 20241111083127_pfBgz | US004B | 2024-11-12T14:01:27.809Z | 2024-11-12T14:01:27.809Z |
5518450 | 5518450 | 20241111075508_gLljj | US004B | 2024-11-12T14:00:59.747Z | 2024-11-12T14:00:59.747Z |
5518419 | 5518419 | 20241111074115_5LahE | US004B | 2024-11-12T14:00:53.439Z | 2024-11-12T14:00:53.439Z |
5518415 | 5518415 | 20241111073500_PT3ry | US004B | 2024-11-12T14:00:52.771Z | 2024-11-12T14:00:52.771Z |
5518374 | 5518374 | 20241111071653_8XBWg | US004B | 2024-11-12T14:00:46.776Z | 2024-11-12T14:00:46.776Z |
5518244 | 5518244 | 20241111063112_jOW09 | US004B | 2024-11-12T14:00:21.191Z | 2024-11-12T14:00:21.191Z |
5518037 | 5518037 | 20241110054453_2uXnc | US004B | 2024-11-11T14:15:09.709Z | 2024-11-12T14:22:00.970Z |
5517882 | 5517882 | 20241110050654_TIS2T | US004B | 2024-11-11T14:14:59.198Z | 2024-11-12T14:21:57.558Z |
5517781 | 5517781 | 20241110044810_XvdhV | US004B | 2024-11-11T14:14:51.359Z | 2024-11-12T14:21:54.891Z |
5517775 | 5517775 | 20241110044802_z5e63 | US004B | 2024-11-11T14:14:50.988Z | 2024-11-12T14:21:54.567Z |
5517483 | 5517483 | 20241110035221_tlmqa | US004B | 2024-11-11T14:14:29.174Z | 2024-11-12T14:21:43.784Z |
5517197 | 5517197 | 20241110030124_dLGKv | US004B | 2024-11-11T14:14:03.801Z | 2024-11-12T14:21:34.650Z |
5516679 | 5516679 | 20241110013947_Zj6Hb | US004B | 2024-11-11T14:13:14.740Z | 2024-11-12T14:21:15.679Z |
5516560 | 5516560 | 20241110012007_FTdv7 | US004B | 2024-11-11T14:13:08.591Z | 2024-11-12T14:21:11.834Z |
5516478 | 5516478 | 20241110010533_uDCyu | US004B | 2024-11-11T14:13:03.653Z | 2024-11-12T14:21:07.060Z |
5513569 | 5513569 | 20241110114918_CfLaM | US004B | 2024-11-11T14:04:49.773Z | 2024-11-12T14:18:06.554Z |
5513417 | 5513417 | 20241110112756_b1pHh | US004B | 2024-11-11T14:04:36.960Z | 2024-11-12T14:18:06.486Z |
5513387 | 5513387 | 20241110112447_kPi3y | US004B | 2024-11-11T14:04:34.405Z | 2024-11-12T14:18:06.473Z |
5513346 | 5513346 | 20241110111824_eKAi9 | US004B | 2024-11-11T14:04:30.478Z | 2024-11-12T14:18:06.456Z |
5513321 | 5513321 | 20241110111503_CCHoZ | US004B | 2024-11-11T14:04:28.042Z | 2024-11-12T14:18:06.446Z |
5513318 | 5513318 | 20241110111456_Su6Fj | US004B | 2024-11-11T14:04:27.810Z | 2024-11-12T14:18:06.445Z |
5513315 | 5513315 | 20241110111442_bHWMZ | US004B | 2024-11-11T14:04:27.612Z | 2024-11-12T14:18:06.444Z |
5513310 | 5513310 | 20241110111350_6zcwZ | US004B | 2024-11-11T14:04:27.123Z | 2024-11-12T14:18:06.441Z |
5513284 | 5513284 | 20241110111057_gTNaJ | US004B | 2024-11-11T14:04:22.185Z | 2024-11-12T14:18:06.429Z |
5513224 | 5513224 | 20241110110108_VwJkw | US004B | 2024-11-11T14:04:11.350Z | 2024-11-12T14:18:06.402Z |
5513205 | 5513205 | 20241110105702_Ie2Xo | US004B | 2024-11-11T14:04:08.447Z | 2024-11-12T14:18:06.394Z |
5513164 | 5513164 | 20241110104715_s8B9w | US004B | 2024-11-11T14:04:01.330Z | 2024-11-12T14:18:06.375Z |
5513158 | 5513158 | 20241110104627_wouxy | US004B | 2024-11-11T14:04:00.320Z | 2024-11-12T14:18:06.372Z |
5513144 | 5513144 | 20241110104152_6jmW4 | US004B | 2024-11-11T14:03:58.493Z | 2024-11-12T14:18:06.364Z |
5513087 | 5513087 | 20241110103648_iM7t5 | US004B | 2024-11-11T14:03:52.240Z | 2024-11-12T14:18:06.343Z |
5513006 | 5513006 | 20241110102112_SMpMx | US004B | 2024-11-11T14:03:44.153Z | 2024-11-12T14:18:06.303Z |
5512828 | 5512828 | 20241110095621_h8Ugt | US004B | 2024-11-11T14:03:15.808Z | 2024-11-12T14:18:06.239Z |
5512682 | 5512682 | 20241110093012_LHI2k | US004B | 2024-11-11T14:02:57.608Z | 2024-11-12T14:18:06.178Z |
5512488 | 5512488 | 20241110085819_NNYsh | US004B | 2024-11-11T14:02:24.450Z | 2024-11-12T14:18:06.095Z |
5512466 | 5512466 | 20241110085506_8BK2z | US004B | 2024-11-11T14:02:22.617Z | 2024-11-12T14:18:06.088Z |
5512280 | 5512280 | 20241110082709_IC23o | US004B | 2024-11-11T14:02:00.966Z | 2024-11-12T14:18:06.012Z |
5512264 | 5512264 | 20241110082350_e2qmk | US004B | 2024-11-11T14:01:59.017Z | 2024-11-12T14:18:06.005Z |
5512211 | 5512211 | 20241110081523_zq3ER | US004B | 2024-11-11T14:01:43.475Z | 2024-11-12T14:18:05.980Z |
5512145 | 5512145 | 20241110080442_HcDZ7 | US004B | 2024-11-11T14:01:36.740Z | 2024-11-12T14:18:05.951Z |
5512143 | 5512143 | 20241110080322_KOBwy | US004B | 2024-11-11T14:01:36.436Z | 2024-11-12T14:18:05.950Z |
5512055 | 5512055 | 20241110074742_imCNF | US004B | 2024-11-11T14:01:27.344Z | 2024-11-12T14:18:05.916Z |
5511973 | 5511973 | 20241110073641_YJU9S | US004B | 2024-11-11T14:01:14.813Z | 2024-11-12T14:18:05.882Z |
5511969 | 5511969 | 20241110073443_redRg | US004B | 2024-11-11T14:01:13.609Z | 2024-11-12T14:18:05.880Z |
5511937 | 5511937 | 20241110072541_A4xrp | US004B | 2024-11-11T14:01:08.779Z | 2024-11-12T14:18:05.866Z |
5511744 | 5511744 | 20241110064840_433ii | US004B | 2024-11-11T14:00:42.884Z | 2024-11-12T14:18:05.784Z |
5511673 | 5511673 | 20241110063710_7Too2 | US004B | 2024-11-11T14:00:27.960Z | 2024-11-12T14:18:05.747Z |
5497943 | 5497943 | 20241107061600_UpbLQ | US004B | 2024-11-08T14:14:31.623Z | 2024-11-12T14:26:15.858Z |
5497879 | 5497879 | 20241107054315_aYJYc | US004B | 2024-11-08T14:14:28.798Z | 2024-11-12T14:26:15.077Z |
5497738 | 5497738 | 20241107045153_uj3cI | US004B | 2024-11-08T14:14:17.345Z | 2024-11-12T14:26:14.107Z |
5497736 | 5497736 | 20241107045133_325RI | US004B | 2024-11-08T14:14:17.255Z | 2024-11-12T14:26:14.098Z |
5497722 | 5497722 | 20241107044334_UzO91 | US004B | 2024-11-08T14:14:15.724Z | 2024-11-12T14:26:13.874Z |
5497707 | 5497707 | 20241107044056_5FEli | US004B | 2024-11-08T14:14:15.205Z | 2024-11-12T14:26:13.848Z |
5497667 | 5497667 | 20241107042150_k3FSu | US004B | 2024-11-08T14:14:09.528Z | 2024-11-12T14:26:13.703Z |
5497234 | 5497234 | 20241107030207_MFJwh | US004B | 2024-11-08T14:13:25.443Z | 2024-11-12T14:26:10.178Z |
5497221 | 5497221 | 20241107025951_pmnN4 | US004B | 2024-11-08T14:13:22.654Z | 2024-11-12T14:26:10.079Z |
5497197 | 5497197 | 20241107025439_aJ6lZ | US004B | 2024-11-08T14:13:20.257Z | 2024-11-12T14:26:09.906Z |
5496967 | 5496967 | 20241107022043_1jCgo | US004B | 2024-11-08T14:13:01.295Z | 2024-11-12T14:26:07.794Z |
5493252 | 5493252 | 20241107112802_cmdNE | US004B | 2024-11-08T14:03:21.050Z | 2024-11-12T14:24:08.906Z |
5492961 | 5492961 | 20241107102548_XvqmQ | US004B | 2024-11-08T14:02:38.579Z | 2024-11-12T14:24:04.402Z |
5492842 | 5492842 | 20241107100306_u4a3i | US004B | 2024-11-08T14:02:12.071Z | 2024-11-12T14:24:02.316Z |
5492832 | 5492832 | 20241107100136_XkT7W | US004B | 2024-11-08T14:02:10.811Z | 2024-11-12T14:24:02.198Z |
5492778 | 5492778 | 20241107095508_nyu3A | US004B | 2024-11-08T14:02:04.822Z | 2024-11-12T14:24:01.544Z |
5492730 | 5492730 | 20241107094636_zs7gv | US004B | 2024-11-08T14:01:59.146Z | 2024-11-12T14:24:01.029Z |
5492678 | 5492678 | 20241107093034_kAe4P | US004B | 2024-11-08T14:01:53.231Z | 2024-11-12T14:24:00.042Z |
5492543 | 5492543 | 20241107085803_8P4m2 | US004B | 2024-11-08T14:01:23.266Z | 2024-11-12T14:23:57.819Z |
5492340 | 5492340 | 20241107081146_V6H22 | US004B | 2024-11-08T14:00:49.663Z | 2024-11-12T14:23:54.949Z |
5492149 | 5492149 | 20241107071140_I4iy1 | US004B | 2024-11-08T14:00:19.517Z | 2024-11-12T14:23:52.966Z |
5492138 | 5492138 | 20241107070443_cTbFq | US004B | 2024-11-08T14:00:17.956Z | 2024-11-12T14:23:52.889Z |
5492101 | 5492101 | 20241107063945_9y3np | US004B | 2024-11-08T14:00:11.089Z | 2024-11-12T14:23:52.290Z |
5491909 | 5491909 | 20241106061343_DzHUu | US004B | 2024-11-07T14:17:19.229Z | 2024-11-12T14:26:56.642Z |
5491883 | 5491883 | 20241106055737_vOWJu | US004B | 2024-11-07T14:17:17.058Z | 2024-11-12T14:26:56.572Z |
5491835 | 5491835 | 20241106053031_jq5ET | US004B | 2024-11-07T14:17:08.427Z | 2024-11-12T14:26:56.477Z |
5491833 | 5491833 | 20241106053012_H5oDY | US004B | 2024-11-07T14:17:07.622Z | 2024-11-12T14:26:56.465Z |
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);