participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
477 rows where station_code = "RU000P" 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 |
---|---|---|---|---|---|
4711948 | 4711948 | 20240727183644_YY6RI | RU000P | 2024-07-29T12:12:32.685Z | 2024-08-04T12:20:03.832Z |
4492427 | 4492427 | 20240621003522_Vs6VJ | RU000P | 2024-06-22T12:05:41.041Z | 2024-06-29T12:13:34.588Z |
2457435 | 2457435 | 20230514235213_DAzaw | RU000P | 2024-01-05T23:57:43.094Z | 2024-01-05T23:57:43.094Z |
2457406 | 2457406 | 20230514233411_Fy24J | RU000P | 2024-01-05T23:57:43.089Z | 2024-01-05T23:57:43.089Z |
2457326 | 2457326 | 20230514215141_SSfv3 | RU000P | 2024-01-05T23:57:43.079Z | 2024-01-05T23:57:43.079Z |
2457105 | 2457105 | 20230514201419_KJOln | RU000P | 2024-01-05T23:57:43.054Z | 2024-01-05T23:57:43.054Z |
2450613 | 2450613 | 20230512001856_ngke2 | RU000P | 2024-01-05T23:57:38.848Z | 2024-01-05T23:57:38.848Z |
2450095 | 2450095 | 20230511201013_RR1oa | RU000P | 2024-01-05T23:57:38.791Z | 2024-01-05T23:57:38.791Z |
2448033 | 2448033 | 20230511000804_ieBtq | RU000P | 2024-01-05T23:57:37.219Z | 2024-01-05T23:57:37.219Z |
2447814 | 2447814 | 20230510200736_p6rNk | RU000P | 2024-01-05T23:57:37.187Z | 2024-01-05T23:57:37.187Z |
542677 | 542677 | 20210314235243_i3kkP | RU000P | 2024-01-05T23:31:19.411Z | 2024-01-05T23:31:19.411Z |
542673 | 542673 | 20210314232501_Cp2PC | RU000P | 2024-01-05T23:31:19.410Z | 2024-01-05T23:31:19.410Z |
542663 | 542663 | 20210314225716_DjDR9 | RU000P | 2024-01-05T23:31:19.408Z | 2024-01-05T23:31:19.408Z |
541534 | 541534 | 20210311221553_EE8i4 | RU000P | 2024-01-05T23:31:14.907Z | 2024-01-05T23:31:14.907Z |
539172 | 539172 | 20210308215630_UY6V2 | RU000P | 2024-01-05T23:31:10.570Z | 2024-01-05T23:31:10.570Z |
538701 | 538701 | 20210308023058_pJTUt | RU000P | 2024-01-05T23:31:09.407Z | 2024-01-05T23:31:09.407Z |
535717 | 535717 | 20210305201434_oYMu9 | RU000P | 2024-01-05T23:31:06.258Z | 2024-01-05T23:31:06.258Z |
534529 | 534529 | 20210304010606_iD7Zl | RU000P | 2024-01-05T23:31:02.828Z | 2024-01-05T23:31:02.828Z |
534519 | 534519 | 20210304003648_RaBGa | RU000P | 2024-01-05T23:31:02.826Z | 2024-01-05T23:31:02.826Z |
534483 | 534483 | 20210303225222_Mb428 | RU000P | 2024-01-05T23:31:02.821Z | 2024-01-05T23:31:02.821Z |
534448 | 534448 | 20210303213355_aF0Hu | RU000P | 2024-01-05T23:31:02.815Z | 2024-01-05T23:31:02.815Z |
534413 | 534413 | 20210303194540_75ZN2 | RU000P | 2024-01-05T23:31:02.809Z | 2024-01-05T23:31:02.809Z |
518862 | 518862 | 20210211024551_pizyu | RU000P | 2024-01-05T23:30:32.461Z | 2024-01-05T23:30:32.461Z |
513474 | 513474 | 20210202201717_3AxyT | RU000P | 2024-01-05T23:30:19.840Z | 2024-01-05T23:30:19.840Z |
510735 | 510735 | 20210124024137_nwNFD | RU000P | 2024-01-05T23:30:10.358Z | 2024-01-05T23:30:10.358Z |
510652 | 510652 | 20210123215836_uVSlf | RU000P | 2024-01-05T23:30:09.226Z | 2024-01-05T23:30:09.226Z |
509546 | 509546 | 20210122004828_SNZBf | RU000P | 2024-01-05T23:30:06.840Z | 2024-01-05T23:30:06.840Z |
490253 | 490253 | 20210104194153_wHoEm | RU000P | 2024-01-05T23:29:45.174Z | 2024-01-05T23:29:45.174Z |
489461 | 489461 | 20210103200048_ZogXl | RU000P | 2024-01-05T23:29:43.950Z | 2024-01-05T23:29:43.950Z |
485206 | 485206 | 20210103030952_TRmLS | RU000P | 2024-01-05T23:29:42.070Z | 2024-01-05T23:29:42.070Z |
485154 | 485154 | 20210103024247_1v9To | RU000P | 2024-01-05T23:29:42.063Z | 2024-01-05T23:29:42.063Z |
485138 | 485138 | 20210103023341_SfE0s | RU000P | 2024-01-05T23:29:42.060Z | 2024-01-05T23:29:42.060Z |
485140 | 485140 | 20210103023415_5LsGm | RU000P | 2024-01-05T23:29:42.060Z | 2024-01-05T23:29:42.060Z |
485129 | 485129 | 20210103021922_nW7Q3 | RU000P | 2024-01-05T23:29:42.058Z | 2024-01-05T23:29:42.058Z |
485123 | 485123 | 20210103020905_6UeCO | RU000P | 2024-01-05T23:29:42.057Z | 2024-01-05T23:29:42.057Z |
485050 | 485050 | 20210103012227_m9uG7 | RU000P | 2024-01-05T23:29:42.047Z | 2024-01-05T23:29:42.047Z |
485042 | 485042 | 20210103011437_APmtr | RU000P | 2024-01-05T23:29:42.046Z | 2024-01-05T23:29:42.046Z |
485014 | 485014 | 20210103004730_wHWoc | RU000P | 2024-01-05T23:29:42.041Z | 2024-01-05T23:29:42.041Z |
485006 | 485006 | 20210103002619_U3aSG | RU000P | 2024-01-05T23:29:42.040Z | 2024-01-05T23:29:42.040Z |
485008 | 485008 | 20210103002636_WClh2 | RU000P | 2024-01-05T23:29:42.040Z | 2024-01-05T23:29:42.040Z |
485010 | 485010 | 20210103003101_NYxqm | RU000P | 2024-01-05T23:29:42.040Z | 2024-01-05T23:29:42.040Z |
484999 | 484999 | 20210103001427_ct68m | RU000P | 2024-01-05T23:29:42.039Z | 2024-01-05T23:29:42.039Z |
484981 | 484981 | 20210102232248_l8l4T | RU000P | 2024-01-05T23:29:42.036Z | 2024-01-05T23:29:42.036Z |
484971 | 484971 | 20210102224907_Gy4IW | RU000P | 2024-01-05T23:29:42.034Z | 2024-01-05T23:29:42.034Z |
484973 | 484973 | 20210102225238_oG6KI | RU000P | 2024-01-05T23:29:42.034Z | 2024-01-05T23:29:42.034Z |
484960 | 484960 | 20210102220740_iWZT2 | RU000P | 2024-01-05T23:29:42.032Z | 2024-01-05T23:29:42.032Z |
484953 | 484953 | 20210102213016_Awj01 | RU000P | 2024-01-05T23:29:42.031Z | 2024-01-05T23:29:42.031Z |
484922 | 484922 | 20210102152817_DHpS3 | RU000P | 2024-01-05T23:29:42.026Z | 2024-01-05T23:29:42.026Z |
484427 | 484427 | 20210102002456_J6B2U | RU000P | 2024-01-05T23:29:40.816Z | 2024-01-05T23:29:40.816Z |
484429 | 484429 | 20210102002641_8cs0d | RU000P | 2024-01-05T23:29:40.816Z | 2024-01-05T23:29:40.816Z |
484423 | 484423 | 20210101223852_3usdd | RU000P | 2024-01-05T23:29:40.815Z | 2024-01-05T23:29:40.815Z |
484214 | 484214 | 20210101013907_LbTzK | RU000P | 2024-01-05T23:29:39.685Z | 2024-01-05T23:29:39.685Z |
484191 | 484191 | 20210101005931_WfUFu | RU000P | 2024-01-05T23:29:39.681Z | 2024-01-05T23:29:39.681Z |
484179 | 484179 | 20210101002146_Fl16j | RU000P | 2024-01-05T23:29:39.678Z | 2024-01-05T23:29:39.678Z |
484163 | 484163 | 20201231234556_2FV8T | RU000P | 2024-01-05T23:29:39.676Z | 2024-01-05T23:29:39.676Z |
483708 | 483708 | 20201231022637_KO8p2 | RU000P | 2024-01-05T23:29:38.511Z | 2024-01-05T23:29:38.511Z |
483207 | 483207 | 20201229002755_JeM30 | RU000P | 2024-01-05T23:29:36.243Z | 2024-01-05T23:29:36.243Z |
483147 | 483147 | 20201228025430_j3N5Q | RU000P | 2024-01-05T23:29:35.121Z | 2024-01-05T23:29:35.121Z |
466079 | 466079 | 20201215194320_QDsLk | RU000P | 2024-01-05T23:29:19.011Z | 2024-01-05T23:29:19.011Z |
466049 | 466049 | 20201215175631_TPaSz | RU000P | 2024-01-05T23:29:17.868Z | 2024-01-05T23:29:17.868Z |
465217 | 465217 | 20201215031241_priV8 | RU000P | 2024-01-05T23:29:17.736Z | 2024-01-05T23:29:17.736Z |
465209 | 465209 | 20201215030930_Muc8N | RU000P | 2024-01-05T23:29:17.735Z | 2024-01-05T23:29:17.735Z |
464980 | 464980 | 20201215020849_tG9pg | RU000P | 2024-01-05T23:29:17.703Z | 2024-01-05T23:29:17.703Z |
464855 | 464855 | 20201215013754_4AzTo | RU000P | 2024-01-05T23:29:17.687Z | 2024-01-05T23:29:17.687Z |
464843 | 464843 | 20201215013349_8k23y | RU000P | 2024-01-05T23:29:17.685Z | 2024-01-05T23:29:17.685Z |
464826 | 464826 | 20201215012542_7KWlK | RU000P | 2024-01-05T23:29:17.682Z | 2024-01-05T23:29:17.682Z |
464763 | 464763 | 20201215011036_d78VM | RU000P | 2024-01-05T23:29:17.673Z | 2024-01-05T23:29:17.673Z |
464664 | 464664 | 20201215004451_8HJUD | RU000P | 2024-01-05T23:29:17.659Z | 2024-01-05T23:29:17.659Z |
464593 | 464593 | 20201215002910_2gh8e | RU000P | 2024-01-05T23:29:17.649Z | 2024-01-05T23:29:17.649Z |
464546 | 464546 | 20201215001543_p3LNX | RU000P | 2024-01-05T23:29:17.643Z | 2024-01-05T23:29:17.643Z |
464505 | 464505 | 20201214235754_2sxrc | RU000P | 2024-01-05T23:29:17.637Z | 2024-01-05T23:29:17.637Z |
464478 | 464478 | 20201214234636_ll726 | RU000P | 2024-01-05T23:29:17.633Z | 2024-01-05T23:29:17.633Z |
464438 | 464438 | 20201214233624_tLC3T | RU000P | 2024-01-05T23:29:17.628Z | 2024-01-05T23:29:17.628Z |
464394 | 464394 | 20201214231550_5sEyK | RU000P | 2024-01-05T23:29:17.621Z | 2024-01-05T23:29:17.621Z |
464344 | 464344 | 20201214230207_JEcFf | RU000P | 2024-01-05T23:29:17.615Z | 2024-01-05T23:29:17.615Z |
464332 | 464332 | 20201214225738_KgYGo | RU000P | 2024-01-05T23:29:17.613Z | 2024-01-05T23:29:17.613Z |
464305 | 464305 | 20201214224638_A13qr | RU000P | 2024-01-05T23:29:17.609Z | 2024-01-05T23:29:17.609Z |
464157 | 464157 | 20201214215238_h1D3w | RU000P | 2024-01-05T23:29:17.590Z | 2024-01-05T23:29:17.590Z |
464050 | 464050 | 20201214210520_hUVgj | RU000P | 2024-01-05T23:29:17.576Z | 2024-01-05T23:29:17.576Z |
463982 | 463982 | 20201214202958_sRzqj | RU000P | 2024-01-05T23:29:17.567Z | 2024-01-05T23:29:17.567Z |
463936 | 463936 | 20201214201322_yREbO | RU000P | 2024-01-05T23:29:17.561Z | 2024-01-05T23:29:17.561Z |
463916 | 463916 | 20201214200047_wJ8tz | RU000P | 2024-01-05T23:29:17.558Z | 2024-01-05T23:29:17.558Z |
463715 | 463715 | 20201214170829_KC0Px | RU000P | 2024-01-05T23:29:16.187Z | 2024-01-05T23:29:16.187Z |
457444 | 457444 | 20201214010705_3Hv3j | RU000P | 2024-01-05T23:29:14.970Z | 2024-01-05T23:29:14.970Z |
457140 | 457140 | 20201214003928_yta38 | RU000P | 2024-01-05T23:29:14.925Z | 2024-01-05T23:29:14.925Z |
456998 | 456998 | 20201214002641_QacTg | RU000P | 2024-01-05T23:29:14.905Z | 2024-01-05T23:29:14.905Z |
456786 | 456786 | 20201214001316_LIc4l | RU000P | 2024-01-05T23:29:14.875Z | 2024-01-05T23:29:14.875Z |
456735 | 456735 | 20201214000750_Uqv6V | RU000P | 2024-01-05T23:29:14.868Z | 2024-01-05T23:29:14.868Z |
456666 | 456666 | 20201214000124_oxgky | RU000P | 2024-01-05T23:29:14.858Z | 2024-01-05T23:29:14.858Z |
456603 | 456603 | 20201213235650_uQKrb | RU000P | 2024-01-05T23:29:14.849Z | 2024-01-05T23:29:14.849Z |
456571 | 456571 | 20201213235511_ezoMJ | RU000P | 2024-01-05T23:29:14.844Z | 2024-01-05T23:29:14.844Z |
456461 | 456461 | 20201213234905_SkgVS | RU000P | 2024-01-05T23:29:14.829Z | 2024-01-05T23:29:14.829Z |
456260 | 456260 | 20201213233440_CctqD | RU000P | 2024-01-05T23:29:14.800Z | 2024-01-05T23:29:14.800Z |
456249 | 456249 | 20201213233355_JLshZ | RU000P | 2024-01-05T23:29:14.799Z | 2024-01-05T23:29:14.799Z |
443125 | 443125 | 20201210181455_F1gM6 | RU000P | 2024-01-05T23:29:07.193Z | 2024-01-05T23:29:07.193Z |
442134 | 442134 | 20201210013134_yoewT | RU000P | 2024-01-05T23:29:07.087Z | 2024-01-05T23:29:07.087Z |
442104 | 442104 | 20201209235448_9L4vf | RU000P | 2024-01-05T23:29:07.083Z | 2024-01-05T23:29:07.083Z |
442106 | 442106 | 20201210000005_ShIjX | RU000P | 2024-01-05T23:29:07.083Z | 2024-01-05T23:29:07.083Z |
442096 | 442096 | 20201209232923_UUM3b | RU000P | 2024-01-05T23:29:07.081Z | 2024-01-05T23:29:07.081Z |
442061 | 442061 | 20201209215328_2PEQW | RU000P | 2024-01-05T23:29:07.075Z | 2024-01-05T23:29:07.075Z |
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);