participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
129 rows where station_code = "US0055" 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 |
---|---|---|---|---|---|
5137649 | 5137649 | 20240919112709_3uq8q | US0055 | 2024-09-20T12:05:16.702Z | 2024-09-20T12:06:55.232Z |
5136860 | 5136860 | 20240919050815_TaOr8 | US0055 | 2024-09-20T12:03:20.400Z | 2024-09-20T12:06:54.994Z |
5136852 | 5136852 | 20240919044514_6dlR3 | US0055 | 2024-09-20T12:03:18.662Z | 2024-09-20T12:06:54.991Z |
5136738 | 5136738 | 20240919034748_zBB3M | US0055 | 2024-09-20T12:03:01.753Z | 2024-09-20T12:06:54.951Z |
5134670 | 5134670 | 20240916111320_V6bhF | US0055 | 2024-09-19T12:18:03.189Z | 2024-09-20T12:14:29.506Z |
5134655 | 5134655 | 20240916110637_Ns7Du | US0055 | 2024-09-19T12:18:01.153Z | 2024-09-20T12:14:28.905Z |
5130344 | 5130344 | 20240917112954_EYTrl | US0055 | 2024-09-19T12:13:03.926Z | 2024-09-20T12:11:58.240Z |
5130285 | 5130285 | 20240917110331_oQF0K | US0055 | 2024-09-19T12:12:55.893Z | 2024-09-20T12:11:56.567Z |
5123796 | 5123796 | 20240914113243_QMR3c | US0055 | 2024-09-18T12:11:57.757Z | 2024-09-20T12:19:34.522Z |
5123762 | 5123762 | 20240914112405_vo2lX | US0055 | 2024-09-18T12:11:56.616Z | 2024-09-20T12:19:34.174Z |
5123658 | 5123658 | 20240914105912_1U3QL | US0055 | 2024-09-18T12:11:53.197Z | 2024-09-20T12:19:31.947Z |
5123567 | 5123567 | 20240914103530_dKr4a | US0055 | 2024-09-18T12:11:51.415Z | 2024-09-20T12:19:30.178Z |
5123544 | 5123544 | 20240914102747_Z5Pjo | US0055 | 2024-09-18T12:11:51.197Z | 2024-09-20T12:19:29.846Z |
5123411 | 5123411 | 20240914100016_NL7x1 | US0055 | 2024-09-18T12:11:48.100Z | 2024-09-20T12:19:26.171Z |
5122779 | 5122779 | 20240914075729_BUXKW | US0055 | 2024-09-18T12:11:30.916Z | 2024-09-20T12:19:15.388Z |
5122697 | 5122697 | 20240914073249_qk2vp | US0055 | 2024-09-18T12:11:28.601Z | 2024-09-20T12:19:14.000Z |
5122675 | 5122675 | 20240914073036_qvAjM | US0055 | 2024-09-18T12:11:28.001Z | 2024-09-20T12:19:13.563Z |
5122506 | 5122506 | 20240914065407_Rax8d | US0055 | 2024-09-18T12:11:21.075Z | 2024-09-20T12:19:12.446Z |
5122482 | 5122482 | 20240914063938_kejQ2 | US0055 | 2024-09-18T12:11:20.512Z | 2024-09-20T12:19:12.252Z |
5118884 | 5118884 | 20240915112638_hDFj1 | US0055 | 2024-09-18T12:09:11.304Z | 2024-09-20T12:17:41.601Z |
5118856 | 5118856 | 20240915112031_NZ8vE | US0055 | 2024-09-18T12:09:08.996Z | 2024-09-20T12:17:40.808Z |
5118785 | 5118785 | 20240915110735_GMJZB | US0055 | 2024-09-18T12:09:02.975Z | 2024-09-20T12:17:39.240Z |
5118662 | 5118662 | 20240915104137_avZCy | US0055 | 2024-09-18T12:08:57.127Z | 2024-09-20T12:17:36.555Z |
5118610 | 5118610 | 20240915102935_vRWQr | US0055 | 2024-09-18T12:08:53.033Z | 2024-09-20T12:17:35.040Z |
5118608 | 5118608 | 20240915102725_PSE23 | US0055 | 2024-09-18T12:08:52.921Z | 2024-09-20T12:17:34.998Z |
5118517 | 5118517 | 20240915100632_0Opbw | US0055 | 2024-09-18T12:08:49.414Z | 2024-09-20T12:17:33.140Z |
5118450 | 5118450 | 20240915094859_eIDiE | US0055 | 2024-09-18T12:08:44.793Z | 2024-09-20T12:17:30.999Z |
5118440 | 5118440 | 20240915094724_QF88R | US0055 | 2024-09-18T12:08:44.242Z | 2024-09-20T12:17:30.798Z |
5118356 | 5118356 | 20240915092805_zs5iE | US0055 | 2024-09-18T12:08:39.448Z | 2024-09-20T12:17:28.622Z |
5118192 | 5118192 | 20240915084841_JW4ai | US0055 | 2024-09-18T12:08:29.283Z | 2024-09-20T12:17:24.304Z |
5118128 | 5118128 | 20240915083747_jjoPK | US0055 | 2024-09-18T12:08:25.928Z | 2024-09-20T12:17:22.514Z |
5118123 | 5118123 | 20240915083617_jZt0D | US0055 | 2024-09-18T12:08:25.284Z | 2024-09-20T12:17:22.469Z |
5118100 | 5118100 | 20240915083258_XWWu2 | US0055 | 2024-09-18T12:08:24.159Z | 2024-09-20T12:17:22.143Z |
5082808 | 5082808 | 20240911110217_k25yH | US0055 | 2024-09-15T12:18:25.961Z | 2024-09-19T12:21:48.689Z |
5082721 | 5082721 | 20240911104934_yyeea | US0055 | 2024-09-15T12:18:23.896Z | 2024-09-19T12:21:48.473Z |
5082619 | 5082619 | 20240911103553_EmUof | US0055 | 2024-09-15T12:18:21.042Z | 2024-09-19T12:21:48.184Z |
5079626 | 5079626 | 20240911030636_VUCFm | US0055 | 2024-09-15T12:16:31.729Z | 2024-09-19T12:21:42.520Z |
5068277 | 5068277 | 20240910111640_BsQas | US0055 | 2024-09-14T12:19:11.631Z | 2024-09-18T12:15:25.856Z |
5068036 | 5068036 | 20240910104520_SJCfN | US0055 | 2024-09-14T12:19:07.404Z | 2024-09-18T12:15:25.413Z |
5067972 | 5067972 | 20240910103808_JLEWQ | US0055 | 2024-09-14T12:19:05.973Z | 2024-09-18T12:15:25.299Z |
5067541 | 5067541 | 20240910094303_zBtql | US0055 | 2024-09-14T12:18:47.898Z | 2024-09-18T12:15:24.333Z |
5066966 | 5066966 | 20240910083518_5c93e | US0055 | 2024-09-14T12:18:23.499Z | 2024-09-18T12:15:23.059Z |
5066881 | 5066881 | 20240910082805_dMvcj | US0055 | 2024-09-14T12:18:17.886Z | 2024-09-18T12:15:22.920Z |
5066762 | 5066762 | 20240910081340_XTUyY | US0055 | 2024-09-14T12:18:11.073Z | 2024-09-18T12:15:22.719Z |
5066700 | 5066700 | 20240910080446_UJz4Z | US0055 | 2024-09-14T12:18:08.066Z | 2024-09-18T12:15:22.516Z |
5066506 | 5066506 | 20240910074121_GWMnY | US0055 | 2024-09-14T12:17:59.511Z | 2024-09-18T12:15:22.082Z |
5056781 | 5056781 | 20240908112344_72Zck | US0055 | 2024-09-13T12:17:39.237Z | 2024-09-16T12:21:27.279Z |
5056580 | 5056580 | 20240908104551_5NeFf | US0055 | 2024-09-13T12:17:35.557Z | 2024-09-16T12:21:25.960Z |
5056445 | 5056445 | 20240908103054_gyzgE | US0055 | 2024-09-13T12:17:32.241Z | 2024-09-16T12:21:25.424Z |
5056218 | 5056218 | 20240908095610_n7O27 | US0055 | 2024-09-13T12:17:28.523Z | 2024-09-16T12:21:23.871Z |
5056104 | 5056104 | 20240908094157_V4236 | US0055 | 2024-09-13T12:17:27.490Z | 2024-09-16T12:21:23.300Z |
5055934 | 5055934 | 20240908092100_t8woq | US0055 | 2024-09-13T12:17:25.752Z | 2024-09-16T12:21:22.617Z |
5055490 | 5055490 | 20240908081120_muK20 | US0055 | 2024-09-13T12:17:15.255Z | 2024-09-16T12:21:19.996Z |
5055408 | 5055408 | 20240908080022_0omMk | US0055 | 2024-09-13T12:17:11.767Z | 2024-09-16T12:21:19.314Z |
5055340 | 5055340 | 20240908075215_6Y00U | US0055 | 2024-09-13T12:17:10.094Z | 2024-09-16T12:21:18.855Z |
5055310 | 5055310 | 20240908074529_weBjQ | US0055 | 2024-09-13T12:17:09.398Z | 2024-09-16T12:21:18.678Z |
5055252 | 5055252 | 20240908073416_OH21k | US0055 | 2024-09-13T12:17:08.418Z | 2024-09-16T12:21:18.546Z |
5055070 | 5055070 | 20240908062743_QixbZ | US0055 | 2024-09-13T12:17:04.857Z | 2024-09-16T12:21:17.861Z |
5055020 | 5055020 | 20240908060619_a3U3O | US0055 | 2024-09-13T12:17:03.634Z | 2024-09-16T12:21:17.710Z |
5054954 | 5054954 | 20240908054031_Bd2d6 | US0055 | 2024-09-13T12:17:00.130Z | 2024-09-16T12:21:17.387Z |
5054944 | 5054944 | 20240908053241_9Rh2T | US0055 | 2024-09-13T12:16:59.980Z | 2024-09-16T12:21:17.359Z |
5049238 | 5049238 | 20240909102438_tQ95a | US0055 | 2024-09-13T12:11:48.686Z | 2024-09-17T12:19:09.601Z |
5049161 | 5049161 | 20240909101825_UwhZE | US0055 | 2024-09-13T12:11:40.680Z | 2024-09-17T12:19:09.399Z |
5047795 | 5047795 | 20240909055730_KB72L | US0055 | 2024-09-13T12:09:42.634Z | 2024-09-17T12:19:04.324Z |
5047769 | 5047769 | 20240909055032_84vC4 | US0055 | 2024-09-13T12:09:39.746Z | 2024-09-17T12:19:04.251Z |
5047731 | 5047731 | 20240909053916_gA7Bq | US0055 | 2024-09-13T12:09:36.796Z | 2024-09-17T12:19:04.138Z |
5042362 | 5042362 | 20240906104326_xuPKZ | US0055 | 2024-09-12T12:17:01.515Z | 2024-09-14T12:23:17.121Z |
5042032 | 5042032 | 20240906094313_FhHsd | US0055 | 2024-09-12T12:16:54.420Z | 2024-09-14T12:23:15.821Z |
5041916 | 5041916 | 20240906092222_ZfgfG | US0055 | 2024-09-12T12:16:52.436Z | 2024-09-14T12:23:15.366Z |
5041084 | 5041084 | 20240906071508_3iqt4 | US0055 | 2024-09-12T12:16:33.396Z | 2024-09-14T12:23:11.735Z |
5040944 | 5040944 | 20240906063526_24pKo | US0055 | 2024-09-12T12:16:29.024Z | 2024-09-14T12:23:11.060Z |
5040592 | 5040592 | 20240906045947_nMQwa | US0055 | 2024-09-12T12:16:17.162Z | 2024-09-14T12:23:10.015Z |
5040510 | 5040510 | 20240906043216_2C862 | US0055 | 2024-09-12T12:16:13.881Z | 2024-09-14T12:23:09.569Z |
5040423 | 5040423 | 20240906040737_BzVU1 | US0055 | 2024-09-12T12:16:10.824Z | 2024-09-14T12:23:09.125Z |
5039919 | 5039919 | 20240906022635_VvWCv | US0055 | 2024-09-12T12:15:50.907Z | 2024-09-14T12:23:05.831Z |
5035645 | 5035645 | 20240907095814_royb5 | US0055 | 2024-09-12T12:12:18.628Z | 2024-09-15T12:21:40.446Z |
5035578 | 5035578 | 20240907095150_q0SiM | US0055 | 2024-09-12T12:12:13.840Z | 2024-09-15T12:21:40.004Z |
5035330 | 5035330 | 20240907091955_tX5pb | US0055 | 2024-09-12T12:12:00.584Z | 2024-09-15T12:21:39.358Z |
5035105 | 5035105 | 20240907084328_aJNU4 | US0055 | 2024-09-12T12:11:52.555Z | 2024-09-15T12:21:38.239Z |
5035074 | 5035074 | 20240907084109_m99Bk | US0055 | 2024-09-12T12:11:51.511Z | 2024-09-15T12:21:38.131Z |
5034998 | 5034998 | 20240907082837_OQzOq | US0055 | 2024-09-12T12:11:48.645Z | 2024-09-15T12:21:37.849Z |
5034604 | 5034604 | 20240907072712_R3nCq | US0055 | 2024-09-12T12:11:07.158Z | 2024-09-15T12:21:35.266Z |
5034131 | 5034131 | 20240907054244_RJlOw | US0055 | 2024-09-12T12:10:37.662Z | 2024-09-15T12:21:32.881Z |
5033096 | 5033096 | 20240907022438_qbxKW | US0055 | 2024-09-12T12:08:49.092Z | 2024-09-15T12:21:29.007Z |
5029718 | 5029718 | 20240906111548_MASoQ | US0055 | 2024-09-12T12:00:24.559Z | 2024-09-15T12:21:16.959Z |
5029539 | 5029539 | 20240905095354_7PtM2 | US0055 | 2024-09-11T12:16:43.491Z | 2024-09-13T12:20:06.477Z |
5028873 | 5028873 | 20240905110447_7sKcr | US0055 | 2024-09-11T12:15:57.116Z | 2024-09-14T12:22:49.858Z |
5028813 | 5028813 | 20240905105317_wmD0K | US0055 | 2024-09-11T12:15:54.274Z | 2024-09-14T12:22:49.642Z |
5028720 | 5028720 | 20240905104226_awp36 | US0055 | 2024-09-11T12:15:45.411Z | 2024-09-14T12:22:49.123Z |
5028487 | 5028487 | 20240905101703_LkIN4 | US0055 | 2024-09-11T12:15:28.753Z | 2024-09-14T12:22:47.711Z |
5028377 | 5028377 | 20240905093233_9VFx9 | US0055 | 2024-09-11T12:15:13.079Z | 2024-09-13T12:20:06.072Z |
5028339 | 5028339 | 20240905092915_xywOE | US0055 | 2024-09-11T12:15:10.814Z | 2024-09-13T12:20:06.030Z |
5028246 | 5028246 | 20240905091831_cAxcp | US0055 | 2024-09-11T12:15:03.949Z | 2024-09-13T12:20:05.842Z |
5027646 | 5027646 | 20240905080400_ymO8o | US0055 | 2024-09-11T12:14:21.982Z | 2024-09-13T12:20:04.150Z |
5025600 | 5025600 | 20240906022635_LLZdx | US0055 | 2024-09-11T12:06:55.588Z | 2024-09-11T12:16:32.711Z |
5022970 | 5022970 | 20240905095354_938bj | US0055 | 2024-09-10T12:16:33.442Z | 2024-09-11T12:15:19.837Z |
5022812 | 5022812 | 20240905093233_ayR3q | US0055 | 2024-09-10T12:16:30.262Z | 2024-09-10T12:16:55.618Z |
5022774 | 5022774 | 20240905092915_VXDqi | US0055 | 2024-09-10T12:16:29.686Z | 2024-09-10T12:16:55.612Z |
5022682 | 5022682 | 20240905091831_XCKEN | US0055 | 2024-09-10T12:16:27.188Z | 2024-09-10T12:16:55.596Z |
5022087 | 5022087 | 20240905080400_Mh247 | US0055 | 2024-09-10T12:16:04.483Z | 2024-09-10T12:16:55.491Z |
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);