participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
214 rows where station_code = "US0054" 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 |
---|---|---|---|---|---|
5123230 | 5123230 | 20240914092027_5c4Kl | US0054 | 2024-09-18T12:11:43.012Z | 2024-09-20T12:19:23.847Z |
5123171 | 5123171 | 20240914091250_Iv2wP | US0054 | 2024-09-18T12:11:41.619Z | 2024-09-20T12:19:23.175Z |
5123010 | 5123010 | 20240914083900_YM5d3 | US0054 | 2024-09-18T12:11:37.909Z | 2024-09-20T12:19:20.703Z |
5122916 | 5122916 | 20240914082301_CthrL | US0054 | 2024-09-18T12:11:34.032Z | 2024-09-20T12:19:18.877Z |
5122801 | 5122801 | 20240914080112_ajr3p | US0054 | 2024-09-18T12:11:31.573Z | 2024-09-20T12:19:15.854Z |
5122785 | 5122785 | 20240914075752_daW0I | US0054 | 2024-09-18T12:11:31.138Z | 2024-09-20T12:19:15.703Z |
5122766 | 5122766 | 20240914075459_4dFAs | US0054 | 2024-09-18T12:11:30.666Z | 2024-09-20T12:19:15.180Z |
5122711 | 5122711 | 20240914073455_063dW | US0054 | 2024-09-18T12:11:29.101Z | 2024-09-20T12:19:14.223Z |
5122672 | 5122672 | 20240914073018_cJPFF | US0054 | 2024-09-18T12:11:27.737Z | 2024-09-20T12:19:13.549Z |
5122549 | 5122549 | 20240914070518_9M21K | US0054 | 2024-09-18T12:11:22.892Z | 2024-09-20T12:19:12.718Z |
5122547 | 5122547 | 20240914070456_yLSTO | US0054 | 2024-09-18T12:11:22.885Z | 2024-09-20T12:19:12.708Z |
5122496 | 5122496 | 20240914064954_O1GFr | US0054 | 2024-09-18T12:11:20.832Z | 2024-09-20T12:19:12.342Z |
5122459 | 5122459 | 20240914062817_wJff6 | US0054 | 2024-09-18T12:11:19.453Z | 2024-09-20T12:19:12.082Z |
5122362 | 5122362 | 20240914055457_GAKLM | US0054 | 2024-09-18T12:11:15.541Z | 2024-09-20T12:19:11.425Z |
5122354 | 5122354 | 20240914055135_dpShm | US0054 | 2024-09-18T12:11:15.494Z | 2024-09-20T12:19:11.384Z |
5122276 | 5122276 | 20240914051914_JF3Cn | US0054 | 2024-09-18T12:11:12.230Z | 2024-09-20T12:19:10.808Z |
5122240 | 5122240 | 20240914051028_wUMAF | US0054 | 2024-09-18T12:11:11.254Z | 2024-09-20T12:19:10.508Z |
5122092 | 5122092 | 20240914043219_m835F | US0054 | 2024-09-18T12:11:06.740Z | 2024-09-20T12:19:09.705Z |
5118589 | 5118589 | 20240915102257_WwAnv | US0054 | 2024-09-18T12:08:52.197Z | 2024-09-20T12:17:34.687Z |
5118494 | 5118494 | 20240915100033_PUPb7 | US0054 | 2024-09-18T12:08:48.410Z | 2024-09-20T12:17:32.467Z |
5118184 | 5118184 | 20240915084732_YDX5c | US0054 | 2024-09-18T12:08:28.831Z | 2024-09-20T12:17:24.077Z |
5117980 | 5117980 | 20240915080424_y82jG | US0054 | 2024-09-18T12:08:15.138Z | 2024-09-20T12:17:18.977Z |
5117955 | 5117955 | 20240915075603_EBWhc | US0054 | 2024-09-18T12:08:10.763Z | 2024-09-20T12:17:18.216Z |
5117949 | 5117949 | 20240915075415_NANKN | US0054 | 2024-09-18T12:08:09.827Z | 2024-09-20T12:17:18.099Z |
5117947 | 5117947 | 20240915075349_r65Wf | US0054 | 2024-09-18T12:08:09.576Z | 2024-09-20T12:17:17.883Z |
5117931 | 5117931 | 20240915074934_a6P08 | US0054 | 2024-09-18T12:08:07.681Z | 2024-09-20T12:17:16.599Z |
5117912 | 5117912 | 20240915074353_iJ32y | US0054 | 2024-09-18T12:08:06.749Z | 2024-09-20T12:17:16.163Z |
5117848 | 5117848 | 20240915072417_GbK8T | US0054 | 2024-09-18T12:08:03.261Z | 2024-09-20T12:17:15.015Z |
5117751 | 5117751 | 20240915064624_7Xt33 | US0054 | 2024-09-18T12:07:55.347Z | 2024-09-20T12:17:12.692Z |
5096206 | 5096206 | 20240912101630_ED9Q2 | US0054 | 2024-09-16T12:16:15.630Z | 2024-09-20T12:22:05.309Z |
5096102 | 5096102 | 20240912100128_CIgGy | US0054 | 2024-09-16T12:16:10.086Z | 2024-09-20T12:22:04.772Z |
5096095 | 5096095 | 20240912095755_zL0UH | US0054 | 2024-09-16T12:16:09.565Z | 2024-09-20T12:22:04.730Z |
5095930 | 5095930 | 20240912092909_D9E93 | US0054 | 2024-09-16T12:16:02.226Z | 2024-09-20T12:22:04.074Z |
5095598 | 5095598 | 20240912082303_66OFX | US0054 | 2024-09-16T12:15:50.276Z | 2024-09-20T12:22:01.828Z |
5095580 | 5095580 | 20240912080840_A8O20 | US0054 | 2024-09-16T12:15:49.463Z | 2024-09-20T12:22:01.730Z |
5095521 | 5095521 | 20240912075812_hsLbc | US0054 | 2024-09-16T12:15:45.627Z | 2024-09-20T12:22:01.170Z |
5095445 | 5095445 | 20240912073301_oBFZU | US0054 | 2024-09-16T12:15:40.337Z | 2024-09-20T12:22:00.223Z |
5095430 | 5095430 | 20240912073023_t832V | US0054 | 2024-09-16T12:15:39.874Z | 2024-09-20T12:22:00.135Z |
5095141 | 5095141 | 20240912060946_wK3Oc | US0054 | 2024-09-16T12:15:18.441Z | 2024-09-20T12:21:57.727Z |
5095045 | 5095045 | 20240912052552_jPlJw | US0054 | 2024-09-16T12:15:10.927Z | 2024-09-20T12:21:57.005Z |
5094957 | 5094957 | 20240912045245_JPigl | US0054 | 2024-09-16T12:15:03.819Z | 2024-09-20T12:21:56.468Z |
5094955 | 5094955 | 20240912045225_nK1ke | US0054 | 2024-09-16T12:15:03.357Z | 2024-09-20T12:21:56.465Z |
5094951 | 5094951 | 20240912045056_KE9fU | US0054 | 2024-09-16T12:15:03.014Z | 2024-09-20T12:21:56.444Z |
5094485 | 5094485 | 20240912040528_ekhxJ | US0054 | 2024-09-16T12:14:48.291Z | 2024-09-20T12:21:55.371Z |
5093458 | 5093458 | 20240912032204_VK023 | US0054 | 2024-09-16T12:14:17.426Z | 2024-09-20T12:21:53.457Z |
5091166 | 5091166 | 20240912020020_3k6VE | US0054 | 2024-09-16T12:12:52.561Z | 2024-09-20T12:21:46.830Z |
5080557 | 5080557 | 20240911041050_NR0Fa | US0054 | 2024-09-15T12:17:07.504Z | 2024-09-19T12:21:43.341Z |
5067907 | 5067907 | 20240910102858_32CGf | US0054 | 2024-09-14T12:19:04.209Z | 2024-09-18T12:15:25.065Z |
5067896 | 5067896 | 20240910102541_HGUeY | US0054 | 2024-09-14T12:19:03.362Z | 2024-09-18T12:15:25.038Z |
5067814 | 5067814 | 20240910101353_3fAov | US0054 | 2024-09-14T12:18:59.496Z | 2024-09-18T12:15:24.924Z |
5067630 | 5067630 | 20240910095445_BV8mO | US0054 | 2024-09-14T12:18:51.039Z | 2024-09-18T12:15:24.583Z |
5067626 | 5067626 | 20240910095413_UBSzB | US0054 | 2024-09-14T12:18:50.981Z | 2024-09-18T12:15:24.574Z |
5067560 | 5067560 | 20240910094350_qLSWm | US0054 | 2024-09-14T12:18:48.736Z | 2024-09-18T12:15:24.372Z |
5067472 | 5067472 | 20240910093525_kepxY | US0054 | 2024-09-14T12:18:44.805Z | 2024-09-18T12:15:24.178Z |
5067432 | 5067432 | 20240910093036_0BtpD | US0054 | 2024-09-14T12:18:43.573Z | 2024-09-18T12:15:24.093Z |
5067416 | 5067416 | 20240910092733_00Eh4 | US0054 | 2024-09-14T12:18:42.969Z | 2024-09-18T12:15:24.065Z |
5067408 | 5067408 | 20240910092515_l2uag | US0054 | 2024-09-14T12:18:42.817Z | 2024-09-18T12:15:24.031Z |
5067392 | 5067392 | 20240910092314_okH4O | US0054 | 2024-09-14T12:18:41.569Z | 2024-09-18T12:15:23.971Z |
5066982 | 5066982 | 20240910083822_GCmFm | US0054 | 2024-09-14T12:18:24.734Z | 2024-09-18T12:15:23.104Z |
5066199 | 5066199 | 20240910065048_RXw5G | US0054 | 2024-09-14T12:17:44.679Z | 2024-09-18T12:15:21.360Z |
5066161 | 5066161 | 20240910064510_sQnnG | US0054 | 2024-09-14T12:17:42.731Z | 2024-09-18T12:15:21.266Z |
5065768 | 5065768 | 20240910052950_EBO9H | US0054 | 2024-09-14T12:17:23.156Z | 2024-09-18T12:15:20.336Z |
5055014 | 5055014 | 20240908060238_UI3PD | US0054 | 2024-09-13T12:17:02.296Z | 2024-09-16T12:21:17.688Z |
5054994 | 5054994 | 20240908055319_NFdf9 | US0054 | 2024-09-13T12:17:01.581Z | 2024-09-16T12:21:17.610Z |
5054962 | 5054962 | 20240908054502_8KLPv | US0054 | 2024-09-13T12:17:00.396Z | 2024-09-16T12:21:17.471Z |
5054811 | 5054811 | 20240908040828_8iRLz | US0054 | 2024-09-13T12:16:56.321Z | 2024-09-16T12:21:16.917Z |
5054772 | 5054772 | 20240908035653_dvTih | US0054 | 2024-09-13T12:16:55.537Z | 2024-09-16T12:21:16.834Z |
5054730 | 5054730 | 20240908034543_4Nn3w | US0054 | 2024-09-13T12:16:54.299Z | 2024-09-16T12:21:16.736Z |
5054640 | 5054640 | 20240908032720_IS4sT | US0054 | 2024-09-13T12:16:50.688Z | 2024-09-16T12:21:16.370Z |
5054488 | 5054488 | 20240908025900_HUBvn | US0054 | 2024-09-13T12:16:44.299Z | 2024-09-16T12:21:15.701Z |
5054484 | 5054484 | 20240908025814_Rx7oS | US0054 | 2024-09-13T12:16:44.218Z | 2024-09-16T12:21:15.698Z |
5054297 | 5054297 | 20240908023707_ORpgW | US0054 | 2024-09-13T12:16:36.491Z | 2024-09-16T12:21:14.763Z |
5054269 | 5054269 | 20240908023357_0pAIU | US0054 | 2024-09-13T12:16:35.749Z | 2024-09-16T12:21:14.716Z |
5053856 | 5053856 | 20240908014102_unad3 | US0054 | 2024-09-13T12:16:19.959Z | 2024-09-16T12:21:12.935Z |
5053702 | 5053702 | 20240908011931_bvggm | US0054 | 2024-09-13T12:16:14.306Z | 2024-09-16T12:21:12.453Z |
5049145 | 5049145 | 20240909101417_642rD | US0054 | 2024-09-13T12:11:38.749Z | 2024-09-17T12:19:09.321Z |
5048914 | 5048914 | 20240909093100_K2w6D | US0054 | 2024-09-13T12:11:22.282Z | 2024-09-17T12:19:08.657Z |
5048832 | 5048832 | 20240909091925_xNiwo | US0054 | 2024-09-13T12:11:17.987Z | 2024-09-17T12:19:08.438Z |
5048784 | 5048784 | 20240909090724_ndmKG | US0054 | 2024-09-13T12:11:15.432Z | 2024-09-17T12:19:08.278Z |
5048708 | 5048708 | 20240909085713_bvSbE | US0054 | 2024-09-13T12:11:10.990Z | 2024-09-17T12:19:08.034Z |
5048548 | 5048548 | 20240909082852_Hf8dU | US0054 | 2024-09-13T12:10:49.171Z | 2024-09-17T12:19:07.450Z |
5048524 | 5048524 | 20240909082536_VYX8z | US0054 | 2024-09-13T12:10:46.819Z | 2024-09-17T12:19:07.350Z |
5048522 | 5048522 | 20240909082422_ig9Vf | US0054 | 2024-09-13T12:10:46.686Z | 2024-09-17T12:19:07.341Z |
5048520 | 5048520 | 20240909082356_ijUtU | US0054 | 2024-09-13T12:10:46.347Z | 2024-09-17T12:19:07.337Z |
5048241 | 5048241 | 20240909072609_UiNMN | US0054 | 2024-09-13T12:10:22.289Z | 2024-09-17T12:19:06.166Z |
5047803 | 5047803 | 20240909060219_81rqD | US0054 | 2024-09-13T12:09:43.355Z | 2024-09-17T12:19:04.389Z |
5047445 | 5047445 | 20240909040932_oX7Gf | US0054 | 2024-09-13T12:09:00.823Z | 2024-09-17T12:19:02.645Z |
5042230 | 5042230 | 20240906101225_ANxrc | US0054 | 2024-09-12T12:16:58.057Z | 2024-09-14T12:23:16.601Z |
5042192 | 5042192 | 20240906100924_YT3wi | US0054 | 2024-09-12T12:16:56.916Z | 2024-09-14T12:23:16.412Z |
5042186 | 5042186 | 20240906100706_339MI | US0054 | 2024-09-12T12:16:56.813Z | 2024-09-14T12:23:16.404Z |
5042114 | 5042114 | 20240906095609_Hf4vf | US0054 | 2024-09-12T12:16:55.586Z | 2024-09-14T12:23:16.021Z |
5041938 | 5041938 | 20240906092810_NWsHA | US0054 | 2024-09-12T12:16:52.683Z | 2024-09-14T12:23:15.399Z |
5041815 | 5041815 | 20240906090755_oN3uH | US0054 | 2024-09-12T12:16:49.154Z | 2024-09-14T12:23:14.726Z |
5041438 | 5041438 | 20240906081538_7Ze9W | US0054 | 2024-09-12T12:16:41.505Z | 2024-09-14T12:23:13.504Z |
5041254 | 5041254 | 20240906074731_18kZU | US0054 | 2024-09-12T12:16:37.240Z | 2024-09-14T12:23:12.359Z |
5041215 | 5041215 | 20240906073813_NiOBj | US0054 | 2024-09-12T12:16:35.841Z | 2024-09-14T12:23:12.146Z |
5035784 | 5035784 | 20240907102527_BrEhx | US0054 | 2024-09-12T12:12:28.640Z | 2024-09-15T12:21:41.229Z |
5035722 | 5035722 | 20240907101225_X2Z50 | US0054 | 2024-09-12T12:12:24.174Z | 2024-09-15T12:21:41.009Z |
5035652 | 5035652 | 20240907095957_8kfvt | US0054 | 2024-09-12T12:12:18.800Z | 2024-09-15T12:21:40.451Z |
5035613 | 5035613 | 20240907095515_7GCSx | US0054 | 2024-09-12T12:12:16.070Z | 2024-09-15T12:21:40.302Z |
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);