participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,358 rows where station_code = "HR0027" 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 |
---|---|---|---|---|---|
5071795 | 5071795 | 20240911182258_mpC1r | HR0027 | 2024-09-15T12:03:36.946Z | 2024-09-19T12:21:02.752Z |
5000842 | 5000842 | 20240902025440_Fvgvr | HR0027 | 2024-09-08T12:15:54.970Z | 2024-09-10T12:19:29.950Z |
4990917 | 4990917 | 20240901013355_iYt5B | HR0027 | 2024-09-07T12:11:18.377Z | 2024-09-09T12:26:55.081Z |
4990847 | 4990847 | 20240901012039_n6Bq3 | HR0027 | 2024-09-07T12:11:13.038Z | 2024-09-09T12:26:48.954Z |
4990666 | 4990666 | 20240901005130_BJBDN | HR0027 | 2024-09-07T12:10:53.489Z | 2024-09-09T12:26:27.138Z |
4990637 | 4990637 | 20240901004814_R4xYZ | HR0027 | 2024-09-07T12:10:51.957Z | 2024-09-09T12:26:25.805Z |
4990618 | 4990618 | 20240901004617_P8Acc | HR0027 | 2024-09-07T12:10:50.650Z | 2024-09-09T12:26:25.291Z |
4990616 | 4990616 | 20240901004535_aE807 | HR0027 | 2024-09-07T12:10:50.505Z | 2024-09-09T12:26:25.209Z |
4990580 | 4990580 | 20240901004155_3aMe3 | HR0027 | 2024-09-07T12:10:48.195Z | 2024-09-09T12:26:24.114Z |
4990551 | 4990551 | 20240901003300_DjYUk | HR0027 | 2024-09-07T12:10:45.961Z | 2024-09-09T12:26:23.206Z |
4990489 | 4990489 | 20240901002213_u4VEd | HR0027 | 2024-09-07T12:10:41.343Z | 2024-09-09T12:26:21.797Z |
4990456 | 4990456 | 20240901001656_pedF4 | HR0027 | 2024-09-07T12:10:39.041Z | 2024-09-09T12:26:20.102Z |
4990453 | 4990453 | 20240901001649_s9M3r | HR0027 | 2024-09-07T12:10:38.626Z | 2024-09-09T12:26:20.036Z |
4990225 | 4990225 | 20240831234359_VtlR3 | HR0027 | 2024-09-07T12:10:15.086Z | 2024-09-09T12:26:14.038Z |
4990197 | 4990197 | 20240831234104_Y1lBG | HR0027 | 2024-09-07T12:10:09.965Z | 2024-09-09T12:26:13.125Z |
4989189 | 4989189 | 20240901225225_gCS0t | HR0027 | 2024-09-07T12:08:38.321Z | 2024-09-10T12:19:17.012Z |
4988720 | 4988720 | 20240901212437_Oguw2 | HR0027 | 2024-09-07T12:07:51.515Z | 2024-09-10T12:19:15.227Z |
4988134 | 4988134 | 20240901200126_xkijC | HR0027 | 2024-09-07T12:06:55.813Z | 2024-09-10T12:19:12.832Z |
4977626 | 4977626 | 20240811234224_utWfv | HR0027 | 2024-09-06T12:12:20.942Z | 2024-09-06T12:12:20.942Z |
4977624 | 4977624 | 20240811234220_Cg6De | HR0027 | 2024-09-06T12:12:20.865Z | 2024-09-06T12:12:20.865Z |
4977601 | 4977601 | 20240811234158_COk2q | HR0027 | 2024-09-06T12:12:20.524Z | 2024-09-06T12:12:20.524Z |
4977570 | 4977570 | 20240811234128_G9Td7 | HR0027 | 2024-09-06T12:12:19.939Z | 2024-09-06T12:12:19.939Z |
4976900 | 4976900 | 20240811233445_2aDu5 | HR0027 | 2024-09-06T12:11:56.850Z | 2024-09-06T12:11:56.850Z |
4976551 | 4976551 | 20240811233139_2sgOY | HR0027 | 2024-09-06T12:11:36.777Z | 2024-09-06T12:11:36.777Z |
4976490 | 4976490 | 20240811233041_Kn2qW | HR0027 | 2024-09-06T12:11:34.031Z | 2024-09-06T12:11:34.031Z |
4976245 | 4976245 | 20240811232722_HLPn1 | HR0027 | 2024-09-06T12:11:19.941Z | 2024-09-06T12:11:19.941Z |
4976169 | 4976169 | 20240811232626_jdsQQ | HR0027 | 2024-09-06T12:11:15.089Z | 2024-09-06T12:11:15.089Z |
4975931 | 4975931 | 20240811232326_HK30W | HR0027 | 2024-09-06T12:10:56.565Z | 2024-09-06T12:10:56.565Z |
4975813 | 4975813 | 20240811232211_bzCxy | HR0027 | 2024-09-06T12:10:49.919Z | 2024-09-06T12:10:49.919Z |
4975780 | 4975780 | 20240811232151_d1zec | HR0027 | 2024-09-06T12:10:49.344Z | 2024-09-06T12:10:49.344Z |
4975329 | 4975329 | 20240811231716_EgY3g | HR0027 | 2024-09-05T12:11:45.331Z | 2024-09-06T12:10:39.936Z |
4974708 | 4974708 | 20240811231024_5wiV2 | HR0027 | 2024-09-05T12:11:30.565Z | 2024-09-06T12:10:31.454Z |
4974595 | 4974595 | 20240811230849_5Qmn3 | HR0027 | 2024-09-05T12:11:27.232Z | 2024-09-06T12:10:28.734Z |
4974349 | 4974349 | 20240811230608_Xy23p | HR0027 | 2024-09-05T12:11:23.510Z | 2024-09-06T12:10:25.831Z |
4974278 | 4974278 | 20240811230537_m0uHe | HR0027 | 2024-09-05T12:11:22.812Z | 2024-09-06T12:10:25.182Z |
4973938 | 4973938 | 20240811230148_WR1sh | HR0027 | 2024-09-05T12:11:14.516Z | 2024-09-06T12:10:11.715Z |
4971912 | 4971912 | 20240811224115_2SIk2 | HR0027 | 2024-09-05T12:10:09.383Z | 2024-09-06T12:09:01.314Z |
4971766 | 4971766 | 20240811223932_Ya38Y | HR0027 | 2024-09-05T12:09:58.719Z | 2024-09-06T12:08:57.828Z |
4971455 | 4971455 | 20240811223522_cIrNu | HR0027 | 2024-09-05T12:09:44.356Z | 2024-09-06T12:08:53.341Z |
4970950 | 4970950 | 20240811222953_tnl9o | HR0027 | 2024-09-05T12:09:34.734Z | 2024-09-06T12:08:46.761Z |
4970648 | 4970648 | 20240811222745_Mnq5J | HR0027 | 2024-09-05T12:09:30.282Z | 2024-09-06T12:08:43.477Z |
4970072 | 4970072 | 20240811222040_qm3A0 | HR0027 | 2024-09-05T12:09:18.300Z | 2024-09-06T12:08:21.530Z |
4969955 | 4969955 | 20240811221907_hhGeO | HR0027 | 2024-09-05T12:09:11.937Z | 2024-09-06T12:08:15.142Z |
4969532 | 4969532 | 20240811221256_tRdfL | HR0027 | 2024-09-05T12:08:47.846Z | 2024-09-06T12:07:54.770Z |
4969468 | 4969468 | 20240811221214_jizDB | HR0027 | 2024-09-05T12:08:46.066Z | 2024-09-06T12:07:52.682Z |
4969433 | 4969433 | 20240811221202_ttbfu | HR0027 | 2024-09-05T12:08:45.551Z | 2024-09-06T12:07:52.255Z |
4969345 | 4969345 | 20240811221012_dA2Nz | HR0027 | 2024-09-05T12:08:42.588Z | 2024-09-06T12:07:50.163Z |
4969332 | 4969332 | 20240811221001_f0yqs | HR0027 | 2024-09-05T12:08:40.439Z | 2024-09-06T12:07:49.739Z |
4969164 | 4969164 | 20240811220729_Uflxe | HR0027 | 2024-09-05T12:08:36.298Z | 2024-09-06T12:07:43.398Z |
4969145 | 4969145 | 20240811220651_M2irY | HR0027 | 2024-09-05T12:08:35.652Z | 2024-09-06T12:07:42.845Z |
4967492 | 4967492 | 20240811214501_3ZFpi | HR0027 | 2024-09-05T12:07:40.255Z | 2024-09-06T12:07:00.870Z |
4967436 | 4967436 | 20240811214436_fVw6E | HR0027 | 2024-09-05T12:07:39.411Z | 2024-09-06T12:07:00.116Z |
4967108 | 4967108 | 20240811213857_BL6TF | HR0027 | 2024-09-05T12:07:30.581Z | 2024-09-06T12:06:53.381Z |
4966943 | 4966943 | 20240811213617_QqSJi | HR0027 | 2024-09-05T12:07:24.085Z | 2024-09-06T12:06:50.215Z |
4966263 | 4966263 | 20240811212617_S7LHy | HR0027 | 2024-09-04T12:07:22.057Z | 2024-09-06T12:06:19.760Z |
4966213 | 4966213 | 20240811212541_QeIaP | HR0027 | 2024-09-04T12:07:20.901Z | 2024-09-06T12:06:17.561Z |
4966176 | 4966176 | 20240811212446_n3A8y | HR0027 | 2024-09-04T12:07:19.821Z | 2024-09-06T12:06:16.029Z |
4965752 | 4965752 | 20240811211856_J4BV4 | HR0027 | 2024-09-04T12:07:07.098Z | 2024-09-06T12:06:03.788Z |
4965605 | 4965605 | 20240811211726_KPpWc | HR0027 | 2024-09-04T12:07:02.524Z | 2024-09-06T12:06:00.756Z |
4965363 | 4965363 | 20240811211342_RVGdH | HR0027 | 2024-09-04T12:06:55.605Z | 2024-09-06T12:05:54.579Z |
4965199 | 4965199 | 20240811211028_xi4f7 | HR0027 | 2024-09-04T12:06:51.807Z | 2024-09-06T12:05:50.999Z |
4964490 | 4964490 | 20240811205603_sl6h1 | HR0027 | 2024-09-04T12:06:24.111Z | 2024-09-06T12:05:23.072Z |
4964257 | 4964257 | 20240811204943_RrWbh | HR0027 | 2024-09-04T12:06:15.730Z | 2024-09-06T12:05:15.752Z |
4964049 | 4964049 | 20240811204421_h4fb7 | HR0027 | 2024-09-04T12:06:06.416Z | 2024-09-06T12:05:09.638Z |
4963809 | 4963809 | 20240811203634_N7hkO | HR0027 | 2024-09-04T12:05:56.664Z | 2024-09-06T12:04:56.847Z |
4963709 | 4963709 | 20240811203008_Et5JP | HR0027 | 2024-09-04T12:05:51.872Z | 2024-09-06T12:04:50.574Z |
4963404 | 4963404 | 20240811200817_6lOP6 | HR0027 | 2024-09-04T12:05:32.301Z | 2024-09-06T12:04:37.348Z |
4963205 | 4963205 | 20240811194933_uXng3 | HR0027 | 2024-09-04T12:05:19.374Z | 2024-09-06T12:04:22.421Z |
4963194 | 4963194 | 20240811194914_RgnlG | HR0027 | 2024-09-04T12:05:18.851Z | 2024-09-06T12:04:22.044Z |
4962874 | 4962874 | 20240811192950_kPlxL | HR0027 | 2024-09-04T12:04:57.142Z | 2024-09-06T12:04:09.808Z |
4952871 | 4952871 | 20240811022810_XaI3j | HR0027 | 2024-09-03T12:17:07.948Z | 2024-09-06T12:28:11.234Z |
4952463 | 4952463 | 20240811022254_Xu0Qq | HR0027 | 2024-09-03T12:16:58.857Z | 2024-09-06T12:28:02.449Z |
4952270 | 4952270 | 20240811021837_KNPoM | HR0027 | 2024-09-03T12:16:53.710Z | 2024-09-06T12:27:54.281Z |
4950545 | 4950545 | 20240811020827_cS3pZ | HR0027 | 2024-09-02T12:16:30.583Z | 2024-09-06T12:27:45.444Z |
4950230 | 4950230 | 20240811020307_j4oi6 | HR0027 | 2024-09-02T12:16:16.492Z | 2024-09-06T12:27:42.331Z |
4950207 | 4950207 | 20240811020256_GfzA9 | HR0027 | 2024-09-02T12:16:15.920Z | 2024-09-06T12:27:42.258Z |
4950195 | 4950195 | 20240811020235_6VwQD | HR0027 | 2024-09-02T12:16:14.163Z | 2024-09-06T12:27:42.037Z |
4950137 | 4950137 | 20240811020108_wAOLq | HR0027 | 2024-09-02T12:16:08.995Z | 2024-09-06T12:27:41.211Z |
4950007 | 4950007 | 20240811015935_1LjtR | HR0027 | 2024-09-02T12:16:02.053Z | 2024-09-06T12:27:39.889Z |
4949954 | 4949954 | 20240811015816_DB9qm | HR0027 | 2024-09-02T12:16:00.810Z | 2024-09-06T12:27:39.231Z |
4949101 | 4949101 | 20240811014514_YeHWu | HR0027 | 2024-09-02T12:15:34.967Z | 2024-09-06T12:27:29.729Z |
4949070 | 4949070 | 20240811014448_XwEy8 | HR0027 | 2024-09-02T12:15:31.831Z | 2024-09-06T12:27:29.291Z |
4949010 | 4949010 | 20240811014353_t5PZk | HR0027 | 2024-09-02T12:15:28.240Z | 2024-09-06T12:27:28.787Z |
4948825 | 4948825 | 20240811014119_G723F | HR0027 | 2024-09-02T12:15:20.636Z | 2024-09-06T12:27:27.577Z |
4948687 | 4948687 | 20240811013840_FgAje | HR0027 | 2024-09-02T12:15:10.881Z | 2024-09-06T12:27:23.516Z |
4948354 | 4948354 | 20240811013241_tPuk9 | HR0027 | 2024-09-02T12:15:00.395Z | 2024-09-06T12:27:15.354Z |
4948080 | 4948080 | 20240811012845_idyOG | HR0027 | 2024-09-02T12:14:54.759Z | 2024-09-06T12:27:07.849Z |
4947675 | 4947675 | 20240811012240_EpJg6 | HR0027 | 2024-09-02T12:14:44.459Z | 2024-09-06T12:26:57.719Z |
4947582 | 4947582 | 20240811012118_F2KBD | HR0027 | 2024-09-02T12:14:39.053Z | 2024-09-06T12:26:55.422Z |
4947456 | 4947456 | 20240811011904_zwBH1 | HR0027 | 2024-09-02T12:14:33.364Z | 2024-09-06T12:26:53.356Z |
4947057 | 4947057 | 20240811011226_mlBPP | HR0027 | 2024-09-02T12:14:15.262Z | 2024-09-06T12:26:43.930Z |
4944737 | 4944737 | 20240811003510_KbbhS | HR0027 | 2024-09-02T12:12:44.758Z | 2024-09-06T12:25:35.641Z |
4943261 | 4943261 | 20240811000852_I2lPO | HR0027 | 2024-09-02T12:11:45.544Z | 2024-09-06T12:24:42.173Z |
4942890 | 4942890 | 20240810235916_cueFD | HR0027 | 2024-09-02T12:11:36.256Z | 2024-09-06T12:24:32.740Z |
4942673 | 4942673 | 20240810235534_i6USZ | HR0027 | 2024-09-02T12:11:27.173Z | 2024-09-06T12:24:26.556Z |
4942662 | 4942662 | 20240810235527_7vq5h | HR0027 | 2024-09-02T12:11:26.140Z | 2024-09-06T12:24:25.915Z |
4942273 | 4942273 | 20240810234855_2orTm | HR0027 | 2024-09-02T12:11:07.168Z | 2024-09-06T12:24:11.188Z |
4941968 | 4941968 | 20240810234254_LYhd3 | HR0027 | 2024-09-02T12:10:58.535Z | 2024-09-06T12:24:01.285Z |
4941898 | 4941898 | 20240810234146_GNXRD | HR0027 | 2024-09-02T12:10:55.320Z | 2024-09-06T12:23:57.446Z |
4941881 | 4941881 | 20240810234129_7Kkso | HR0027 | 2024-09-02T12:10:54.327Z | 2024-09-06T12:23:56.776Z |
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);