participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,003 rows where station_code = "SI0003" 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 |
---|---|---|---|---|---|
5565500 | 5565500 | 20241117030516_aQEv4 | SI0003 | 2024-11-21T14:23:10.768Z | 2024-11-23T14:25:43.056Z |
5549358 | 5549358 | 20241117043215_Lg2am | SI0003 | 2024-11-18T14:11:30.221Z | 2024-11-23T14:25:44.190Z |
5549285 | 5549285 | 20241117040930_x2N2m | SI0003 | 2024-11-18T14:11:24.950Z | 2024-11-23T14:25:43.932Z |
5549236 | 5549236 | 20241117035801_xmXO5 | SI0003 | 2024-11-18T14:11:20.614Z | 2024-11-23T14:25:43.784Z |
5549196 | 5549196 | 20241117034210_zB21X | SI0003 | 2024-11-18T14:11:15.702Z | 2024-11-23T14:25:43.382Z |
5549188 | 5549188 | 20241117033903_KYHvP | SI0003 | 2024-11-18T14:11:14.549Z | 2024-11-23T14:25:43.338Z |
5549165 | 5549165 | 20241117033441_urbiQ | SI0003 | 2024-11-18T14:11:12.259Z | 2024-11-23T14:25:43.306Z |
5549153 | 5549153 | 20241117032759_li0E0 | SI0003 | 2024-11-18T14:11:09.468Z | 2024-11-23T14:25:43.259Z |
5549129 | 5549129 | 20241117031628_Q9lAQ | SI0003 | 2024-11-18T14:11:01.858Z | 2024-11-23T14:25:43.210Z |
5462929 | 5462929 | 20241102015745_DvI2y | SI0003 | 2024-11-03T14:18:10.346Z | 2024-11-10T14:26:33.735Z |
5462797 | 5462797 | 20241102013359_eOemo | SI0003 | 2024-11-03T14:18:05.297Z | 2024-11-10T14:26:33.336Z |
5462709 | 5462709 | 20241102011650_Ki9bd | SI0003 | 2024-11-03T14:17:57.445Z | 2024-11-10T14:26:33.187Z |
5462670 | 5462670 | 20241102010539_hVgi9 | SI0003 | 2024-11-03T14:17:53.965Z | 2024-11-10T14:26:33.061Z |
5462625 | 5462625 | 20241102005753_tlpUq | SI0003 | 2024-11-03T14:17:48.570Z | 2024-11-10T14:26:33.005Z |
5462579 | 5462579 | 20241102004734_sUaHd | SI0003 | 2024-11-03T14:17:44.063Z | 2024-11-10T14:26:32.925Z |
5462540 | 5462540 | 20241102004206_HzpMZ | SI0003 | 2024-11-03T14:17:38.765Z | 2024-11-10T14:26:32.795Z |
5462454 | 5462454 | 20241102002306_6JDi7 | SI0003 | 2024-11-03T14:17:27.431Z | 2024-11-10T14:26:32.539Z |
5462302 | 5462302 | 20241101234400_iIF5R | SI0003 | 2024-11-03T14:17:12.225Z | 2024-11-10T14:26:32.124Z |
5462300 | 5462300 | 20241101234336_16pvu | SI0003 | 2024-11-03T14:17:11.919Z | 2024-11-10T14:26:32.115Z |
5462296 | 5462296 | 20241101234253_7tp3h | SI0003 | 2024-11-03T14:17:11.049Z | 2024-11-10T14:26:32.106Z |
5462267 | 5462267 | 20241101233502_7jwdv | SI0003 | 2024-11-03T14:17:07.582Z | 2024-11-10T14:26:32.081Z |
5462250 | 5462250 | 20241101233104_Wu8XU | SI0003 | 2024-11-03T14:17:06.062Z | 2024-11-10T14:26:32.031Z |
5452320 | 5452320 | 20241101025014_6gDnR | SI0003 | 2024-11-02T12:18:38.385Z | 2024-11-09T14:24:30.493Z |
5452304 | 5452304 | 20241101024420_1alrp | SI0003 | 2024-11-02T12:18:37.191Z | 2024-11-09T14:24:30.354Z |
5452292 | 5452292 | 20241101024238_JWLXQ | SI0003 | 2024-11-02T12:18:35.472Z | 2024-11-09T14:24:30.208Z |
5452287 | 5452287 | 20241101024217_bQN4i | SI0003 | 2024-11-02T12:18:35.082Z | 2024-11-09T14:24:30.146Z |
5452238 | 5452238 | 20241101022936_DUwRo | SI0003 | 2024-11-02T12:18:30.821Z | 2024-11-09T14:24:29.698Z |
5452228 | 5452228 | 20241101022551_VUAx3 | SI0003 | 2024-11-02T12:18:29.374Z | 2024-11-09T14:24:29.574Z |
5452165 | 5452165 | 20241101021259_BgGcO | SI0003 | 2024-11-02T12:18:22.056Z | 2024-11-09T14:24:28.536Z |
5452108 | 5452108 | 20241101020000_J2GGY | SI0003 | 2024-11-02T12:18:17.003Z | 2024-11-09T14:24:28.134Z |
5452026 | 5452026 | 20241101014727_rQ2d6 | SI0003 | 2024-11-02T12:18:12.722Z | 2024-11-09T14:24:27.660Z |
5451799 | 5451799 | 20241101010807_20n5K | SI0003 | 2024-11-02T12:17:57.794Z | 2024-11-09T14:24:25.498Z |
5451749 | 5451749 | 20241101005654_u7QiM | SI0003 | 2024-11-02T12:17:55.037Z | 2024-11-09T14:24:25.282Z |
5451742 | 5451742 | 20241101005611_QotHm | SI0003 | 2024-11-02T12:17:54.688Z | 2024-11-09T14:24:25.227Z |
5451668 | 5451668 | 20241101004228_lD8Tn | SI0003 | 2024-11-02T12:17:47.268Z | 2024-11-09T14:24:24.920Z |
5451644 | 5451644 | 20241101003814_2qKqY | SI0003 | 2024-11-02T12:17:43.248Z | 2024-11-09T14:24:24.671Z |
5451496 | 5451496 | 20241101000504_L8uAF | SI0003 | 2024-11-02T12:17:19.511Z | 2024-11-09T14:24:23.922Z |
5451445 | 5451445 | 20241031235640_y3HVv | SI0003 | 2024-11-02T12:17:10.370Z | 2024-11-09T14:24:23.675Z |
5451438 | 5451438 | 20241031235609_1ywWQ | SI0003 | 2024-11-02T12:17:09.862Z | 2024-11-09T14:24:23.655Z |
5451435 | 5451435 | 20241031235555_FMtyi | SI0003 | 2024-11-02T12:17:09.657Z | 2024-11-09T14:24:23.653Z |
5451392 | 5451392 | 20241031235014_A1Rcv | SI0003 | 2024-11-02T12:17:01.725Z | 2024-11-09T14:24:23.338Z |
5451273 | 5451273 | 20241031231851_37M3z | SI0003 | 2024-11-02T12:16:47.727Z | 2024-11-09T14:24:22.811Z |
5442257 | 5442257 | 20241030010220_SDWgs | SI0003 | 2024-11-01T12:19:36.392Z | 2024-11-07T14:26:45.742Z |
5442233 | 5442233 | 20241030005837_viZ0V | SI0003 | 2024-11-01T12:19:34.776Z | 2024-11-07T14:26:45.661Z |
5442190 | 5442190 | 20241030005252_2ljvO | SI0003 | 2024-11-01T12:19:32.826Z | 2024-11-07T14:26:45.507Z |
5442180 | 5442180 | 20241030004845_Xsv7y | SI0003 | 2024-11-01T12:19:32.278Z | 2024-11-07T14:26:45.315Z |
5442165 | 5442165 | 20241030004657_cqLr5 | SI0003 | 2024-11-01T12:19:31.383Z | 2024-11-07T14:26:45.225Z |
5442157 | 5442157 | 20241030004605_NNABK | SI0003 | 2024-11-01T12:19:31.060Z | 2024-11-07T14:26:45.218Z |
5442147 | 5442147 | 20241030004418_0bcOD | SI0003 | 2024-11-01T12:19:29.801Z | 2024-11-07T14:26:45.195Z |
5442137 | 5442137 | 20241030004311_236gk | SI0003 | 2024-11-01T12:19:29.227Z | 2024-11-07T14:26:45.156Z |
5442113 | 5442113 | 20241030003747_OyKS3 | SI0003 | 2024-11-01T12:19:26.088Z | 2024-11-07T14:26:45.063Z |
5442042 | 5442042 | 20241030002524_E5UPE | SI0003 | 2024-11-01T12:19:21.120Z | 2024-11-07T14:26:44.771Z |
5442040 | 5442040 | 20241030002450_jqhNz | SI0003 | 2024-11-01T12:19:21.028Z | 2024-11-07T14:26:44.769Z |
5442019 | 5442019 | 20241030001922_5pYBb | SI0003 | 2024-11-01T12:19:19.754Z | 2024-11-07T14:26:44.724Z |
5441999 | 5441999 | 20241030001708_2799F | SI0003 | 2024-11-01T12:19:17.336Z | 2024-11-07T14:26:44.635Z |
5441979 | 5441979 | 20241030001237_XzzPw | SI0003 | 2024-11-01T12:19:15.656Z | 2024-11-07T14:26:44.460Z |
5441971 | 5441971 | 20241030001209_MklL6 | SI0003 | 2024-11-01T12:19:15.309Z | 2024-11-07T14:26:44.454Z |
5441962 | 5441962 | 20241030001032_EQZXm | SI0003 | 2024-11-01T12:19:14.612Z | 2024-11-07T14:26:44.400Z |
5441944 | 5441944 | 20241030000728_uarL2 | SI0003 | 2024-11-01T12:19:13.324Z | 2024-11-07T14:26:44.377Z |
5441918 | 5441918 | 20241030000246_cZ3N2 | SI0003 | 2024-11-01T12:19:12.336Z | 2024-11-07T14:26:44.337Z |
5441894 | 5441894 | 20241029235743_fzl8C | SI0003 | 2024-11-01T12:19:11.459Z | 2024-11-07T14:26:44.237Z |
5441719 | 5441719 | 20241029231758_P32my | SI0003 | 2024-11-01T12:18:57.152Z | 2024-11-07T14:26:43.109Z |
5441695 | 5441695 | 20241029231153_jYVRy | SI0003 | 2024-11-01T12:18:53.907Z | 2024-11-07T14:26:43.057Z |
4990565 | 4990565 | 20240901003522_4MGrS | SI0003 | 2024-09-07T12:10:46.838Z | 2024-09-09T12:26:23.522Z |
4990549 | 4990549 | 20240901003120_1OyK7 | SI0003 | 2024-09-07T12:10:45.716Z | 2024-09-09T12:26:23.129Z |
4990173 | 4990173 | 20240831233754_56kmF | SI0003 | 2024-09-07T12:10:08.608Z | 2024-09-09T12:26:12.504Z |
4990155 | 4990155 | 20240831233622_cCeHa | SI0003 | 2024-09-07T12:10:07.812Z | 2024-09-09T12:26:12.125Z |
4990131 | 4990131 | 20240831233016_v7vMA | SI0003 | 2024-09-07T12:10:06.007Z | 2024-09-09T12:26:11.473Z |
4990008 | 4990008 | 20240831231507_k8rNR | SI0003 | 2024-09-07T12:09:54.982Z | 2024-09-09T12:26:08.670Z |
4989894 | 4989894 | 20240831225356_YSTQu | SI0003 | 2024-09-07T12:09:46.146Z | 2024-09-09T12:26:05.360Z |
4983299 | 4983299 | 20240812004301_L8gQg | SI0003 | 2024-09-06T12:15:25.774Z | 2024-09-06T12:15:25.774Z |
4982796 | 4982796 | 20240812003752_dtTdf | SI0003 | 2024-09-06T12:15:03.050Z | 2024-09-06T12:15:03.050Z |
4982725 | 4982725 | 20240812003632_e5448 | SI0003 | 2024-09-06T12:15:00.068Z | 2024-09-06T12:15:00.068Z |
4981787 | 4981787 | 20240812002726_fgxYa | SI0003 | 2024-09-06T12:14:37.753Z | 2024-09-06T12:14:37.753Z |
4981669 | 4981669 | 20240812002546_RJl9m | SI0003 | 2024-09-06T12:14:35.319Z | 2024-09-06T12:14:35.319Z |
4981375 | 4981375 | 20240812002103_eM3hL | SI0003 | 2024-09-06T12:14:30.113Z | 2024-09-06T12:14:30.113Z |
4981285 | 4981285 | 20240812002016_n42sE | SI0003 | 2024-09-06T12:14:29.241Z | 2024-09-06T12:14:29.241Z |
4980775 | 4980775 | 20240812001539_N04qX | SI0003 | 2024-09-06T12:14:15.892Z | 2024-09-06T12:14:15.892Z |
4980573 | 4980573 | 20240812001359_l6gml | SI0003 | 2024-09-06T12:14:05.714Z | 2024-09-06T12:14:05.714Z |
4980404 | 4980404 | 20240812001200_tGM3Z | SI0003 | 2024-09-06T12:13:58.853Z | 2024-09-06T12:13:58.853Z |
4980042 | 4980042 | 20240812000744_iSrqe | SI0003 | 2024-09-06T12:13:43.417Z | 2024-09-06T12:13:43.417Z |
4979809 | 4979809 | 20240812000505_0AaHz | SI0003 | 2024-09-06T12:13:29.885Z | 2024-09-06T12:13:29.885Z |
4979738 | 4979738 | 20240812000416_pia9u | SI0003 | 2024-09-06T12:13:25.601Z | 2024-09-06T12:13:25.601Z |
4979249 | 4979249 | 20240812000030_y2z2P | SI0003 | 2024-09-06T12:13:06.241Z | 2024-09-06T12:13:06.241Z |
4978405 | 4978405 | 20240811235035_cLHc7 | SI0003 | 2024-09-06T12:12:33.324Z | 2024-09-06T12:12:33.324Z |
4977703 | 4977703 | 20240811234355_V4Y0F | SI0003 | 2024-09-06T12:12:22.199Z | 2024-09-06T12:12:22.199Z |
4977174 | 4977174 | 20240811233653_vP3JG | SI0003 | 2024-09-06T12:12:06.350Z | 2024-09-06T12:12:06.350Z |
4977066 | 4977066 | 20240811233556_976JE | SI0003 | 2024-09-06T12:12:02.900Z | 2024-09-06T12:12:02.900Z |
4976516 | 4976516 | 20240811233114_JQjOX | SI0003 | 2024-09-06T12:11:34.956Z | 2024-09-06T12:11:34.956Z |
4973334 | 4973334 | 20240811225546_3WC2H | SI0003 | 2024-09-05T12:10:47.871Z | 2024-09-06T12:09:52.211Z |
4973249 | 4973249 | 20240811225518_37GCK | SI0003 | 2024-09-05T12:10:45.430Z | 2024-09-06T12:09:49.743Z |
4972918 | 4972918 | 20240811225158_6LMdE | SI0003 | 2024-09-05T12:10:37.547Z | 2024-09-06T12:09:33.575Z |
4972799 | 4972799 | 20240811225049_760Y9 | SI0003 | 2024-09-05T12:10:34.773Z | 2024-09-06T12:09:29.569Z |
4972770 | 4972770 | 20240811225009_R343t | SI0003 | 2024-09-05T12:10:33.626Z | 2024-09-06T12:09:27.884Z |
4972642 | 4972642 | 20240811224847_ViJ6x | SI0003 | 2024-09-05T12:10:30.349Z | 2024-09-06T12:09:21.838Z |
4972363 | 4972363 | 20240811224512_IN1q5 | SI0003 | 2024-09-05T12:10:22.937Z | 2024-09-06T12:09:10.568Z |
4970366 | 4970366 | 20240811222441_W9Y03 | SI0003 | 2024-09-05T12:09:24.803Z | 2024-09-06T12:08:38.081Z |
4969812 | 4969812 | 20240811221708_tVYjW | SI0003 | 2024-09-05T12:09:04.503Z | 2024-09-06T12:08:07.736Z |
4969791 | 4969791 | 20240811221639_2LaKx | SI0003 | 2024-09-05T12:09:02.235Z | 2024-09-06T12:08:06.663Z |
4969431 | 4969431 | 20240811221201_YysEu | SI0003 | 2024-09-05T12:08:45.306Z | 2024-09-06T12:07:52.112Z |
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);