participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
752 rows where station_code = "CZ000Q" 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 |
---|---|---|---|---|---|
5502115 | 5502115 | 20241107172228_sz7KH | CZ000Q | 2024-11-09T14:10:57.605Z | 2024-11-09T14:16:27.951Z |
5502035 | 5502035 | 20241107165826_QVA2S | CZ000Q | 2024-11-09T14:10:51.221Z | 2024-11-09T14:16:27.925Z |
5502029 | 5502029 | 20241107165609_TZuzc | CZ000Q | 2024-11-09T14:10:50.848Z | 2024-11-09T14:16:27.924Z |
5490681 | 5490681 | 20241106000629_qoLQy | CZ000Q | 2024-11-07T14:14:30.084Z | 2024-11-09T14:19:58.467Z |
5490672 | 5490672 | 20241106000217_yuiF5 | CZ000Q | 2024-11-07T14:14:27.782Z | 2024-11-09T14:19:57.851Z |
5490632 | 5490632 | 20241105234758_U8aSY | CZ000Q | 2024-11-07T14:14:20.309Z | 2024-11-09T14:19:57.462Z |
5490452 | 5490452 | 20241105225350_AuVmb | CZ000Q | 2024-11-07T14:14:03.011Z | 2024-11-09T14:19:55.755Z |
5490391 | 5490391 | 20241105223341_mmQGZ | CZ000Q | 2024-11-07T14:13:58.077Z | 2024-11-09T14:19:54.725Z |
5490358 | 5490358 | 20241105222156_3vYIR | CZ000Q | 2024-11-07T14:13:55.258Z | 2024-11-09T14:19:54.157Z |
5490252 | 5490252 | 20241105214736_uu3qQ | CZ000Q | 2024-11-07T14:13:44.897Z | 2024-11-09T14:19:53.202Z |
5490094 | 5490094 | 20241105205704_RYv3z | CZ000Q | 2024-11-07T14:13:10.661Z | 2024-11-09T14:19:50.769Z |
5488989 | 5488989 | 20241105173102_0oW3n | CZ000Q | 2024-11-07T14:11:08.298Z | 2024-11-09T14:19:34.907Z |
5484400 | 5484400 | 20241105024506_gEfBX | CZ000Q | 2024-11-06T14:16:52.690Z | 2024-11-09T14:21:13.724Z |
5484109 | 5484109 | 20241105021015_8g7KX | CZ000Q | 2024-11-06T14:16:17.526Z | 2024-11-09T14:21:10.907Z |
5483935 | 5483935 | 20241105014634_Rttq2 | CZ000Q | 2024-11-06T14:15:56.092Z | 2024-11-09T14:21:09.531Z |
5483839 | 5483839 | 20241105013650_GWezF | CZ000Q | 2024-11-06T14:15:45.554Z | 2024-11-09T14:21:08.711Z |
5483445 | 5483445 | 20241105004248_KUU03 | CZ000Q | 2024-11-06T14:15:20.396Z | 2024-11-09T14:21:05.475Z |
5482770 | 5482770 | 20241104231150_Nzubl | CZ000Q | 2024-11-06T14:13:54.295Z | 2024-11-09T14:21:01.402Z |
5482479 | 5482479 | 20241104222625_rm4U1 | CZ000Q | 2024-11-06T14:13:15.135Z | 2024-11-09T14:20:59.723Z |
5482351 | 5482351 | 20241104215533_geh5l | CZ000Q | 2024-11-06T14:13:04.490Z | 2024-11-09T14:20:58.487Z |
5482221 | 5482221 | 20241104212808_nDsMf | CZ000Q | 2024-11-06T14:12:37.286Z | 2024-11-09T14:20:56.881Z |
5478474 | 5478474 | 20241104041610_kK3hh | CZ000Q | 2024-11-05T14:18:24.292Z | 2024-11-09T14:22:28.444Z |
5478398 | 5478398 | 20241104040159_aIRU3 | CZ000Q | 2024-11-05T14:18:18.422Z | 2024-11-09T14:22:27.810Z |
5478177 | 5478177 | 20241104033221_476LK | CZ000Q | 2024-11-05T14:18:02.163Z | 2024-11-09T14:22:25.585Z |
5477784 | 5477784 | 20241104023525_GjtyD | CZ000Q | 2024-11-05T14:17:24.949Z | 2024-11-09T14:22:21.926Z |
5477614 | 5477614 | 20241104021322_oDgg4 | CZ000Q | 2024-11-05T14:17:09.363Z | 2024-11-09T14:22:20.080Z |
5477535 | 5477535 | 20241104020606_w4mO0 | CZ000Q | 2024-11-05T14:17:01.834Z | 2024-11-09T14:22:18.745Z |
5477335 | 5477335 | 20241104013922_cgED9 | CZ000Q | 2024-11-05T14:16:44.574Z | 2024-11-09T14:22:16.731Z |
5477313 | 5477313 | 20241104013545_z21sB | CZ000Q | 2024-11-05T14:16:42.733Z | 2024-11-09T14:22:16.478Z |
5477310 | 5477310 | 20241104013521_LB2Mb | CZ000Q | 2024-11-05T14:16:42.244Z | 2024-11-09T14:22:16.459Z |
5477171 | 5477171 | 20241104011133_22M17 | CZ000Q | 2024-11-05T14:16:28.792Z | 2024-11-09T14:22:15.093Z |
5476932 | 5476932 | 20241104004324_vyn2S | CZ000Q | 2024-11-05T14:16:12.856Z | 2024-11-09T14:22:13.425Z |
5476907 | 5476907 | 20241104004018_AarGc | CZ000Q | 2024-11-05T14:16:11.558Z | 2024-11-09T14:22:13.246Z |
5476847 | 5476847 | 20241104003318_y20rJ | CZ000Q | 2024-11-05T14:16:07.519Z | 2024-11-09T14:22:12.718Z |
5476661 | 5476661 | 20241104000406_vlil2 | CZ000Q | 2024-11-05T14:15:49.576Z | 2024-11-09T14:22:11.432Z |
5476316 | 5476316 | 20241103230700_cmMn7 | CZ000Q | 2024-11-05T14:15:03.254Z | 2024-11-09T14:22:07.758Z |
5476266 | 5476266 | 20241103225647_C4eWB | CZ000Q | 2024-11-05T14:14:59.524Z | 2024-11-09T14:22:07.506Z |
5476042 | 5476042 | 20241103221114_borrz | CZ000Q | 2024-11-05T14:14:41.238Z | 2024-11-09T14:22:05.008Z |
5475977 | 5475977 | 20241103220300_1D3m2 | CZ000Q | 2024-11-05T14:14:36.889Z | 2024-11-09T14:22:04.369Z |
5475823 | 5475823 | 20241103213043_7Hg6Q | CZ000Q | 2024-11-05T14:14:18.728Z | 2024-11-09T14:22:02.641Z |
5475769 | 5475769 | 20241103212009_cKBxI | CZ000Q | 2024-11-05T14:14:10.567Z | 2024-11-09T14:22:02.080Z |
5475715 | 5475715 | 20241103210913_qqRbC | CZ000Q | 2024-11-05T14:14:03.126Z | 2024-11-09T14:22:01.528Z |
5475696 | 5475696 | 20241103210411_Ruzi0 | CZ000Q | 2024-11-05T14:14:01.653Z | 2024-11-09T14:22:01.209Z |
5475518 | 5475518 | 20241103202210_TH6W6 | CZ000Q | 2024-11-05T14:13:45.523Z | 2024-11-09T14:21:59.521Z |
5475258 | 5475258 | 20241103193801_R7GY2 | CZ000Q | 2024-11-05T14:12:55.124Z | 2024-11-09T14:21:56.881Z |
5475066 | 5475066 | 20241103190052_Ibl0A | CZ000Q | 2024-11-05T14:12:28.839Z | 2024-11-09T14:21:55.529Z |
5475025 | 5475025 | 20241103185212_uclmg | CZ000Q | 2024-11-05T14:12:25.505Z | 2024-11-09T14:21:55.271Z |
5474995 | 5474995 | 20241103184716_NXiIX | CZ000Q | 2024-11-05T14:12:22.764Z | 2024-11-09T14:21:55.091Z |
5474989 | 5474989 | 20241103184705_Vcr7q | CZ000Q | 2024-11-05T14:12:22.231Z | 2024-11-09T14:21:55.024Z |
5474973 | 5474973 | 20241103184449_pi483 | CZ000Q | 2024-11-05T14:12:20.818Z | 2024-11-09T14:21:54.886Z |
5474862 | 5474862 | 20241103182646_dn226 | CZ000Q | 2024-11-05T14:12:11.877Z | 2024-11-09T14:21:53.721Z |
5474790 | 5474790 | 20241103181810_B6Myn | CZ000Q | 2024-11-05T14:12:00.979Z | 2024-11-09T14:21:52.403Z |
5474517 | 5474517 | 20241103173342_D7epj | CZ000Q | 2024-11-05T14:11:11.854Z | 2024-11-09T14:21:47.603Z |
5474514 | 5474514 | 20241103173336_qipTy | CZ000Q | 2024-11-05T14:11:11.611Z | 2024-11-09T14:21:47.513Z |
5468708 | 5468708 | 20241103013016_0ktOS | CZ000Q | 2024-11-04T14:14:57.246Z | 2024-11-09T14:22:59.374Z |
5468702 | 5468702 | 20241103012948_375Ze | CZ000Q | 2024-11-04T14:14:56.574Z | 2024-11-09T14:22:59.359Z |
5468515 | 5468515 | 20241103005059_uXqf4 | CZ000Q | 2024-11-04T14:14:17.704Z | 2024-11-09T14:22:58.639Z |
5468406 | 5468406 | 20241103002900_YLqOY | CZ000Q | 2024-11-04T14:14:04.140Z | 2024-11-09T14:22:58.248Z |
5468350 | 5468350 | 20241103001618_N8s3O | CZ000Q | 2024-11-04T14:13:59.978Z | 2024-11-09T14:22:58.089Z |
5468330 | 5468330 | 20241103001214_qjKYD | CZ000Q | 2024-11-04T14:13:57.854Z | 2024-11-09T14:22:58.016Z |
5468223 | 5468223 | 20241102235309_2NOhG | CZ000Q | 2024-11-04T14:13:46.863Z | 2024-11-09T14:22:57.505Z |
5468199 | 5468199 | 20241102234828_73odw | CZ000Q | 2024-11-04T14:13:43.707Z | 2024-11-09T14:22:57.466Z |
5468105 | 5468105 | 20241102232946_RU2JN | CZ000Q | 2024-11-04T14:13:17.231Z | 2024-11-09T14:22:57.120Z |
5467993 | 5467993 | 20241102231212_3RS9X | CZ000Q | 2024-11-04T14:13:05.316Z | 2024-11-09T14:22:56.261Z |
5467937 | 5467937 | 20241102225829_a2YZE | CZ000Q | 2024-11-04T14:12:59.098Z | 2024-11-09T14:22:56.082Z |
5467861 | 5467861 | 20241102224741_OwIgl | CZ000Q | 2024-11-04T14:12:45.992Z | 2024-11-09T14:22:55.817Z |
5467816 | 5467816 | 20241102224228_YR94k | CZ000Q | 2024-11-04T14:12:34.556Z | 2024-11-09T14:22:55.729Z |
5467759 | 5467759 | 20241102223131_xSvne | CZ000Q | 2024-11-04T14:12:28.441Z | 2024-11-09T14:22:55.588Z |
5467721 | 5467721 | 20241102222404_bDi2Q | CZ000Q | 2024-11-04T14:12:24.057Z | 2024-11-09T14:22:55.467Z |
5467683 | 5467683 | 20241102221657_9L3MC | CZ000Q | 2024-11-04T14:12:20.857Z | 2024-11-09T14:22:55.394Z |
5467597 | 5467597 | 20241102220240_H47Lk | CZ000Q | 2024-11-04T14:12:12.915Z | 2024-11-09T14:22:55.133Z |
5467518 | 5467518 | 20241102213425_PEaJD | CZ000Q | 2024-11-04T14:11:50.181Z | 2024-11-09T14:22:54.880Z |
5467482 | 5467482 | 20241102212655_ucylp | CZ000Q | 2024-11-04T14:11:40.270Z | 2024-11-09T14:22:54.730Z |
5467458 | 5467458 | 20241102212243_FxtKV | CZ000Q | 2024-11-04T14:11:34.672Z | 2024-11-09T14:22:54.666Z |
5467450 | 5467450 | 20241102211829_84At3 | CZ000Q | 2024-11-04T14:11:33.186Z | 2024-11-09T14:22:54.640Z |
5467126 | 5467126 | 20241102201309_1z18g | CZ000Q | 2024-11-04T14:10:44.952Z | 2024-11-09T14:22:53.397Z |
5467092 | 5467092 | 20241102200515_RWqBJ | CZ000Q | 2024-11-04T14:10:36.553Z | 2024-11-09T14:22:53.278Z |
5466789 | 5466789 | 20241102185705_TJ2PH | CZ000Q | 2024-11-04T14:09:48.891Z | 2024-11-09T14:22:52.360Z |
5466777 | 5466777 | 20241102185219_3TiNT | CZ000Q | 2024-11-04T14:09:46.120Z | 2024-11-09T14:22:52.280Z |
5466697 | 5466697 | 20241102183627_J3EZ6 | CZ000Q | 2024-11-04T14:09:34.721Z | 2024-11-09T14:22:51.963Z |
5466167 | 5466167 | 20241102163926_MZ2yX | CZ000Q | 2024-11-04T14:08:08.572Z | 2024-11-09T14:22:49.760Z |
5452681 | 5452681 | 20241101040710_XvSu6 | CZ000Q | 2024-11-02T12:19:13.560Z | 2024-11-09T14:24:32.831Z |
5450920 | 5450920 | 20241031214103_QrzGu | CZ000Q | 2024-11-02T12:16:16.381Z | 2024-11-09T14:24:19.921Z |
5431169 | 5431169 | 20241029003841_XF4tu | CZ000Q | 2024-10-31T12:19:42.058Z | 2024-11-06T14:27:22.892Z |
5430663 | 5430663 | 20241028231610_e9CJz | CZ000Q | 2024-10-31T12:18:47.492Z | 2024-11-06T14:27:21.012Z |
5430656 | 5430656 | 20241028231547_lr0ed | CZ000Q | 2024-10-31T12:18:46.830Z | 2024-11-06T14:27:20.954Z |
5430629 | 5430629 | 20241028231257_XGzv6 | CZ000Q | 2024-10-31T12:18:44.370Z | 2024-11-06T14:27:20.745Z |
5430394 | 5430394 | 20241028222635_5tDZ0 | CZ000Q | 2024-10-31T12:18:18.813Z | 2024-11-06T14:27:19.782Z |
5430326 | 5430326 | 20241028220719_j9D2Z | CZ000Q | 2024-10-31T12:18:07.586Z | 2024-11-06T14:27:19.536Z |
5429931 | 5429931 | 20241028202907_nvMPw | CZ000Q | 2024-10-31T12:17:14.439Z | 2024-11-06T14:27:18.104Z |
5429472 | 5429472 | 20241028192655_iwalU | CZ000Q | 2024-10-31T12:16:37.276Z | 2024-11-06T14:27:16.151Z |
5429454 | 5429454 | 20241028192602_uLsol | CZ000Q | 2024-10-31T12:16:35.592Z | 2024-11-06T14:27:16.067Z |
5428554 | 5428554 | 20241028173207_u7YXy | CZ000Q | 2024-10-31T12:15:15.897Z | 2024-11-06T14:27:13.879Z |
5386534 | 5386534 | 20241025005808_EuBzH | CZ000Q | 2024-10-27T12:20:09.678Z | 2024-11-02T12:28:31.330Z |
5386532 | 5386532 | 20241025005730_IOD3t | CZ000Q | 2024-10-27T12:20:09.588Z | 2024-11-02T12:28:31.328Z |
5386479 | 5386479 | 20241025004719_o2k22 | CZ000Q | 2024-10-27T12:20:07.350Z | 2024-11-02T12:28:31.269Z |
5386412 | 5386412 | 20241025003728_1nFdV | CZ000Q | 2024-10-27T12:20:03.852Z | 2024-11-02T12:28:31.201Z |
5386301 | 5386301 | 20241025002357_QPZou | CZ000Q | 2024-10-27T12:19:59.090Z | 2024-11-02T12:28:30.945Z |
5386114 | 5386114 | 20241025000442_yXhhq | CZ000Q | 2024-10-27T12:19:51.102Z | 2024-11-02T12:28:30.693Z |
5385985 | 5385985 | 20241024235158_yzQAD | CZ000Q | 2024-10-27T12:19:43.644Z | 2024-11-02T12:28:30.560Z |
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);