participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,942 rows where station_code = "HR001P" 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 |
---|---|---|---|---|---|
5132316 | 5132316 | 20240916003210_E0KRY | HR001P | 2024-09-19T12:16:05.480Z | 2024-09-20T12:13:06.739Z |
5078464 | 5078464 | 20240911015926_Qlwzi | HR001P | 2024-09-15T12:15:39.565Z | 2024-09-19T12:21:40.426Z |
5078376 | 5078376 | 20240911015141_wJBV4 | HR001P | 2024-09-15T12:15:36.896Z | 2024-09-19T12:21:40.326Z |
5076320 | 5076320 | 20240910232031_fPWYa | HR001P | 2024-09-15T12:13:27.678Z | 2024-09-19T12:21:36.710Z |
5072029 | 5072029 | 20240911192426_fcp7T | HR001P | 2024-09-15T12:04:27.455Z | 2024-09-20T12:21:24.818Z |
5062924 | 5062924 | 20240909190715_LMuc9 | HR001P | 2024-09-14T12:13:03.819Z | 2024-09-18T12:15:12.550Z |
5033454 | 5033454 | 20240907030025_mLsOL | HR001P | 2024-09-12T12:09:32.849Z | 2024-09-15T12:21:30.166Z |
5032358 | 5032358 | 20240907005205_I3il2 | HR001P | 2024-09-12T12:07:10.326Z | 2024-09-15T12:21:26.255Z |
5032348 | 5032348 | 20240907005033_xmNr2 | HR001P | 2024-09-12T12:07:09.510Z | 2024-09-15T12:21:26.214Z |
5031601 | 5031601 | 20240906224057_gQ2Z5 | HR001P | 2024-09-12T12:05:15.481Z | 2024-09-15T12:21:23.408Z |
5031425 | 5031425 | 20240906215308_hHvN6 | HR001P | 2024-09-12T12:04:46.191Z | 2024-09-15T12:21:22.341Z |
5026341 | 5026341 | 20240905030647_rho0N | HR001P | 2024-09-11T12:12:18.115Z | 2024-09-13T12:19:57.699Z |
5026114 | 5026114 | 20240905021926_Yu4h2 | HR001P | 2024-09-11T12:11:56.258Z | 2024-09-13T12:19:56.882Z |
5020797 | 5020797 | 20240905030647_lM9xP | HR001P | 2024-09-10T12:15:01.803Z | 2024-09-10T12:16:55.243Z |
5020556 | 5020556 | 20240905021926_iERco | HR001P | 2024-09-10T12:14:42.170Z | 2024-09-10T12:16:55.179Z |
5019807 | 5019807 | 20240904235513_9Bg8B | HR001P | 2024-09-10T12:13:33.764Z | 2024-09-13T12:19:53.900Z |
5019722 | 5019722 | 20240904234253_yjOq0 | HR001P | 2024-09-10T12:13:19.321Z | 2024-09-13T12:19:53.603Z |
5010305 | 5010305 | 20240904025116_iPKH7 | HR001P | 2024-09-09T12:08:33.923Z | 2024-09-12T12:19:26.806Z |
4996910 | 4996910 | 20240902213716_45iHH | HR001P | 2024-09-08T12:05:25.650Z | 2024-09-11T12:20:59.044Z |
4991801 | 4991801 | 20240901031852_Bw2Nc | HR001P | 2024-09-07T12:12:29.952Z | 2024-09-09T12:27:21.813Z |
4990150 | 4990150 | 20240831233509_RC337 | HR001P | 2024-09-07T12:10:07.490Z | 2024-09-09T12:26:12.024Z |
4989893 | 4989893 | 20240831225356_YSTQu | HR001P | 2024-09-07T12:09:46.146Z | 2024-09-09T12:26:05.360Z |
4989398 | 4989398 | 20240901233131_Pa3bQ | HR001P | 2024-09-07T12:08:54.878Z | 2024-09-10T12:19:17.603Z |
4988962 | 4988962 | 20240901221022_z2WBR | HR001P | 2024-09-07T12:08:16.122Z | 2024-09-10T12:19:15.995Z |
4987971 | 4987971 | 20240901192930_OFt2I | HR001P | 2024-09-07T12:06:37.199Z | 2024-09-10T12:19:12.127Z |
4982722 | 4982722 | 20240812003632_e5448 | HR001P | 2024-09-06T12:15:00.068Z | 2024-09-06T12:15:00.068Z |
4975136 | 4975136 | 20240811231505_kvo5a | HR001P | 2024-09-05T12:11:40.527Z | 2024-09-06T12:10:37.723Z |
4965284 | 4965284 | 20240811211141_eBrbx | HR001P | 2024-09-04T12:06:53.395Z | 2024-09-06T12:05:52.686Z |
4943423 | 4943423 | 20240811001126_RwBGu | HR001P | 2024-09-02T12:11:50.323Z | 2024-09-06T12:24:48.989Z |
4922069 | 4922069 | 20240810010830_6O26Y | HR001P | 2024-08-30T12:14:32.472Z | 2024-09-02T12:27:21.973Z |
4915879 | 4915879 | 20240809225945_g6ByV | HR001P | 2024-08-30T12:10:20.191Z | 2024-09-02T12:24:06.334Z |
4889657 | 4889657 | 20240808213156_xOFHS | HR001P | 2024-08-28T12:06:33.709Z | 2024-08-30T12:19:31.054Z |
4889573 | 4889573 | 20240808211839_8zR82 | HR001P | 2024-08-28T12:06:23.857Z | 2024-08-30T12:19:27.834Z |
4889465 | 4889465 | 20240808210430_eTpwc | HR001P | 2024-08-28T12:06:14.018Z | 2024-08-30T12:19:23.058Z |
4877438 | 4877438 | 20240807000403_7akDg | HR001P | 2024-08-19T12:13:32.569Z | 2024-08-27T12:13:11.937Z |
4873072 | 4873072 | 20240806220956_HFfoR | HR001P | 2024-08-19T12:10:34.505Z | 2024-08-27T12:10:56.172Z |
4871749 | 4871749 | 20240806210818_ckxkf | HR001P | 2024-08-19T12:09:23.528Z | 2024-08-27T12:10:01.193Z |
4857462 | 4857462 | 20240806022846_IhFYq | HR001P | 2024-08-17T12:22:33.431Z | 2024-08-19T12:28:12.322Z |
4829811 | 4829811 | 20240804204233_CM2VU | HR001P | 2024-08-15T12:09:26.228Z | 2024-08-17T12:29:22.390Z |
4825415 | 4825415 | 20240804011309_4n8kI | HR001P | 2024-08-14T12:20:06.191Z | 2024-08-15T12:25:51.123Z |
4825146 | 4825146 | 20240804004822_qn33d | HR001P | 2024-08-14T12:19:57.046Z | 2024-08-15T12:25:45.161Z |
4824922 | 4824922 | 20240804003043_E676q | HR001P | 2024-08-14T12:19:41.088Z | 2024-08-15T12:25:40.352Z |
4821597 | 4821597 | 20240803201031_qnkW0 | HR001P | 2024-08-14T12:15:38.400Z | 2024-08-15T12:23:48.439Z |
4806289 | 4806289 | 20240803014500_1aEga | HR001P | 2024-08-12T12:18:40.877Z | 2024-08-13T12:17:35.651Z |
4805705 | 4805705 | 20240803003939_lxs5c | HR001P | 2024-08-12T12:18:04.001Z | 2024-08-13T12:17:21.612Z |
4803036 | 4803036 | 20240802201642_RZYaH | HR001P | 2024-08-12T12:14:46.648Z | 2024-08-13T12:16:36.481Z |
4779948 | 4779948 | 20240801012954_mRHMJ | HR001P | 2024-08-07T12:14:45.652Z | 2024-08-10T12:21:43.175Z |
4779462 | 4779462 | 20240801004436_tmhV3 | HR001P | 2024-08-07T12:14:29.148Z | 2024-08-10T12:21:29.983Z |
4778821 | 4778821 | 20240731233847_d5dWO | HR001P | 2024-08-07T12:14:02.117Z | 2024-08-10T12:21:15.914Z |
4769850 | 4769850 | 20240731213448_8X0rC | HR001P | 2024-08-06T12:11:17.206Z | 2024-08-10T12:20:45.830Z |
4761987 | 4761987 | 20240731014341_xLHLb | HR001P | 2024-08-06T12:01:30.244Z | 2024-08-10T12:17:32.229Z |
4759296 | 4759296 | 20240730224539_Yz9EG | HR001P | 2024-08-05T12:15:16.726Z | 2024-08-08T12:23:59.145Z |
4745287 | 4745287 | 20240730021821_kuOh6 | HR001P | 2024-08-04T12:07:25.879Z | 2024-08-08T12:18:10.236Z |
4716512 | 4716512 | 20240728014102_elKnu | HR001P | 2024-07-30T12:07:46.454Z | 2024-08-05T12:19:48.769Z |
4704289 | 4704289 | 20240726204400_UKWdI | HR001P | 2024-07-28T12:12:18.817Z | 2024-08-03T12:21:56.074Z |
4704178 | 4704178 | 20240726201624_zPKDT | HR001P | 2024-07-28T12:12:14.739Z | 2024-08-03T12:21:55.624Z |
4696320 | 4696320 | 20240726225623_NkkM5 | HR001P | 2024-07-28T12:02:39.951Z | 2024-08-04T12:19:10.093Z |
4695110 | 4695110 | 20240726212144_6nCqu | HR001P | 2024-07-28T12:00:36.573Z | 2024-08-04T12:19:06.204Z |
4690609 | 4690609 | 20240726001308_5fEHz | HR001P | 2024-07-27T12:03:41.971Z | 2024-08-03T12:21:11.018Z |
4680850 | 4680850 | 20240724005404_XVXmQ | HR001P | 2024-07-25T12:02:52.953Z | 2024-08-01T12:12:02.726Z |
4680694 | 4680694 | 20240723234417_TIdDa | HR001P | 2024-07-25T12:02:41.094Z | 2024-08-01T12:12:02.302Z |
4677773 | 4677773 | 20240723003212_brzmF | HR001P | 2024-07-24T12:01:59.966Z | 2024-07-31T12:17:54.434Z |
4662872 | 4662872 | 20240718021336_xXB02 | HR001P | 2024-07-19T12:05:16.903Z | 2024-07-26T12:17:46.132Z |
4661261 | 4661261 | 20240717220628_TwOSZ | HR001P | 2024-07-19T12:02:58.585Z | 2024-07-26T12:17:27.189Z |
4657686 | 4657686 | 20240716000550_KB6dI | HR001P | 2024-07-18T12:09:06.678Z | 2024-07-24T12:17:10.473Z |
4656528 | 4656528 | 20240715204232_7DSnD | HR001P | 2024-07-18T12:07:45.249Z | 2024-07-24T12:16:56.253Z |
4654490 | 4654490 | 20240716225810_Us4lh | HR001P | 2024-07-18T12:04:42.969Z | 2024-07-25T12:13:53.338Z |
4654138 | 4654138 | 20240716204351_XQRYE | HR001P | 2024-07-18T12:04:07.982Z | 2024-07-25T12:13:49.189Z |
4646607 | 4646607 | 20240714210331_Z3QWk | HR001P | 2024-07-17T12:06:01.442Z | 2024-07-23T12:08:38.881Z |
4627609 | 4627609 | 20240711235941_0RX54 | HR001P | 2024-07-14T12:08:32.192Z | 2024-07-20T12:13:15.555Z |
4618679 | 4618679 | 20240710221939_PqCr3 | HR001P | 2024-07-13T12:07:58.334Z | 2024-07-19T12:13:39.399Z |
4602398 | 4602398 | 20240708213752_9Aiel | HR001P | 2024-07-11T12:09:08.215Z | 2024-07-16T12:09:22.944Z |
4602281 | 4602281 | 20240708202001_Qbc8r | HR001P | 2024-07-11T12:08:54.191Z | 2024-07-16T12:09:22.274Z |
4579481 | 4579481 | 20240707015506_qtslM | HR001P | 2024-07-09T12:02:30.146Z | 2024-07-15T12:12:02.951Z |
4578717 | 4578717 | 20240707004501_oLQnk | HR001P | 2024-07-09T12:01:46.741Z | 2024-07-15T12:11:58.190Z |
4570248 | 4570248 | 20240705234355_tgq4a | HR001P | 2024-07-08T12:01:37.536Z | 2024-07-14T12:13:49.839Z |
4521627 | 4521627 | 20240629011319_bHDnx | HR001P | 2024-06-30T12:04:56.489Z | 2024-07-07T12:13:49.510Z |
4520402 | 4520402 | 20240628232118_22Frk | HR001P | 2024-06-30T12:04:01.388Z | 2024-07-07T12:13:47.418Z |
4519478 | 4519478 | 20240628203145_9xZZt | HR001P | 2024-06-30T12:03:01.448Z | 2024-07-07T12:13:45.129Z |
4478579 | 4478579 | 20240617215233_3fALr | HR001P | 2024-06-19T12:07:00.638Z | 2024-06-26T12:14:42.900Z |
4374465 | 4374465 | 20240520000901_4q54j | HR001P | 2024-05-27T12:08:39.266Z | 2024-05-28T12:13:16.811Z |
4370874 | 4370874 | 20240523003601_r2b0H | HR001P | 2024-05-27T12:00:22.930Z | 2024-05-31T12:15:58.955Z |
4370838 | 4370838 | 20240523000328_bHOCZ | HR001P | 2024-05-27T12:00:15.612Z | 2024-05-31T12:15:56.940Z |
4355089 | 4355089 | 20240511230441_p23T3 | HR001P | 2024-05-22T12:05:20.583Z | 2024-05-22T12:05:20.583Z |
4350737 | 4350737 | 20240511004329_joyyh | HR001P | 2024-05-21T12:04:58.371Z | 2024-05-22T12:11:49.871Z |
4350035 | 4350035 | 20240510212744_iVVhI | HR001P | 2024-05-21T12:03:49.900Z | 2024-05-22T12:11:15.656Z |
4256692 | 4256692 | 20240429014800_FVrhG | HR001P | 2024-05-01T12:12:46.307Z | 2024-05-07T12:18:51.769Z |
4247596 | 4247596 | 20240428001035_dbNhV | HR001P | 2024-04-29T12:09:08.785Z | 2024-05-06T12:21:10.969Z |
4242831 | 4242831 | 20240426204701_PyCxP | HR001P | 2024-04-28T12:07:47.938Z | 2024-05-05T12:21:35.136Z |
4242781 | 4242781 | 20240426201217_W3x3k | HR001P | 2024-04-28T12:07:39.537Z | 2024-05-05T12:21:34.712Z |
4239998 | 4239998 | 20240426015327_1Xd8n | HR001P | 2024-04-27T12:07:52.823Z | 2024-05-04T12:21:24.094Z |
4239934 | 4239934 | 20240426013500_Hpw6M | HR001P | 2024-04-27T12:07:42.048Z | 2024-05-04T12:21:23.697Z |
4226545 | 4226545 | 20240421235927_vemOD | HR001P | 2024-04-23T12:00:36.607Z | 2024-04-30T12:16:46.195Z |
4223094 | 4223094 | 20240421023051_8Vm0w | HR001P | 2024-04-22T12:01:39.337Z | 2024-04-29T12:18:30.294Z |
4217927 | 4217927 | 20240418204956_37gLk | HR001P | 2024-04-20T12:13:28.746Z | 2024-04-26T12:17:42.374Z |
4195103 | 4195103 | 20240416020153_2j8tm | HR001P | 2024-04-17T12:03:19.303Z | 2024-04-24T12:23:25.520Z |
4194938 | 4194938 | 20240416011836_f3wTz | HR001P | 2024-04-17T12:02:45.424Z | 2024-04-24T12:23:22.441Z |
4194217 | 4194217 | 20240415205501_YOpCC | HR001P | 2024-04-17T12:00:45.028Z | 2024-04-24T12:22:48.632Z |
4190019 | 4190019 | 20240414230546_J1UEK | HR001P | 2024-04-16T12:02:42.988Z | 2024-04-23T12:24:41.968Z |
4189782 | 4189782 | 20240414215107_MIWJM | HR001P | 2024-04-16T12:02:08.732Z | 2024-04-23T12:24:37.901Z |
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);