participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0008" 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 |
---|---|---|---|---|---|
5565365 | 5565365 | 20241120042113_qvt7C | US0008 | 2024-11-21T14:18:47.200Z | 2024-11-21T14:18:54.198Z |
5560412 | 5560412 | 20241120124845_wk3zR | US0008 | 2024-11-21T14:08:48.482Z | 2024-11-21T14:08:48.482Z |
5560387 | 5560387 | 20241120124624_n2peD | US0008 | 2024-11-21T14:08:46.719Z | 2024-11-21T14:08:46.719Z |
5560351 | 5560351 | 20241120124126_IXIGQ | US0008 | 2024-11-21T14:08:42.825Z | 2024-11-21T14:08:42.825Z |
5560308 | 5560308 | 20241120123322_Tap3g | US0008 | 2024-11-21T14:08:34.843Z | 2024-11-21T14:08:34.843Z |
5560216 | 5560216 | 20241120121926_3uiqk | US0008 | 2024-11-21T14:08:17.988Z | 2024-11-21T14:08:17.988Z |
5560040 | 5560040 | 20241120114950_YQzXy | US0008 | 2024-11-21T14:07:55.697Z | 2024-11-21T14:07:55.697Z |
5559967 | 5559967 | 20241120113949_IFWsQ | US0008 | 2024-11-21T14:07:42.590Z | 2024-11-21T14:07:42.590Z |
5559811 | 5559811 | 20241120112127_NoRsY | US0008 | 2024-11-21T14:07:14.397Z | 2024-11-21T14:07:14.397Z |
5559749 | 5559749 | 20241120111222_BHY8x | US0008 | 2024-11-21T14:07:06.883Z | 2024-11-21T14:07:06.883Z |
5559713 | 5559713 | 20241120110423_WrMm6 | US0008 | 2024-11-21T14:07:02.236Z | 2024-11-21T14:07:02.236Z |
5559446 | 5559446 | 20241120102448_0XBif | US0008 | 2024-11-21T14:06:21.458Z | 2024-11-21T14:06:21.458Z |
5559275 | 5559275 | 20241120095249_tQH3h | US0008 | 2024-11-21T14:05:47.836Z | 2024-11-21T14:05:47.836Z |
5558916 | 5558916 | 20241120085000_vMPA2 | US0008 | 2024-11-21T14:04:48.333Z | 2024-11-21T14:04:48.333Z |
5558833 | 5558833 | 20241120082228_hOIjN | US0008 | 2024-11-21T14:04:32.316Z | 2024-11-21T14:04:32.316Z |
5558785 | 5558785 | 20241120080125_G6WAl | US0008 | 2024-11-21T14:04:21.930Z | 2024-11-21T14:04:21.930Z |
5558202 | 5558202 | 20241120054507_2D26O | US0008 | 2024-11-21T14:02:43.476Z | 2024-11-21T14:02:43.476Z |
5557374 | 5557374 | 20241120044131_O8lWX | US0008 | 2024-11-21T14:00:38.620Z | 2024-11-21T14:00:38.620Z |
5557018 | 5557018 | 20241119032416_q1l4H | US0008 | 2024-11-20T14:12:00.482Z | 2024-11-21T14:20:43.347Z |
5556857 | 5556857 | 20241119021848_wF5HJ | US0008 | 2024-11-20T14:11:34.605Z | 2024-11-21T14:20:37.438Z |
5555150 | 5555150 | 20241119115610_2hySj | US0008 | 2024-11-20T14:04:34.137Z | 2024-11-21T14:18:53.212Z |
5555112 | 5555112 | 20241119114723_i11BM | US0008 | 2024-11-20T14:04:28.791Z | 2024-11-21T14:18:53.204Z |
5555105 | 5555105 | 20241119114528_aVyBD | US0008 | 2024-11-20T14:04:27.908Z | 2024-11-21T14:18:53.202Z |
5555093 | 5555093 | 20241119114227_5KXIg | US0008 | 2024-11-20T14:04:26.906Z | 2024-11-21T14:18:53.201Z |
5555026 | 5555026 | 20241119112312_DrkRp | US0008 | 2024-11-20T14:04:08.961Z | 2024-11-21T14:18:53.186Z |
5555010 | 5555010 | 20241119111935_A52W4 | US0008 | 2024-11-20T14:04:06.234Z | 2024-11-21T14:18:53.183Z |
5554852 | 5554852 | 20241119105033_X9Hbk | US0008 | 2024-11-20T14:03:33.489Z | 2024-11-21T14:18:53.148Z |
5554784 | 5554784 | 20241119103918_gLWWX | US0008 | 2024-11-20T14:03:17.391Z | 2024-11-21T14:18:53.132Z |
5554758 | 5554758 | 20241119102956_cr80e | US0008 | 2024-11-20T14:03:12.615Z | 2024-11-21T14:18:53.126Z |
5554650 | 5554650 | 20241119095846_5GD4Q | US0008 | 2024-11-20T14:02:56.489Z | 2024-11-21T14:18:53.103Z |
5554632 | 5554632 | 20241119095200_7BJ3N | US0008 | 2024-11-20T14:02:51.474Z | 2024-11-21T14:18:53.099Z |
5554528 | 5554528 | 20241119092708_wbI2m | US0008 | 2024-11-20T14:02:22.278Z | 2024-11-21T14:18:53.075Z |
5554523 | 5554523 | 20241119092626_1AYY3 | US0008 | 2024-11-20T14:02:21.829Z | 2024-11-21T14:18:53.074Z |
5554347 | 5554347 | 20241119082335_dZcKy | US0008 | 2024-11-20T14:01:43.817Z | 2024-11-21T14:18:53.033Z |
5554294 | 5554294 | 20241119075108_V8Ge7 | US0008 | 2024-11-20T14:01:25.408Z | 2024-11-21T14:18:53.021Z |
5554245 | 5554245 | 20241119072414_pB6Y3 | US0008 | 2024-11-20T14:01:14.253Z | 2024-11-21T14:18:53.009Z |
5551233 | 5551233 | 20241118124822_SpYFQ | US0008 | 2024-11-19T14:04:08.376Z | 2024-11-21T14:19:46.383Z |
5551199 | 5551199 | 20241118124353_4kcFF | US0008 | 2024-11-19T14:04:06.138Z | 2024-11-21T14:19:45.677Z |
5551137 | 5551137 | 20241118123042_72hd4 | US0008 | 2024-11-19T14:03:58.233Z | 2024-11-21T14:19:44.447Z |
5551001 | 5551001 | 20241118120755_p9B7l | US0008 | 2024-11-19T14:03:45.567Z | 2024-11-21T14:19:40.907Z |
5550972 | 5550972 | 20241118120525_2tctX | US0008 | 2024-11-19T14:03:43.081Z | 2024-11-21T14:19:40.127Z |
5550895 | 5550895 | 20241118114453_hOssa | US0008 | 2024-11-19T14:03:21.064Z | 2024-11-21T14:19:36.681Z |
5550893 | 5550893 | 20241118114430_2YgCU | US0008 | 2024-11-19T14:03:20.565Z | 2024-11-21T14:19:36.605Z |
5550804 | 5550804 | 20241118113034_zZhuK | US0008 | 2024-11-19T14:03:08.084Z | 2024-11-21T14:19:33.294Z |
5550703 | 5550703 | 20241118111156_WgX1C | US0008 | 2024-11-19T14:02:57.018Z | 2024-11-21T14:19:28.249Z |
5550655 | 5550655 | 20241118110327_xPPUc | US0008 | 2024-11-19T14:02:52.536Z | 2024-11-21T14:19:26.836Z |
5550453 | 5550453 | 20241118102243_TCJ1Y | US0008 | 2024-11-19T14:02:22.006Z | 2024-11-21T14:19:18.754Z |
5548843 | 5548843 | 20241117015832_FSHom | US0008 | 2024-11-18T14:10:19.204Z | 2024-11-21T14:23:04.725Z |
5545880 | 5545880 | 20241117074155_wtFNH | US0008 | 2024-11-18T14:01:18.258Z | 2024-11-21T14:21:03.840Z |
5545866 | 5545866 | 20241117073513_S9RV8 | US0008 | 2024-11-18T14:01:15.413Z | 2024-11-21T14:21:03.133Z |
5545791 | 5545791 | 20241117070029_ZtbJW | US0008 | 2024-11-18T14:00:58.078Z | 2024-11-21T14:21:00.418Z |
5545779 | 5545779 | 20241117065540_CXc1C | US0008 | 2024-11-18T14:00:56.512Z | 2024-11-21T14:21:00.123Z |
5544571 | 5544571 | 20241116124033_yFlNe | US0008 | 2024-11-17T14:01:35.229Z | 2024-11-21T14:22:36.934Z |
5544549 | 5544549 | 20241116122027_GR5Ha | US0008 | 2024-11-17T14:01:31.930Z | 2024-11-21T14:22:36.680Z |
5544473 | 5544473 | 20241116114047_v1YKd | US0008 | 2024-11-17T14:01:15.714Z | 2024-11-21T14:22:34.468Z |
5544386 | 5544386 | 20241116104225_b3Md3 | US0008 | 2024-11-17T14:01:00.047Z | 2024-11-21T14:22:32.688Z |
5544368 | 5544368 | 20241116102442_DlGTi | US0008 | 2024-11-17T14:00:57.363Z | 2024-11-21T14:22:32.397Z |
5544355 | 5544355 | 20241116101825_j6eQO | US0008 | 2024-11-17T14:00:56.013Z | 2024-11-21T14:22:32.098Z |
5544333 | 5544333 | 20241116100530_aK8k5 | US0008 | 2024-11-17T14:00:52.860Z | 2024-11-21T14:22:31.439Z |
5544308 | 5544308 | 20241116095006_j8obR | US0008 | 2024-11-17T14:00:49.716Z | 2024-11-21T14:22:30.864Z |
5544302 | 5544302 | 20241116094812_0Lo5F | US0008 | 2024-11-17T14:00:48.988Z | 2024-11-21T14:22:30.670Z |
5544225 | 5544225 | 20241116084436_CHfKy | US0008 | 2024-11-17T14:00:30.974Z | 2024-11-21T14:22:28.992Z |
5544201 | 5544201 | 20241116080742_cKmTO | US0008 | 2024-11-17T14:00:26.887Z | 2024-11-21T14:22:28.508Z |
5544171 | 5544171 | 20241116072932_cjI0u | US0008 | 2024-11-17T14:00:22.255Z | 2024-11-21T14:22:28.200Z |
5544168 | 5544168 | 20241116072525_CMkzd | US0008 | 2024-11-17T14:00:21.973Z | 2024-11-21T14:22:28.164Z |
5544134 | 5544134 | 20241116064621_xlj6J | US0008 | 2024-11-17T14:00:17.783Z | 2024-11-21T14:22:27.916Z |
5544126 | 5544126 | 20241116064028_xlYQv | US0008 | 2024-11-17T14:00:16.712Z | 2024-11-21T14:22:27.856Z |
5544079 | 5544079 | 20241116053724_UKcct | US0008 | 2024-11-17T14:00:08.970Z | 2024-11-21T14:22:26.645Z |
5544023 | 5544023 | 20241115051651_lTIf4 | US0008 | 2024-11-16T14:07:49.755Z | 2024-11-21T14:24:37.806Z |
5542693 | 5542693 | 20241115115101_gOmmM | US0008 | 2024-11-16T14:02:12.312Z | 2024-11-21T14:23:33.273Z |
5542684 | 5542684 | 20241115114731_O524K | US0008 | 2024-11-16T14:02:11.254Z | 2024-11-21T14:23:33.256Z |
5542633 | 5542633 | 20241115112340_vTlwL | US0008 | 2024-11-16T14:02:04.821Z | 2024-11-21T14:23:31.478Z |
5542597 | 5542597 | 20241115110924_8SEn7 | US0008 | 2024-11-16T14:01:53.030Z | 2024-11-21T14:23:30.377Z |
5542437 | 5542437 | 20241115094411_2NCaI | US0008 | 2024-11-16T14:01:16.582Z | 2024-11-21T14:23:27.207Z |
5542355 | 5542355 | 20241115085346_S5Qx8 | US0008 | 2024-11-16T14:01:03.206Z | 2024-11-21T14:23:26.028Z |
5542354 | 5542354 | 20241115085315_17jAP | US0008 | 2024-11-16T14:01:02.873Z | 2024-11-21T14:23:25.987Z |
5542291 | 5542291 | 20241115080843_hZ0Qz | US0008 | 2024-11-16T14:00:54.923Z | 2024-11-21T14:23:24.959Z |
5542263 | 5542263 | 20241115074847_Uv3gL | US0008 | 2024-11-16T14:00:50.720Z | 2024-11-21T14:23:24.431Z |
5542179 | 5542179 | 20241115064539_DjJ9b | US0008 | 2024-11-16T14:00:32.011Z | 2024-11-21T14:23:22.021Z |
5542166 | 5542166 | 20241115062527_odeUd | US0008 | 2024-11-16T14:00:28.167Z | 2024-11-21T14:23:21.775Z |
5541873 | 5541873 | 20241114050049_OeyOQ | US0008 | 2024-11-15T14:08:36.403Z | 2024-11-21T14:25:20.085Z |
5541592 | 5541592 | 20241114030514_ezkEv | US0008 | 2024-11-15T14:07:55.431Z | 2024-11-21T14:25:17.100Z |
5541011 | 5541011 | 20241114124446_uwqGP | US0008 | 2024-11-15T14:04:56.180Z | 2024-11-21T14:24:18.279Z |
5540820 | 5540820 | 20241114121119_J2ECc | US0008 | 2024-11-15T14:04:31.561Z | 2024-11-21T14:24:16.564Z |
5540573 | 5540573 | 20241114113321_sjUrO | US0008 | 2024-11-15T14:04:04.664Z | 2024-11-21T14:24:13.742Z |
5540433 | 5540433 | 20241114110511_w2Vs2 | US0008 | 2024-11-15T14:03:46.044Z | 2024-11-21T14:24:11.248Z |
5540408 | 5540408 | 20241114105605_13LFN | US0008 | 2024-11-15T14:03:37.388Z | 2024-11-21T14:24:11.081Z |
5540373 | 5540373 | 20241114104642_MJ5b4 | US0008 | 2024-11-15T14:03:32.040Z | 2024-11-21T14:24:10.867Z |
5540329 | 5540329 | 20241114103734_plyda | US0008 | 2024-11-15T14:03:26.832Z | 2024-11-21T14:24:10.361Z |
5540136 | 5540136 | 20241114101220_KmhCE | US0008 | 2024-11-15T14:03:00.493Z | 2024-11-21T14:24:08.206Z |
5540079 | 5540079 | 20241114100316_6VhIA | US0008 | 2024-11-15T14:02:52.236Z | 2024-11-21T14:24:07.696Z |
5539822 | 5539822 | 20241114090533_brdSR | US0008 | 2024-11-15T14:02:07.725Z | 2024-11-21T14:24:02.509Z |
5539782 | 5539782 | 20241114085912_zgnLO | US0008 | 2024-11-15T14:01:58.152Z | 2024-11-21T14:24:01.472Z |
5539686 | 5539686 | 20241114083802_sVfAI | US0008 | 2024-11-15T14:01:41.375Z | 2024-11-21T14:23:59.967Z |
5539657 | 5539657 | 20241114082425_19txB | US0008 | 2024-11-15T14:01:37.499Z | 2024-11-21T14:23:59.160Z |
5539591 | 5539591 | 20241114080132_T0BNV | US0008 | 2024-11-15T14:01:29.519Z | 2024-11-21T14:23:57.911Z |
5539525 | 5539525 | 20241114074152_Js6eM | US0008 | 2024-11-15T14:01:15.239Z | 2024-11-21T14:23:57.367Z |
5539496 | 5539496 | 20241114073253_m65OB | US0008 | 2024-11-15T14:01:09.267Z | 2024-11-21T14:23:56.906Z |
5539479 | 5539479 | 20241114071939_Q3z0R | US0008 | 2024-11-15T14:01:06.817Z | 2024-11-21T14:23:56.401Z |
5539020 | 5539020 | 20241113053334_jTTto | US0008 | 2024-11-14T14:14:08.582Z | 2024-11-21T14:26:31.018Z |
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);