participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "FR0006" 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 |
---|---|---|---|---|---|
5441965 | 5441965 | 20241030001111_FiBPl | FR0006 | 2024-11-01T12:19:14.735Z | 2024-11-03T14:24:07.837Z |
5441437 | 5441437 | 20241029221536_VxxTL | FR0006 | 2024-11-01T12:18:35.869Z | 2024-11-03T14:24:01.963Z |
5441269 | 5441269 | 20241029212445_7CbxM | FR0006 | 2024-11-01T12:18:22.414Z | 2024-11-03T14:23:59.945Z |
5441224 | 5441224 | 20241029211250_oVxlr | FR0006 | 2024-11-01T12:18:19.445Z | 2024-11-03T14:23:59.680Z |
5433442 | 5433442 | 20241029195922_rIwv8 | FR0006 | 2024-10-31T12:22:15.931Z | 2024-11-03T14:23:55.009Z |
5433390 | 5433390 | 20241029193314_v5Eq3 | FR0006 | 2024-10-31T12:22:11.924Z | 2024-11-03T14:23:53.717Z |
5432838 | 5432838 | 20241029045233_ll2qP | FR0006 | 2024-10-31T12:21:36.400Z | 2024-11-03T14:25:21.538Z |
5432791 | 5432791 | 20241029044008_zjbqs | FR0006 | 2024-10-31T12:21:35.257Z | 2024-11-03T14:25:21.296Z |
5432637 | 5432637 | 20241029040632_3hm9N | FR0006 | 2024-10-31T12:21:29.517Z | 2024-11-03T14:25:20.338Z |
5432512 | 5432512 | 20241029034524_2GwGY | FR0006 | 2024-10-31T12:21:25.303Z | 2024-11-03T14:25:19.139Z |
5432415 | 5432415 | 20241029032946_c2X2j | FR0006 | 2024-10-31T12:21:21.736Z | 2024-11-03T14:25:17.750Z |
5432405 | 5432405 | 20241029032806_vs9kv | FR0006 | 2024-10-31T12:21:21.123Z | 2024-11-03T14:25:17.635Z |
5432345 | 5432345 | 20241029031726_IrAjP | FR0006 | 2024-10-31T12:21:18.540Z | 2024-11-03T14:25:16.767Z |
5432217 | 5432217 | 20241029025525_l1g9X | FR0006 | 2024-10-31T12:21:13.218Z | 2024-11-03T14:25:16.023Z |
5432118 | 5432118 | 20241029024409_nMrA2 | FR0006 | 2024-10-31T12:21:03.397Z | 2024-11-03T14:25:15.360Z |
5432087 | 5432087 | 20241029024113_h5ovA | FR0006 | 2024-10-31T12:21:02.072Z | 2024-11-03T14:25:15.067Z |
5432030 | 5432030 | 20241029023313_OPjG2 | FR0006 | 2024-10-31T12:20:56.996Z | 2024-11-03T14:25:14.808Z |
5431902 | 5431902 | 20241029021415_RJP1z | FR0006 | 2024-10-31T12:20:48.115Z | 2024-11-03T14:25:13.752Z |
5431853 | 5431853 | 20241029020558_13iDI | FR0006 | 2024-10-31T12:20:44.353Z | 2024-11-03T14:25:13.338Z |
5431739 | 5431739 | 20241029015256_uy0YN | FR0006 | 2024-10-31T12:20:35.482Z | 2024-11-03T14:25:12.386Z |
5431645 | 5431645 | 20241029014053_lHp4t | FR0006 | 2024-10-31T12:20:28.143Z | 2024-11-03T14:25:11.976Z |
5431492 | 5431492 | 20241029012023_bv3l3 | FR0006 | 2024-10-31T12:20:14.286Z | 2024-11-03T14:25:10.915Z |
5431426 | 5431426 | 20241029011005_P4hcM | FR0006 | 2024-10-31T12:20:07.858Z | 2024-11-03T14:25:10.461Z |
5431423 | 5431423 | 20241029010933_9Ye36 | FR0006 | 2024-10-31T12:20:07.368Z | 2024-11-03T14:25:10.284Z |
5431414 | 5431414 | 20241029010822_pbNJ0 | FR0006 | 2024-10-31T12:20:06.488Z | 2024-11-03T14:25:10.111Z |
5431182 | 5431182 | 20241029003956_fFEaE | FR0006 | 2024-10-31T12:19:44.053Z | 2024-11-03T14:25:08.234Z |
5431177 | 5431177 | 20241029003855_qtSKu | FR0006 | 2024-10-31T12:19:43.440Z | 2024-11-03T14:25:08.200Z |
5431026 | 5431026 | 20241029001741_dOFEU | FR0006 | 2024-10-31T12:19:29.084Z | 2024-11-03T14:25:06.729Z |
5430857 | 5430857 | 20241028235310_ttnO3 | FR0006 | 2024-10-31T12:19:11.016Z | 2024-11-03T14:25:05.078Z |
5430841 | 5430841 | 20241028235138_2iYxX | FR0006 | 2024-10-31T12:19:09.818Z | 2024-11-03T14:25:04.873Z |
5430822 | 5430822 | 20241028234519_0Ugzw | FR0006 | 2024-10-31T12:19:06.630Z | 2024-11-03T14:25:04.788Z |
5430813 | 5430813 | 20241028234322_DBpi7 | FR0006 | 2024-10-31T12:19:05.469Z | 2024-11-03T14:25:04.708Z |
5430695 | 5430695 | 20241028232403_296mq | FR0006 | 2024-10-31T12:18:53.053Z | 2024-11-03T14:25:03.262Z |
5430424 | 5430424 | 20241028223238_Ie7Ax | FR0006 | 2024-10-31T12:18:22.008Z | 2024-11-03T14:25:01.165Z |
5430409 | 5430409 | 20241028222846_XUhEq | FR0006 | 2024-10-31T12:18:20.016Z | 2024-11-03T14:25:01.114Z |
5430379 | 5430379 | 20241028222246_LguJ5 | FR0006 | 2024-10-31T12:18:15.313Z | 2024-11-03T14:25:01.000Z |
5430322 | 5430322 | 20241028220627_Nh2T9 | FR0006 | 2024-10-31T12:18:06.605Z | 2024-11-03T14:25:00.812Z |
5430302 | 5430302 | 20241028220036_WRTAA | FR0006 | 2024-10-31T12:18:03.201Z | 2024-11-03T14:25:00.769Z |
5429865 | 5429865 | 20241028201616_eFfHC | FR0006 | 2024-10-31T12:17:09.812Z | 2024-11-03T14:24:59.213Z |
5429821 | 5429821 | 20241028200925_SUGkd | FR0006 | 2024-10-31T12:17:06.382Z | 2024-11-03T14:24:58.912Z |
5428669 | 5428669 | 20241028175136_cfWed | FR0006 | 2024-10-31T12:15:22.819Z | 2024-11-03T14:24:53.292Z |
5421226 | 5421226 | 20241028051116_2PsfT | FR0006 | 2024-10-30T12:19:43.955Z | 2024-11-03T14:26:05.116Z |
5421191 | 5421191 | 20241028050325_hIdRQ | FR0006 | 2024-10-30T12:19:41.373Z | 2024-11-03T14:26:04.995Z |
5421179 | 5421179 | 20241028045722_PWhNb | FR0006 | 2024-10-30T12:19:40.454Z | 2024-11-03T14:26:04.946Z |
5421170 | 5421170 | 20241028045456_fFv1J | FR0006 | 2024-10-30T12:19:39.691Z | 2024-11-03T14:26:04.910Z |
5421148 | 5421148 | 20241028044641_ukyxa | FR0006 | 2024-10-30T12:19:37.733Z | 2024-11-03T14:26:04.836Z |
5421081 | 5421081 | 20241028042934_mB2U8 | FR0006 | 2024-10-30T12:19:35.321Z | 2024-11-03T14:26:04.403Z |
5421050 | 5421050 | 20241028042349_8dHJR | FR0006 | 2024-10-30T12:19:33.993Z | 2024-11-03T14:26:04.290Z |
5421014 | 5421014 | 20241028041531_twseA | FR0006 | 2024-10-30T12:19:32.533Z | 2024-11-03T14:26:03.967Z |
5420984 | 5420984 | 20241028040911_HBpiD | FR0006 | 2024-10-30T12:19:31.131Z | 2024-11-03T14:26:03.899Z |
5420708 | 5420708 | 20241028032503_L4GLY | FR0006 | 2024-10-30T12:19:12.312Z | 2024-11-03T14:26:02.953Z |
5420638 | 5420638 | 20241028031049_YAUlW | FR0006 | 2024-10-30T12:19:06.619Z | 2024-11-03T14:26:02.693Z |
5420471 | 5420471 | 20241028024533_6IrPD | FR0006 | 2024-10-30T12:18:53.705Z | 2024-11-03T14:26:02.226Z |
5420459 | 5420459 | 20241028024409_spm4d | FR0006 | 2024-10-30T12:18:52.907Z | 2024-11-03T14:26:02.155Z |
5420416 | 5420416 | 20241028024003_7cA0S | FR0006 | 2024-10-30T12:18:50.271Z | 2024-11-03T14:26:01.933Z |
5420259 | 5420259 | 20241028022200_AMu7D | FR0006 | 2024-10-30T12:18:38.948Z | 2024-11-03T14:26:01.405Z |
5420145 | 5420145 | 20241028020419_eVmI2 | FR0006 | 2024-10-30T12:18:25.126Z | 2024-11-03T14:26:01.152Z |
5420061 | 5420061 | 20241028015304_99XF2 | FR0006 | 2024-10-30T12:18:18.038Z | 2024-11-03T14:26:00.954Z |
5419824 | 5419824 | 20241028011519_adV5j | FR0006 | 2024-10-30T12:17:55.394Z | 2024-11-03T14:26:00.170Z |
5419663 | 5419663 | 20241028004134_6dEY7 | FR0006 | 2024-10-30T12:17:42.413Z | 2024-11-03T14:25:59.767Z |
5419530 | 5419530 | 20241028001514_X3hcd | FR0006 | 2024-10-30T12:17:32.066Z | 2024-11-03T14:25:59.167Z |
5419499 | 5419499 | 20241028001132_cYMs9 | FR0006 | 2024-10-30T12:17:30.297Z | 2024-11-03T14:25:58.979Z |
5419342 | 5419342 | 20241027233958_M8Le6 | FR0006 | 2024-10-30T12:17:21.570Z | 2024-11-03T14:25:58.183Z |
5419339 | 5419339 | 20241027233924_bpKWE | FR0006 | 2024-10-30T12:17:21.415Z | 2024-11-03T14:25:58.123Z |
5419325 | 5419325 | 20241027233806_DPdJV | FR0006 | 2024-10-30T12:17:20.606Z | 2024-11-03T14:25:58.068Z |
5419063 | 5419063 | 20241027225407_qkSCe | FR0006 | 2024-10-30T12:17:02.049Z | 2024-11-03T14:25:56.471Z |
5418850 | 5418850 | 20241027221033_l8rCo | FR0006 | 2024-10-30T12:16:23.323Z | 2024-11-03T14:25:55.130Z |
5418841 | 5418841 | 20241027220657_eBMf6 | FR0006 | 2024-10-30T12:16:21.492Z | 2024-11-03T14:25:54.983Z |
5418829 | 5418829 | 20241027220356_EtmpF | FR0006 | 2024-10-30T12:16:19.481Z | 2024-11-03T14:25:54.936Z |
5418792 | 5418792 | 20241027215758_KPdXT | FR0006 | 2024-10-30T12:16:12.558Z | 2024-11-03T14:25:54.865Z |
5418771 | 5418771 | 20241027215429_2ftBs | FR0006 | 2024-10-30T12:16:09.255Z | 2024-11-03T14:25:54.783Z |
5418711 | 5418711 | 20241027214137_JtSyA | FR0006 | 2024-10-30T12:16:00.743Z | 2024-11-03T14:25:54.520Z |
5418601 | 5418601 | 20241027211805_Wgj5Q | FR0006 | 2024-10-30T12:15:52.780Z | 2024-11-03T14:25:53.937Z |
5418535 | 5418535 | 20241027210703_Y1uET | FR0006 | 2024-10-30T12:15:48.708Z | 2024-11-03T14:25:52.591Z |
5418150 | 5418150 | 20241027200127_UeHX6 | FR0006 | 2024-10-30T12:15:00.103Z | 2024-11-03T14:25:49.865Z |
5417926 | 5417926 | 20241027193218_J4E23 | FR0006 | 2024-10-30T12:14:38.025Z | 2024-11-03T14:25:48.165Z |
5417583 | 5417583 | 20241027184833_M2LfC | FR0006 | 2024-10-30T12:13:53.297Z | 2024-11-03T14:25:45.557Z |
5417266 | 5417266 | 20241027180715_a7g0j | FR0006 | 2024-10-30T12:13:26.834Z | 2024-11-03T14:25:44.504Z |
5400463 | 5400463 | 20241024175247_5H2pd | FR0006 | 2024-10-28T12:22:14.419Z | 2024-11-02T12:28:24.778Z |
5399350 | 5399350 | 20241026041143_KjR3m | FR0006 | 2024-10-28T12:19:55.629Z | 2024-11-03T14:27:39.529Z |
5399258 | 5399258 | 20241026040559_CdqMb | FR0006 | 2024-10-28T12:19:52.641Z | 2024-11-03T14:27:39.286Z |
5399098 | 5399098 | 20241026035242_6iOpK | FR0006 | 2024-10-28T12:19:48.397Z | 2024-11-03T14:27:39.018Z |
5398978 | 5398978 | 20241026034301_CXK7b | FR0006 | 2024-10-28T12:19:43.273Z | 2024-11-03T14:27:38.802Z |
5398971 | 5398971 | 20241026034239_VMQ9D | FR0006 | 2024-10-28T12:19:42.923Z | 2024-11-03T14:27:38.779Z |
5398867 | 5398867 | 20241026033423_R3iBZ | FR0006 | 2024-10-28T12:19:38.042Z | 2024-11-03T14:27:38.311Z |
5398482 | 5398482 | 20241026030228_JTVOQ | FR0006 | 2024-10-28T12:19:19.090Z | 2024-11-03T14:27:36.594Z |
5398471 | 5398471 | 20241026025955_zGZ4T | FR0006 | 2024-10-28T12:19:18.640Z | 2024-11-03T14:27:36.395Z |
5398402 | 5398402 | 20241026025356_bbzgR | FR0006 | 2024-10-28T12:19:13.940Z | 2024-11-03T14:27:36.255Z |
5397905 | 5397905 | 20241026020636_ApiYW | FR0006 | 2024-10-28T12:18:50.121Z | 2024-11-03T14:27:34.499Z |
5397833 | 5397833 | 20241026020122_2s516 | FR0006 | 2024-10-28T12:18:46.831Z | 2024-11-03T14:27:34.289Z |
5397794 | 5397794 | 20241026015848_apEpU | FR0006 | 2024-10-28T12:18:42.991Z | 2024-11-03T14:27:34.154Z |
5397781 | 5397781 | 20241026015651_gvlK3 | FR0006 | 2024-10-28T12:18:41.081Z | 2024-11-03T14:27:34.131Z |
5397706 | 5397706 | 20241026015022_3yyC9 | FR0006 | 2024-10-28T12:18:35.891Z | 2024-11-03T14:27:33.857Z |
5397673 | 5397673 | 20241026014656_3pG92 | FR0006 | 2024-10-28T12:18:32.955Z | 2024-11-03T14:27:33.706Z |
5397354 | 5397354 | 20241026012103_fUQJn | FR0006 | 2024-10-28T12:18:17.606Z | 2024-11-03T14:27:32.725Z |
5397065 | 5397065 | 20241026010010_WxIhu | FR0006 | 2024-10-28T12:18:05.455Z | 2024-11-03T14:27:31.981Z |
5396972 | 5396972 | 20241026005209_fTPXh | FR0006 | 2024-10-28T12:18:01.305Z | 2024-11-03T14:27:31.599Z |
5396968 | 5396968 | 20241026005121_RUtFH | FR0006 | 2024-10-28T12:18:01.106Z | 2024-11-03T14:27:31.581Z |
5396927 | 5396927 | 20241026004712_A13W4 | FR0006 | 2024-10-28T12:17:59.645Z | 2024-11-03T14:27:31.371Z |
5396864 | 5396864 | 20241026004300_QrubP | FR0006 | 2024-10-28T12:17:58.271Z | 2024-11-03T14:27:31.273Z |
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);