participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,841 rows where station_code = "US001Q" 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 |
---|---|---|---|---|---|
4868373 | 4868373 | 20240806063042_2xdGu | US001Q | 2024-08-18T12:24:08.988Z | 2024-08-19T12:28:44.922Z |
4868160 | 4868160 | 20240806055325_Vyk7W | US001Q | 2024-08-18T12:24:00.918Z | 2024-08-19T12:28:37.534Z |
4867805 | 4867805 | 20240806040436_AACjQ | US001Q | 2024-08-18T12:23:48.084Z | 2024-08-19T12:28:27.218Z |
4837882 | 4837882 | 20240805080243_MqqmS | US001Q | 2024-08-16T12:01:30.048Z | 2024-08-19T12:15:27.596Z |
4819386 | 4819386 | 20240804112458_sWZLK | US001Q | 2024-08-14T12:04:48.565Z | 2024-08-17T12:25:27.942Z |
4819293 | 4819293 | 20240804111700_XI0e3 | US001Q | 2024-08-14T12:04:38.490Z | 2024-08-17T12:25:21.530Z |
4819289 | 4819289 | 20240804111628_XlNX2 | US001Q | 2024-08-14T12:04:38.160Z | 2024-08-17T12:25:21.445Z |
4819266 | 4819266 | 20240804111306_jnYPV | US001Q | 2024-08-14T12:04:35.756Z | 2024-08-17T12:25:20.229Z |
4818985 | 4818985 | 20240804103718_GmVIx | US001Q | 2024-08-14T12:03:56.533Z | 2024-08-17T12:24:58.986Z |
4818725 | 4818725 | 20240804100624_WPR3e | US001Q | 2024-08-14T12:03:23.130Z | 2024-08-17T12:24:47.952Z |
4818513 | 4818513 | 20240804093444_S64ED | US001Q | 2024-08-14T12:02:56.307Z | 2024-08-17T12:24:41.280Z |
4818422 | 4818422 | 20240804092217_UEAZ3 | US001Q | 2024-08-14T12:02:46.374Z | 2024-08-17T12:24:37.941Z |
4817872 | 4817872 | 20240804075813_r9vwC | US001Q | 2024-08-14T12:01:26.493Z | 2024-08-17T12:23:56.866Z |
4817718 | 4817718 | 20240804072737_BpBz2 | US001Q | 2024-08-14T12:01:00.463Z | 2024-08-17T12:23:40.189Z |
4817654 | 4817654 | 20240804070922_8WBVi | US001Q | 2024-08-14T12:00:51.922Z | 2024-08-17T12:23:36.641Z |
4817484 | 4817484 | 20240804060730_ft20L | US001Q | 2024-08-14T12:00:23.893Z | 2024-08-17T12:23:21.051Z |
4817438 | 4817438 | 20240804053752_MJCD7 | US001Q | 2024-08-14T12:00:14.064Z | 2024-08-17T12:23:18.562Z |
4797326 | 4797326 | 20240803043212_Skn37 | US001Q | 2024-08-12T12:00:12.193Z | 2024-08-15T12:17:05.801Z |
4764113 | 4764113 | 20240731075745_DR0SL | US001Q | 2024-08-06T12:05:40.715Z | 2024-08-10T12:18:39.364Z |
4763969 | 4763969 | 20240731073804_2wFXR | US001Q | 2024-08-06T12:05:32.692Z | 2024-08-10T12:18:35.219Z |
4763933 | 4763933 | 20240731073206_mMFCo | US001Q | 2024-08-06T12:05:30.101Z | 2024-08-10T12:18:34.500Z |
4763432 | 4763432 | 20240731054629_GmPMl | US001Q | 2024-08-06T12:04:33.765Z | 2024-08-10T12:18:18.730Z |
4763248 | 4763248 | 20240731043736_8waOE | US001Q | 2024-08-06T12:04:07.206Z | 2024-08-10T12:18:10.661Z |
4753033 | 4753033 | 20240730113954_fOnAW | US001Q | 2024-08-05T12:07:16.831Z | 2024-08-08T12:20:23.539Z |
4752959 | 4752959 | 20240730113020_LQddU | US001Q | 2024-08-05T12:07:10.745Z | 2024-08-08T12:20:20.977Z |
4752950 | 4752950 | 20240730112916_9C2bU | US001Q | 2024-08-05T12:07:09.862Z | 2024-08-08T12:20:20.715Z |
4752941 | 4752941 | 20240730112806_9cpno | US001Q | 2024-08-05T12:07:09.066Z | 2024-08-08T12:20:20.516Z |
4752660 | 4752660 | 20240730105802_7ODEM | US001Q | 2024-08-05T12:06:20.809Z | 2024-08-08T12:20:06.097Z |
4752234 | 4752234 | 20240730094544_3m7bl | US001Q | 2024-08-05T12:05:11.319Z | 2024-08-08T12:19:47.505Z |
4752210 | 4752210 | 20240730093939_KE3CQ | US001Q | 2024-08-05T12:05:05.723Z | 2024-08-08T12:19:45.279Z |
4752188 | 4752188 | 20240730093517_joKd0 | US001Q | 2024-08-05T12:05:01.183Z | 2024-08-08T12:19:44.276Z |
4752103 | 4752103 | 20240730091012_6a2Cg | US001Q | 2024-08-05T12:04:44.722Z | 2024-08-08T12:19:40.487Z |
4751830 | 4751830 | 20240730081540_QTsEE | US001Q | 2024-08-05T12:04:10.768Z | 2024-08-08T12:19:29.393Z |
4747031 | 4747031 | 20240730072429_waI2a | US001Q | 2024-08-04T12:09:45.625Z | 2024-08-08T12:19:18.045Z |
4746981 | 4746981 | 20240730071546_k4UT3 | US001Q | 2024-08-04T12:09:42.443Z | 2024-08-08T12:19:15.354Z |
4746807 | 4746807 | 20240730064050_1rNUE | US001Q | 2024-08-04T12:09:31.120Z | 2024-08-08T12:19:06.058Z |
4746711 | 4746711 | 20240730061832_wAZW3 | US001Q | 2024-08-04T12:09:25.110Z | 2024-08-08T12:19:02.140Z |
4738595 | 4738595 | 20240729113721_G1Lgc | US001Q | 2024-08-03T12:08:44.964Z | 2024-08-06T12:15:10.495Z |
4738523 | 4738523 | 20240729112136_zPWuS | US001Q | 2024-08-03T12:08:34.952Z | 2024-08-06T12:15:09.959Z |
4738519 | 4738519 | 20240729112031_xTAfr | US001Q | 2024-08-03T12:08:33.553Z | 2024-08-06T12:15:09.943Z |
4738418 | 4738418 | 20240729110253_5uzwE | US001Q | 2024-08-03T12:08:21.635Z | 2024-08-06T12:15:09.500Z |
4738318 | 4738318 | 20240729104056_FQjwC | US001Q | 2024-08-03T12:08:10.837Z | 2024-08-06T12:15:09.138Z |
4738304 | 4738304 | 20240729103837_22mop | US001Q | 2024-08-03T12:08:08.777Z | 2024-08-06T12:15:08.966Z |
4738301 | 4738301 | 20240729103832_BxrIg | US001Q | 2024-08-03T12:08:08.392Z | 2024-08-06T12:15:08.966Z |
4738239 | 4738239 | 20240729101656_q2RyT | US001Q | 2024-08-03T12:07:58.823Z | 2024-08-06T12:15:08.664Z |
4738220 | 4738220 | 20240729100915_AN0xs | US001Q | 2024-08-03T12:07:53.834Z | 2024-08-06T12:15:08.613Z |
4738212 | 4738212 | 20240729100626_pcgvl | US001Q | 2024-08-03T12:07:52.660Z | 2024-08-06T12:15:08.578Z |
4738201 | 4738201 | 20240729100327_AtDqq | US001Q | 2024-08-03T12:07:50.060Z | 2024-08-06T12:15:08.563Z |
4738182 | 4738182 | 20240729095505_9q5lP | US001Q | 2024-08-03T12:07:48.402Z | 2024-08-06T12:15:08.516Z |
4738177 | 4738177 | 20240729095338_S0xtJ | US001Q | 2024-08-03T12:07:47.447Z | 2024-08-06T12:15:08.489Z |
4738166 | 4738166 | 20240729094632_gEpUh | US001Q | 2024-08-03T12:07:46.192Z | 2024-08-06T12:15:08.458Z |
4738160 | 4738160 | 20240729094401_XUKm8 | US001Q | 2024-08-03T12:07:44.274Z | 2024-08-06T12:15:08.444Z |
4738097 | 4738097 | 20240729091749_9Y730 | US001Q | 2024-08-03T12:07:33.782Z | 2024-08-06T12:15:07.761Z |
4738009 | 4738009 | 20240729084601_loQFZ | US001Q | 2024-08-03T12:07:20.154Z | 2024-08-06T12:15:06.828Z |
4737990 | 4737990 | 20240729084054_pvPYZ | US001Q | 2024-08-03T12:07:17.724Z | 2024-08-06T12:15:06.734Z |
4737910 | 4737910 | 20240729082137_57qhV | US001Q | 2024-08-03T12:07:08.124Z | 2024-08-06T12:15:06.418Z |
4737845 | 4737845 | 20240729080100_MnlWx | US001Q | 2024-08-03T12:07:00.730Z | 2024-08-06T12:15:06.126Z |
4737791 | 4737791 | 20240729074642_vyB7T | US001Q | 2024-08-03T12:06:55.461Z | 2024-08-06T12:15:05.430Z |
4737663 | 4737663 | 20240729071902_6l82q | US001Q | 2024-08-03T12:06:28.117Z | 2024-08-06T12:15:04.069Z |
4737625 | 4737625 | 20240729070914_OT0BV | US001Q | 2024-08-03T12:06:22.064Z | 2024-08-06T12:15:03.721Z |
4737525 | 4737525 | 20240729063650_h7Qp4 | US001Q | 2024-08-03T12:06:02.857Z | 2024-08-06T12:15:03.089Z |
4737464 | 4737464 | 20240729062032_DCyhZ | US001Q | 2024-08-03T12:05:55.790Z | 2024-08-06T12:15:02.469Z |
4737200 | 4737200 | 20240729043008_FmwID | US001Q | 2024-08-03T12:04:53.667Z | 2024-08-06T12:14:57.579Z |
4737172 | 4737172 | 20240729040021_K3EIV | US001Q | 2024-08-03T12:04:44.543Z | 2024-08-06T12:14:57.314Z |
4725025 | 4725025 | 20240728113301_4J258 | US001Q | 2024-07-31T12:11:07.300Z | 2024-08-05T12:20:19.200Z |
4724906 | 4724906 | 20240728112455_dSuPY | US001Q | 2024-07-31T12:11:03.076Z | 2024-08-05T12:20:18.930Z |
4724555 | 4724555 | 20240728105730_7Vekb | US001Q | 2024-07-31T12:10:42.492Z | 2024-08-05T12:20:18.029Z |
4724448 | 4724448 | 20240728104621_xKylE | US001Q | 2024-07-31T12:10:35.689Z | 2024-08-05T12:20:17.587Z |
4723970 | 4723970 | 20240728095717_urDIw | US001Q | 2024-07-31T12:10:00.071Z | 2024-08-05T12:20:15.707Z |
4723856 | 4723856 | 20240728094546_LOi52 | US001Q | 2024-07-31T12:09:51.508Z | 2024-08-05T12:20:15.150Z |
4723161 | 4723161 | 20240728082757_mXcy3 | US001Q | 2024-07-31T12:09:10.694Z | 2024-08-05T12:20:12.042Z |
4723034 | 4723034 | 20240728081716_waurV | US001Q | 2024-07-31T12:09:05.430Z | 2024-08-05T12:20:10.904Z |
4722867 | 4722867 | 20240728075455_x14a9 | US001Q | 2024-07-31T12:08:58.760Z | 2024-08-05T12:20:09.420Z |
4722763 | 4722763 | 20240728074151_Cluy5 | US001Q | 2024-07-31T12:08:51.734Z | 2024-08-05T12:20:08.955Z |
4722626 | 4722626 | 20240728072743_9K1uk | US001Q | 2024-07-31T12:08:35.664Z | 2024-08-05T12:20:08.031Z |
4722589 | 4722589 | 20240728072156_b2Uw2 | US001Q | 2024-07-31T12:08:32.591Z | 2024-08-05T12:20:07.666Z |
4722529 | 4722529 | 20240728071558_3aAO6 | US001Q | 2024-07-31T12:08:28.148Z | 2024-08-05T12:20:07.323Z |
4722501 | 4722501 | 20240728071232_NWoEZ | US001Q | 2024-07-31T12:08:26.492Z | 2024-08-05T12:20:06.936Z |
4722485 | 4722485 | 20240728071135_w9SKT | US001Q | 2024-07-31T12:08:25.714Z | 2024-08-05T12:20:06.727Z |
4722428 | 4722428 | 20240728070417_2vmOQ | US001Q | 2024-07-31T12:08:21.017Z | 2024-08-05T12:20:06.126Z |
4722105 | 4722105 | 20240728061820_wfiAQ | US001Q | 2024-07-31T12:07:47.063Z | 2024-08-05T12:20:03.306Z |
4722000 | 4722000 | 20240728055920_dF2t8 | US001Q | 2024-07-31T12:07:35.762Z | 2024-08-05T12:20:02.898Z |
4721796 | 4721796 | 20240728050956_fFKIa | US001Q | 2024-07-31T12:07:15.674Z | 2024-08-05T12:20:01.921Z |
4707826 | 4707826 | 20240727073549_WYl2s | US001Q | 2024-07-29T12:08:16.966Z | 2024-08-04T12:19:27.278Z |
4707564 | 4707564 | 20240727064105_dLfbT | US001Q | 2024-07-29T12:07:45.939Z | 2024-08-04T12:19:22.902Z |
4707449 | 4707449 | 20240727060121_nbJfq | US001Q | 2024-07-29T12:07:29.739Z | 2024-08-04T12:19:20.848Z |
4707341 | 4707341 | 20240727044623_t2H9d | US001Q | 2024-07-29T12:07:15.705Z | 2024-08-04T12:19:18.861Z |
4707328 | 4707328 | 20240727043609_G3WWe | US001Q | 2024-07-29T12:07:13.715Z | 2024-08-04T12:19:18.779Z |
4659144 | 4659144 | 20240716082250_oobXR | US001Q | 2024-07-18T12:10:30.218Z | 2024-07-24T12:17:31.636Z |
4659034 | 4659034 | 20240716074822_ip3rO | US001Q | 2024-07-18T12:10:22.918Z | 2024-07-24T12:17:30.230Z |
4571640 | 4571640 | 20240706072956_3F9Aj | US001Q | 2024-07-08T12:04:22.876Z | 2024-07-14T12:13:58.724Z |
4571460 | 4571460 | 20240706065407_lG1d3 | US001Q | 2024-07-08T12:04:08.357Z | 2024-07-14T12:13:57.879Z |
4556943 | 4556943 | 20240704110218_IOHvt | US001Q | 2024-07-06T12:08:32.824Z | 2024-07-12T12:08:57.276Z |
4556410 | 4556410 | 20240704102424_IPUvc | US001Q | 2024-07-06T12:07:47.551Z | 2024-07-12T12:08:56.847Z |
4556393 | 4556393 | 20240704102204_cMsoL | US001Q | 2024-07-06T12:07:46.361Z | 2024-07-12T12:08:56.832Z |
4556365 | 4556365 | 20240704102058_44z5M | US001Q | 2024-07-06T12:07:44.951Z | 2024-07-12T12:08:56.827Z |
4556046 | 4556046 | 20240704095351_zTuO8 | US001Q | 2024-07-06T12:07:08.838Z | 2024-07-12T12:08:56.612Z |
4555700 | 4555700 | 20240704092340_Iv3DF | US001Q | 2024-07-06T12:06:40.289Z | 2024-07-12T12:08:56.368Z |
4555119 | 4555119 | 20240704081707_uL9Gt | US001Q | 2024-07-06T12:05:37.847Z | 2024-07-12T12:08:55.860Z |
4547070 | 4547070 | 20240703112319_uPU3H | US001Q | 2024-07-05T12:04:47.338Z | 2024-07-11T12:14:43.516Z |
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);