participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,549 rows where station_code = "NZ000T" 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 |
---|---|---|---|---|---|
5315815 | 5315815 | 20241015152144_6Jrl7 | NZ000T | 2024-10-17T12:05:27.591Z | 2024-10-24T12:27:54.652Z |
5315748 | 5315748 | 20241015145914_PbDqz | NZ000T | 2024-10-17T12:05:23.228Z | 2024-10-24T12:27:54.304Z |
5315677 | 5315677 | 20241015144043_fNCpw | NZ000T | 2024-10-17T12:05:19.393Z | 2024-10-24T12:27:53.976Z |
5315644 | 5315644 | 20241015143204_BnmTR | NZ000T | 2024-10-17T12:05:14.062Z | 2024-10-24T12:27:53.807Z |
5315598 | 5315598 | 20241015142010_XBDCi | NZ000T | 2024-10-17T12:05:06.387Z | 2024-10-24T12:27:53.638Z |
5315568 | 5315568 | 20241015140946_pey22 | NZ000T | 2024-10-17T12:05:02.843Z | 2024-10-24T12:27:53.416Z |
5315416 | 5315416 | 20241015125811_a6bI3 | NZ000T | 2024-10-17T12:04:39.704Z | 2024-10-24T12:27:52.870Z |
5315341 | 5315341 | 20241015122214_3kqBW | NZ000T | 2024-10-17T12:04:28.100Z | 2024-10-24T12:27:52.008Z |
5314782 | 5314782 | 20241016155050_HqJZj | NZ000T | 2024-10-17T12:02:48.932Z | 2024-10-25T12:24:32.322Z |
5314732 | 5314732 | 20241016152236_ZmhHn | NZ000T | 2024-10-17T12:02:44.552Z | 2024-10-25T12:24:31.730Z |
5314714 | 5314714 | 20241016151547_vYVRS | NZ000T | 2024-10-17T12:02:43.571Z | 2024-10-25T12:24:31.708Z |
5314674 | 5314674 | 20241016150142_wSeBi | NZ000T | 2024-10-17T12:02:40.080Z | 2024-10-25T12:24:31.616Z |
5314535 | 5314535 | 20241016135949_1wv69 | NZ000T | 2024-10-17T12:02:31.807Z | 2024-10-25T12:24:31.266Z |
5314414 | 5314414 | 20241016125253_BUe4Z | NZ000T | 2024-10-17T12:02:19.262Z | 2024-10-25T12:24:30.334Z |
5259005 | 5259005 | 20241007124244_b8Tah | NZ000T | 2024-10-09T12:10:15.839Z | 2024-10-16T12:21:08.156Z |
5258466 | 5258466 | 20241008161954_m2Ll8 | NZ000T | 2024-10-09T12:07:00.947Z | 2024-10-17T12:20:05.763Z |
5258397 | 5258397 | 20241008155817_aVaLN | NZ000T | 2024-10-09T12:06:53.197Z | 2024-10-17T12:20:05.423Z |
5258379 | 5258379 | 20241008155033_YwzX1 | NZ000T | 2024-10-09T12:06:51.651Z | 2024-10-17T12:20:05.190Z |
5251720 | 5251720 | 20241006143429_173p6 | NZ000T | 2024-10-08T12:10:31.996Z | 2024-10-15T12:28:54.628Z |
5249093 | 5249093 | 20241007080808_LwIQW | NZ000T | 2024-10-08T12:04:05.018Z | 2024-10-16T12:21:02.886Z |
5242732 | 5242732 | 20241005150317_00Q2A | NZ000T | 2024-10-07T12:12:35.268Z | 2024-10-14T12:24:29.632Z |
5242663 | 5242663 | 20241005144417_mxYyi | NZ000T | 2024-10-07T12:12:29.107Z | 2024-10-14T12:24:29.426Z |
5242632 | 5242632 | 20241005143936_wWmKg | NZ000T | 2024-10-07T12:12:27.230Z | 2024-10-14T12:24:29.350Z |
5242558 | 5242558 | 20241005142749_naQo9 | NZ000T | 2024-10-07T12:12:21.703Z | 2024-10-14T12:24:29.274Z |
5242499 | 5242499 | 20241005141704_wqbUw | NZ000T | 2024-10-07T12:12:17.457Z | 2024-10-14T12:24:29.030Z |
5242489 | 5242489 | 20241005141545_L2Eif | NZ000T | 2024-10-07T12:12:16.693Z | 2024-10-14T12:24:29.026Z |
5242425 | 5242425 | 20241005140423_t2ugo | NZ000T | 2024-10-07T12:12:09.315Z | 2024-10-14T12:24:28.916Z |
5242378 | 5242378 | 20241005135727_0UKEe | NZ000T | 2024-10-07T12:12:06.141Z | 2024-10-14T12:24:28.890Z |
5242369 | 5242369 | 20241005135719_xC93n | NZ000T | 2024-10-07T12:12:05.796Z | 2024-10-14T12:24:28.888Z |
5242342 | 5242342 | 20241005135322_S1gEa | NZ000T | 2024-10-07T12:12:04.636Z | 2024-10-14T12:24:28.857Z |
5242092 | 5242092 | 20241005124843_wBMS5 | NZ000T | 2024-10-07T12:11:46.178Z | 2024-10-14T12:24:28.411Z |
5241887 | 5241887 | 20241005115922_sxj9x | NZ000T | 2024-10-07T12:11:13.797Z | 2024-10-14T12:24:28.052Z |
5198089 | 5198089 | 20240929165345_3yA45 | NZ000T | 2024-10-01T12:14:17.199Z | 2024-10-07T12:21:30.527Z |
5198064 | 5198064 | 20240929165050_FH3nZ | NZ000T | 2024-10-01T12:14:15.033Z | 2024-10-07T12:21:30.488Z |
5198004 | 5198004 | 20240929164125_138gW | NZ000T | 2024-10-01T12:14:09.393Z | 2024-10-07T12:21:30.324Z |
5196942 | 5196942 | 20240930132602_5wsyt | NZ000T | 2024-10-01T12:08:45.303Z | 2024-10-09T12:29:07.283Z |
5196851 | 5196851 | 20240930122336_Fnl6S | NZ000T | 2024-10-01T12:08:34.714Z | 2024-10-09T12:29:06.869Z |
5196840 | 5196840 | 20240930121855_sa6Jp | NZ000T | 2024-10-01T12:08:33.280Z | 2024-10-09T12:29:06.839Z |
5196675 | 5196675 | 20240930113532_po9oe | NZ000T | 2024-10-01T12:08:04.316Z | 2024-10-09T12:29:06.466Z |
5195923 | 5195923 | 20240930090448_e06Cr | NZ000T | 2024-10-01T12:06:08.028Z | 2024-10-09T12:29:04.276Z |
5194246 | 5194246 | 20240929154222_FSc4a | NZ000T | 2024-09-30T12:19:35.718Z | 2024-10-07T12:21:29.570Z |
5193986 | 5193986 | 20240929143810_0Dd48 | NZ000T | 2024-09-30T12:19:31.776Z | 2024-10-07T12:21:28.633Z |
5193933 | 5193933 | 20240929142517_gdOuF | NZ000T | 2024-09-30T12:19:30.233Z | 2024-10-07T12:21:28.454Z |
5193921 | 5193921 | 20240929142337_Zk6vW | NZ000T | 2024-09-30T12:19:30.073Z | 2024-10-07T12:21:28.423Z |
5193876 | 5193876 | 20240929140850_o7jPs | NZ000T | 2024-09-30T12:19:28.879Z | 2024-10-07T12:21:27.637Z |
5193871 | 5193871 | 20240929140833_Cr21b | NZ000T | 2024-09-30T12:19:28.838Z | 2024-10-07T12:21:27.628Z |
5193155 | 5193155 | 20240929105935_AQ2Xg | NZ000T | 2024-09-30T12:19:09.214Z | 2024-10-07T12:21:24.767Z |
5190424 | 5190424 | 20240928170004_VK8mN | NZ000T | 2024-09-30T12:16:49.046Z | 2024-10-06T12:28:19.453Z |
5190402 | 5190402 | 20240928165531_PRE7R | NZ000T | 2024-09-30T12:16:48.411Z | 2024-10-06T12:28:19.430Z |
5190352 | 5190352 | 20240928164843_FVukP | NZ000T | 2024-09-30T12:16:46.194Z | 2024-10-06T12:28:19.340Z |
5190348 | 5190348 | 20240928164803_4YFEu | NZ000T | 2024-09-30T12:16:45.861Z | 2024-10-06T12:28:19.330Z |
5190332 | 5190332 | 20240928164322_6z6Qw | NZ000T | 2024-09-30T12:16:44.293Z | 2024-10-06T12:28:19.313Z |
5190270 | 5190270 | 20240928163308_0dtH5 | NZ000T | 2024-09-30T12:16:40.577Z | 2024-10-06T12:28:19.233Z |
5190224 | 5190224 | 20240928162310_j2e2K | NZ000T | 2024-09-30T12:16:38.233Z | 2024-10-06T12:28:19.121Z |
5190154 | 5190154 | 20240928161021_B09JA | NZ000T | 2024-09-30T12:16:33.591Z | 2024-10-06T12:28:19.026Z |
5190094 | 5190094 | 20240928160344_OrbnM | NZ000T | 2024-09-30T12:16:29.601Z | 2024-10-06T12:28:18.940Z |
5190084 | 5190084 | 20240928160228_fbQPH | NZ000T | 2024-09-30T12:16:28.802Z | 2024-10-06T12:28:18.913Z |
5189989 | 5189989 | 20240928153552_iZf6F | NZ000T | 2024-09-30T12:16:22.444Z | 2024-10-06T12:28:18.724Z |
5189965 | 5189965 | 20240928153239_dKtKr | NZ000T | 2024-09-30T12:16:21.133Z | 2024-10-06T12:28:18.663Z |
5189949 | 5189949 | 20240928152949_W2fi1 | NZ000T | 2024-09-30T12:16:20.126Z | 2024-10-06T12:28:18.644Z |
5189892 | 5189892 | 20240928151359_gTMG3 | NZ000T | 2024-09-30T12:16:15.646Z | 2024-10-06T12:28:18.548Z |
5189803 | 5189803 | 20240928145649_EYO41 | NZ000T | 2024-09-30T12:16:09.305Z | 2024-10-06T12:28:18.352Z |
5189521 | 5189521 | 20240928135230_635hv | NZ000T | 2024-09-30T12:15:45.452Z | 2024-10-06T12:28:17.797Z |
5189255 | 5189255 | 20240928125057_h33Kd | NZ000T | 2024-09-30T12:15:22.753Z | 2024-10-06T12:28:17.213Z |
5188924 | 5188924 | 20240928115043_2r2k0 | NZ000T | 2024-09-30T12:14:45.456Z | 2024-10-06T12:28:16.360Z |
5188671 | 5188671 | 20240928111429_PFJuU | NZ000T | 2024-09-30T12:14:26.613Z | 2024-10-06T12:28:15.807Z |
5188032 | 5188032 | 20240928094429_AsBJ4 | NZ000T | 2024-09-30T12:13:32.465Z | 2024-10-06T12:28:14.077Z |
5187630 | 5187630 | 20240929103907_4VZOo | NZ000T | 2024-09-30T12:09:54.736Z | 2024-10-07T12:21:24.638Z |
5173113 | 5173113 | 20240927141711_y2Lrx | NZ000T | 2024-09-28T12:11:58.114Z | 2024-10-05T12:28:54.781Z |
5172329 | 5172329 | 20240927121558_t0lvC | NZ000T | 2024-09-28T12:10:35.085Z | 2024-10-05T12:28:51.436Z |
5172282 | 5172282 | 20240927120952_5oyv7 | NZ000T | 2024-09-28T12:10:30.832Z | 2024-10-05T12:28:51.231Z |
5172137 | 5172137 | 20240927114901_CH5uf | NZ000T | 2024-09-28T12:10:02.483Z | 2024-10-05T12:28:49.842Z |
5171357 | 5171357 | 20240927095028_Fsol1 | NZ000T | 2024-09-28T12:08:22.587Z | 2024-10-05T12:28:45.235Z |
5170725 | 5170725 | 20240927075627_r8jOw | NZ000T | 2024-09-28T12:07:00.871Z | 2024-10-05T12:28:41.668Z |
5167720 | 5167720 | 20240926144757_Exaax | NZ000T | 2024-09-27T12:05:36.180Z | 2024-10-04T12:25:29.418Z |
5167619 | 5167619 | 20240926132519_07bYZ | NZ000T | 2024-09-27T12:05:24.815Z | 2024-10-04T12:25:28.013Z |
5167610 | 5167610 | 20240926132027_pDJwT | NZ000T | 2024-09-27T12:05:24.150Z | 2024-10-04T12:25:27.981Z |
5167054 | 5167054 | 20240926095909_waju9 | NZ000T | 2024-09-27T12:04:07.131Z | 2024-10-04T12:25:22.579Z |
5166971 | 5166971 | 20240926093815_61kSy | NZ000T | 2024-09-27T12:03:54.828Z | 2024-10-04T12:25:21.010Z |
5166781 | 5166781 | 20240926084020_TyBuz | NZ000T | 2024-09-27T12:03:36.385Z | 2024-10-04T12:25:19.057Z |
5164527 | 5164527 | 20240924172939_3xyjf | NZ000T | 2024-09-26T12:12:43.185Z | 2024-10-02T12:19:02.087Z |
5164499 | 5164499 | 20240924172605_3Xcwy | NZ000T | 2024-09-26T12:12:41.595Z | 2024-10-02T12:19:02.037Z |
5164350 | 5164350 | 20240924170614_Ym4cH | NZ000T | 2024-09-26T12:12:35.058Z | 2024-10-02T12:19:01.698Z |
5164245 | 5164245 | 20240924165253_ikMhR | NZ000T | 2024-09-26T12:12:29.037Z | 2024-10-02T12:19:01.408Z |
5164198 | 5164198 | 20240924164750_wZVLk | NZ000T | 2024-09-26T12:12:26.961Z | 2024-10-02T12:19:01.359Z |
5164183 | 5164183 | 20240924164429_xzLwP | NZ000T | 2024-09-26T12:12:26.418Z | 2024-10-02T12:19:01.350Z |
5164095 | 5164095 | 20240924162755_LQR1Z | NZ000T | 2024-09-26T12:12:21.654Z | 2024-10-02T12:19:01.073Z |
5164057 | 5164057 | 20240924162211_DWkM2 | NZ000T | 2024-09-26T12:12:19.954Z | 2024-10-02T12:19:01.042Z |
5164044 | 5164044 | 20240924162044_5I4Tk | NZ000T | 2024-09-26T12:12:19.497Z | 2024-10-02T12:19:01.037Z |
5164026 | 5164026 | 20240924161845_3YtXb | NZ000T | 2024-09-26T12:12:18.677Z | 2024-10-02T12:19:01.018Z |
5163770 | 5163770 | 20240924153904_jqaSx | NZ000T | 2024-09-26T12:12:05.191Z | 2024-10-02T12:19:00.612Z |
5163673 | 5163673 | 20240924152258_6sEUt | NZ000T | 2024-09-26T12:11:59.768Z | 2024-10-02T12:19:00.400Z |
5163570 | 5163570 | 20240924150522_KL92f | NZ000T | 2024-09-26T12:11:54.912Z | 2024-10-02T12:19:00.233Z |
5163524 | 5163524 | 20240924150008_TOFv3 | NZ000T | 2024-09-26T12:11:53.129Z | 2024-10-02T12:19:00.182Z |
5163262 | 5163262 | 20240924140431_BAVxG | NZ000T | 2024-09-26T12:11:35.196Z | 2024-10-02T12:18:59.805Z |
5163223 | 5163223 | 20240924135705_FtLnt | NZ000T | 2024-09-26T12:11:32.630Z | 2024-10-02T12:18:59.688Z |
5163217 | 5163217 | 20240924135505_gAfeT | NZ000T | 2024-09-26T12:11:32.353Z | 2024-10-02T12:18:59.684Z |
5163214 | 5163214 | 20240924135310_F2woj | NZ000T | 2024-09-26T12:11:32.180Z | 2024-10-02T12:18:59.680Z |
5163160 | 5163160 | 20240924134354_9xo2c | NZ000T | 2024-09-26T12:11:28.320Z | 2024-10-02T12:18:59.608Z |
5163142 | 5163142 | 20240924133813_I6bSG | NZ000T | 2024-09-26T12:11:27.141Z | 2024-10-02T12:18:59.329Z |
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);