participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
211 rows where station_code = "US002Q" 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 |
---|---|---|---|---|---|
5123229 | 5123229 | 20240914092027_5c4Kl | US002Q | 2024-09-18T12:11:43.012Z | 2024-09-21T12:15:39.837Z |
5123170 | 5123170 | 20240914091250_Iv2wP | US002Q | 2024-09-18T12:11:41.619Z | 2024-09-21T12:15:39.220Z |
5123009 | 5123009 | 20240914083900_YM5d3 | US002Q | 2024-09-18T12:11:37.908Z | 2024-09-21T12:15:37.712Z |
5122915 | 5122915 | 20240914082301_CthrL | US002Q | 2024-09-18T12:11:34.032Z | 2024-09-21T12:15:36.606Z |
5122800 | 5122800 | 20240914080112_ajr3p | US002Q | 2024-09-18T12:11:31.573Z | 2024-09-21T12:15:35.370Z |
5122784 | 5122784 | 20240914075752_daW0I | US002Q | 2024-09-18T12:11:31.138Z | 2024-09-21T12:15:35.319Z |
5122765 | 5122765 | 20240914075459_4dFAs | US002Q | 2024-09-18T12:11:30.666Z | 2024-09-21T12:15:35.042Z |
5122710 | 5122710 | 20240914073455_063dW | US002Q | 2024-09-18T12:11:29.101Z | 2024-09-21T12:15:34.610Z |
5122671 | 5122671 | 20240914073018_cJPFF | US002Q | 2024-09-18T12:11:27.737Z | 2024-09-21T12:15:33.991Z |
5122548 | 5122548 | 20240914070518_9M21K | US002Q | 2024-09-18T12:11:22.892Z | 2024-09-21T12:15:32.835Z |
5122546 | 5122546 | 20240914070456_yLSTO | US002Q | 2024-09-18T12:11:22.885Z | 2024-09-21T12:15:32.829Z |
5122458 | 5122458 | 20240914062817_wJff6 | US002Q | 2024-09-18T12:11:19.453Z | 2024-09-21T12:15:30.187Z |
5122361 | 5122361 | 20240914055457_GAKLM | US002Q | 2024-09-18T12:11:15.541Z | 2024-09-21T12:15:29.116Z |
5122353 | 5122353 | 20240914055135_dpShm | US002Q | 2024-09-18T12:11:15.494Z | 2024-09-21T12:15:29.084Z |
5122275 | 5122275 | 20240914051914_JF3Cn | US002Q | 2024-09-18T12:11:12.230Z | 2024-09-21T12:15:28.461Z |
5122239 | 5122239 | 20240914051028_wUMAF | US002Q | 2024-09-18T12:11:11.254Z | 2024-09-21T12:15:27.875Z |
5122091 | 5122091 | 20240914043219_m835F | US002Q | 2024-09-18T12:11:06.740Z | 2024-09-21T12:15:26.759Z |
5118588 | 5118588 | 20240915102257_WwAnv | US002Q | 2024-09-18T12:08:52.197Z | 2024-09-21T12:14:24.791Z |
5118493 | 5118493 | 20240915100033_PUPb7 | US002Q | 2024-09-18T12:08:48.410Z | 2024-09-21T12:14:24.224Z |
5118183 | 5118183 | 20240915084732_YDX5c | US002Q | 2024-09-18T12:08:28.831Z | 2024-09-21T12:14:22.394Z |
5117979 | 5117979 | 20240915080424_y82jG | US002Q | 2024-09-18T12:08:15.138Z | 2024-09-21T12:14:20.901Z |
5117954 | 5117954 | 20240915075603_EBWhc | US002Q | 2024-09-18T12:08:10.763Z | 2024-09-21T12:14:20.409Z |
5117948 | 5117948 | 20240915075415_NANKN | US002Q | 2024-09-18T12:08:09.827Z | 2024-09-21T12:14:20.334Z |
5117946 | 5117946 | 20240915075349_r65Wf | US002Q | 2024-09-18T12:08:09.576Z | 2024-09-21T12:14:20.281Z |
5117930 | 5117930 | 20240915074934_a6P08 | US002Q | 2024-09-18T12:08:07.681Z | 2024-09-21T12:14:20.072Z |
5117911 | 5117911 | 20240915074353_iJ32y | US002Q | 2024-09-18T12:08:06.749Z | 2024-09-21T12:14:19.911Z |
5117847 | 5117847 | 20240915072417_GbK8T | US002Q | 2024-09-18T12:08:03.261Z | 2024-09-21T12:14:19.387Z |
5117750 | 5117750 | 20240915064624_7Xt33 | US002Q | 2024-09-18T12:07:55.321Z | 2024-09-21T12:14:18.432Z |
5096205 | 5096205 | 20240912101630_ED9Q2 | US002Q | 2024-09-16T12:16:15.630Z | 2024-09-20T12:22:05.309Z |
5096101 | 5096101 | 20240912100128_CIgGy | US002Q | 2024-09-16T12:16:10.086Z | 2024-09-20T12:22:04.772Z |
5096094 | 5096094 | 20240912095755_zL0UH | US002Q | 2024-09-16T12:16:09.565Z | 2024-09-20T12:22:04.730Z |
5095929 | 5095929 | 20240912092909_D9E93 | US002Q | 2024-09-16T12:16:02.226Z | 2024-09-20T12:22:04.074Z |
5095597 | 5095597 | 20240912082303_66OFX | US002Q | 2024-09-16T12:15:50.276Z | 2024-09-20T12:22:01.828Z |
5095579 | 5095579 | 20240912080840_A8O20 | US002Q | 2024-09-16T12:15:49.463Z | 2024-09-20T12:22:01.730Z |
5095520 | 5095520 | 20240912075812_hsLbc | US002Q | 2024-09-16T12:15:45.627Z | 2024-09-20T12:22:01.170Z |
5095444 | 5095444 | 20240912073301_oBFZU | US002Q | 2024-09-16T12:15:40.336Z | 2024-09-20T12:22:00.223Z |
5095429 | 5095429 | 20240912073023_t832V | US002Q | 2024-09-16T12:15:39.874Z | 2024-09-20T12:22:00.135Z |
5095140 | 5095140 | 20240912060946_wK3Oc | US002Q | 2024-09-16T12:15:18.441Z | 2024-09-20T12:21:57.727Z |
5095044 | 5095044 | 20240912052552_jPlJw | US002Q | 2024-09-16T12:15:10.927Z | 2024-09-20T12:21:57.005Z |
5094956 | 5094956 | 20240912045245_JPigl | US002Q | 2024-09-16T12:15:03.819Z | 2024-09-20T12:21:56.468Z |
5094954 | 5094954 | 20240912045225_nK1ke | US002Q | 2024-09-16T12:15:03.357Z | 2024-09-20T12:21:56.465Z |
5094950 | 5094950 | 20240912045056_KE9fU | US002Q | 2024-09-16T12:15:03.014Z | 2024-09-20T12:21:56.444Z |
5094484 | 5094484 | 20240912040528_ekhxJ | US002Q | 2024-09-16T12:14:48.291Z | 2024-09-20T12:21:55.371Z |
5093457 | 5093457 | 20240912032204_VK023 | US002Q | 2024-09-16T12:14:17.426Z | 2024-09-20T12:21:53.457Z |
5091165 | 5091165 | 20240912020020_3k6VE | US002Q | 2024-09-16T12:12:52.502Z | 2024-09-20T12:21:46.830Z |
5080556 | 5080556 | 20240911041050_NR0Fa | US002Q | 2024-09-15T12:17:07.504Z | 2024-09-19T12:21:43.341Z |
5067906 | 5067906 | 20240910102858_32CGf | US002Q | 2024-09-14T12:19:04.209Z | 2024-09-18T12:15:25.065Z |
5067895 | 5067895 | 20240910102541_HGUeY | US002Q | 2024-09-14T12:19:03.362Z | 2024-09-18T12:15:25.038Z |
5067813 | 5067813 | 20240910101353_3fAov | US002Q | 2024-09-14T12:18:59.496Z | 2024-09-18T12:15:24.923Z |
5067629 | 5067629 | 20240910095445_BV8mO | US002Q | 2024-09-14T12:18:51.039Z | 2024-09-18T12:15:24.583Z |
5067625 | 5067625 | 20240910095413_UBSzB | US002Q | 2024-09-14T12:18:50.981Z | 2024-09-18T12:15:24.574Z |
5067559 | 5067559 | 20240910094350_qLSWm | US002Q | 2024-09-14T12:18:48.736Z | 2024-09-18T12:15:24.372Z |
5067471 | 5067471 | 20240910093525_kepxY | US002Q | 2024-09-14T12:18:44.805Z | 2024-09-18T12:15:24.178Z |
5067431 | 5067431 | 20240910093036_0BtpD | US002Q | 2024-09-14T12:18:43.573Z | 2024-09-18T12:15:24.093Z |
5067415 | 5067415 | 20240910092733_00Eh4 | US002Q | 2024-09-14T12:18:42.969Z | 2024-09-18T12:15:24.065Z |
5067407 | 5067407 | 20240910092515_l2uag | US002Q | 2024-09-14T12:18:42.816Z | 2024-09-18T12:15:24.031Z |
5067391 | 5067391 | 20240910092314_okH4O | US002Q | 2024-09-14T12:18:41.569Z | 2024-09-18T12:15:23.971Z |
5066198 | 5066198 | 20240910065048_RXw5G | US002Q | 2024-09-14T12:17:44.678Z | 2024-09-18T12:15:21.360Z |
5066160 | 5066160 | 20240910064510_sQnnG | US002Q | 2024-09-14T12:17:42.731Z | 2024-09-18T12:15:21.266Z |
5065767 | 5065767 | 20240910052950_EBO9H | US002Q | 2024-09-14T12:17:23.156Z | 2024-09-18T12:15:20.336Z |
5055242 | 5055242 | 20240908073225_QKKxV | US002Q | 2024-09-13T12:17:08.274Z | 2024-09-16T12:21:18.518Z |
5055013 | 5055013 | 20240908060238_UI3PD | US002Q | 2024-09-13T12:17:02.296Z | 2024-09-16T12:21:17.688Z |
5054993 | 5054993 | 20240908055319_NFdf9 | US002Q | 2024-09-13T12:17:01.581Z | 2024-09-16T12:21:17.610Z |
5054961 | 5054961 | 20240908054502_8KLPv | US002Q | 2024-09-13T12:17:00.396Z | 2024-09-16T12:21:17.471Z |
5054810 | 5054810 | 20240908040828_8iRLz | US002Q | 2024-09-13T12:16:56.321Z | 2024-09-16T12:21:16.917Z |
5054771 | 5054771 | 20240908035653_dvTih | US002Q | 2024-09-13T12:16:55.537Z | 2024-09-16T12:21:16.834Z |
5054729 | 5054729 | 20240908034543_4Nn3w | US002Q | 2024-09-13T12:16:54.299Z | 2024-09-16T12:21:16.736Z |
5054639 | 5054639 | 20240908032720_IS4sT | US002Q | 2024-09-13T12:16:50.688Z | 2024-09-16T12:21:16.370Z |
5054487 | 5054487 | 20240908025900_HUBvn | US002Q | 2024-09-13T12:16:44.299Z | 2024-09-16T12:21:15.701Z |
5054483 | 5054483 | 20240908025814_Rx7oS | US002Q | 2024-09-13T12:16:44.218Z | 2024-09-16T12:21:15.698Z |
5054296 | 5054296 | 20240908023707_ORpgW | US002Q | 2024-09-13T12:16:36.491Z | 2024-09-16T12:21:14.763Z |
5054268 | 5054268 | 20240908023357_0pAIU | US002Q | 2024-09-13T12:16:35.749Z | 2024-09-16T12:21:14.716Z |
5053855 | 5053855 | 20240908014102_unad3 | US002Q | 2024-09-13T12:16:19.959Z | 2024-09-16T12:21:12.935Z |
5053701 | 5053701 | 20240908011931_bvggm | US002Q | 2024-09-13T12:16:14.305Z | 2024-09-16T12:21:12.453Z |
5049144 | 5049144 | 20240909101417_642rD | US002Q | 2024-09-13T12:11:38.749Z | 2024-09-17T12:19:09.321Z |
5048913 | 5048913 | 20240909093100_K2w6D | US002Q | 2024-09-13T12:11:22.282Z | 2024-09-17T12:19:08.657Z |
5048831 | 5048831 | 20240909091925_xNiwo | US002Q | 2024-09-13T12:11:17.987Z | 2024-09-17T12:19:08.438Z |
5048783 | 5048783 | 20240909090724_ndmKG | US002Q | 2024-09-13T12:11:15.432Z | 2024-09-17T12:19:08.278Z |
5048707 | 5048707 | 20240909085713_bvSbE | US002Q | 2024-09-13T12:11:10.989Z | 2024-09-17T12:19:08.034Z |
5048547 | 5048547 | 20240909082852_Hf8dU | US002Q | 2024-09-13T12:10:49.171Z | 2024-09-17T12:19:07.450Z |
5048523 | 5048523 | 20240909082536_VYX8z | US002Q | 2024-09-13T12:10:46.819Z | 2024-09-17T12:19:07.350Z |
5048521 | 5048521 | 20240909082422_ig9Vf | US002Q | 2024-09-13T12:10:46.685Z | 2024-09-17T12:19:07.341Z |
5048519 | 5048519 | 20240909082356_ijUtU | US002Q | 2024-09-13T12:10:46.347Z | 2024-09-17T12:19:07.337Z |
5048240 | 5048240 | 20240909072609_UiNMN | US002Q | 2024-09-13T12:10:22.288Z | 2024-09-17T12:19:06.166Z |
5047802 | 5047802 | 20240909060219_81rqD | US002Q | 2024-09-13T12:09:43.355Z | 2024-09-17T12:19:04.389Z |
5047444 | 5047444 | 20240909040932_oX7Gf | US002Q | 2024-09-13T12:09:00.823Z | 2024-09-17T12:19:02.645Z |
5042229 | 5042229 | 20240906101225_ANxrc | US002Q | 2024-09-12T12:16:58.057Z | 2024-09-14T12:23:16.600Z |
5042191 | 5042191 | 20240906100924_YT3wi | US002Q | 2024-09-12T12:16:56.916Z | 2024-09-14T12:23:16.412Z |
5042185 | 5042185 | 20240906100706_339MI | US002Q | 2024-09-12T12:16:56.813Z | 2024-09-14T12:23:16.404Z |
5042113 | 5042113 | 20240906095609_Hf4vf | US002Q | 2024-09-12T12:16:55.586Z | 2024-09-14T12:23:16.021Z |
5041937 | 5041937 | 20240906092810_NWsHA | US002Q | 2024-09-12T12:16:52.683Z | 2024-09-14T12:23:15.399Z |
5041814 | 5041814 | 20240906090755_oN3uH | US002Q | 2024-09-12T12:16:49.154Z | 2024-09-14T12:23:14.726Z |
5041437 | 5041437 | 20240906081538_7Ze9W | US002Q | 2024-09-12T12:16:41.505Z | 2024-09-14T12:23:13.504Z |
5041253 | 5041253 | 20240906074731_18kZU | US002Q | 2024-09-12T12:16:37.240Z | 2024-09-14T12:23:12.359Z |
5041214 | 5041214 | 20240906073813_NiOBj | US002Q | 2024-09-12T12:16:35.841Z | 2024-09-14T12:23:12.146Z |
5035783 | 5035783 | 20240907102527_BrEhx | US002Q | 2024-09-12T12:12:28.640Z | 2024-09-15T12:21:41.229Z |
5035721 | 5035721 | 20240907101225_X2Z50 | US002Q | 2024-09-12T12:12:24.174Z | 2024-09-15T12:21:41.009Z |
5035651 | 5035651 | 20240907095957_8kfvt | US002Q | 2024-09-12T12:12:18.800Z | 2024-09-15T12:21:40.451Z |
5035612 | 5035612 | 20240907095515_7GCSx | US002Q | 2024-09-12T12:12:16.070Z | 2024-09-15T12:21:40.302Z |
5035605 | 5035605 | 20240907095348_lQuqD | US002Q | 2024-09-12T12:12:15.553Z | 2024-09-15T12:21:40.244Z |
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);