participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
123 rows where station_code = "NZ0048" 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 |
---|---|---|---|---|---|
5067414 | 5067414 | 20240910092659_FKKLl | NZ0048 | 2024-09-14T12:18:42.928Z | 2024-09-18T12:15:24.056Z |
5043130 | 5043130 | 20240907135612_6JpZ4 | NZ0048 | 2024-09-12T12:17:23.779Z | 2024-09-16T12:20:55.570Z |
5027829 | 5027829 | 20240905082723_JBlow | NZ0048 | 2024-09-11T12:14:33.522Z | 2024-09-13T12:20:04.750Z |
5022275 | 5022275 | 20240905082723_juNWs | NZ0048 | 2024-09-10T12:16:13.064Z | 2024-09-10T12:16:55.525Z |
5016333 | 5016333 | 20240904140049_ZsBoZ | NZ0048 | 2024-09-10T12:07:41.900Z | 2024-09-13T12:19:45.521Z |
5015949 | 5015949 | 20240904130612_16K4w | NZ0048 | 2024-09-10T12:07:03.667Z | 2024-09-13T12:19:45.064Z |
5004676 | 5004676 | 20240903120528_qfdcl | NZ0048 | 2024-09-09T12:02:54.125Z | 2024-09-12T12:19:03.482Z |
5004016 | 5004016 | 20240903102259_nKqLG | NZ0048 | 2024-09-09T12:02:16.955Z | 2024-09-12T12:19:00.314Z |
4994967 | 4994967 | 20240902154628_Lw1cx | NZ0048 | 2024-09-08T12:03:08.331Z | 2024-09-11T12:20:40.685Z |
4984153 | 4984153 | 20240901091526_wtqvD | NZ0048 | 2024-09-07T12:01:28.005Z | 2024-09-10T12:19:04.588Z |
4931592 | 4931592 | 20240810104508_HRoEv | NZ0048 | 2024-08-31T12:24:43.495Z | 2024-09-02T12:31:02.538Z |
4885988 | 4885988 | 20240808124208_W5nx9 | NZ0048 | 2024-08-28T12:01:30.924Z | 2024-08-30T12:16:07.211Z |
4885818 | 4885818 | 20240808115033_c9MVf | NZ0048 | 2024-08-28T12:01:17.278Z | 2024-08-30T12:16:00.071Z |
4885276 | 4885276 | 20240808094908_g5jax | NZ0048 | 2024-08-28T12:00:19.363Z | 2024-08-30T12:15:26.294Z |
4870446 | 4870446 | 20240806180048_nCOUs | NZ0048 | 2024-08-19T12:07:52.938Z | 2024-08-27T12:08:46.544Z |
4868785 | 4868785 | 20240806071127_dTjyn | NZ0048 | 2024-08-18T12:24:29.950Z | 2024-08-19T12:29:00.909Z |
4860832 | 4860832 | 20240806110600_MGlla | NZ0048 | 2024-08-18T12:03:09.355Z | 2024-08-27T12:03:05.259Z |
4859913 | 4859913 | 20240806100839_Hq5Xm | NZ0048 | 2024-08-18T12:02:19.121Z | 2024-08-27T12:02:21.351Z |
4845032 | 4845032 | 20240805152210_DmYMv | NZ0048 | 2024-08-16T12:08:45.899Z | 2024-08-19T12:20:00.039Z |
4839140 | 4839140 | 20240805095309_UWkVS | NZ0048 | 2024-08-16T12:03:07.348Z | 2024-08-19T12:16:24.485Z |
4807127 | 4807127 | 20240803093233_642sa | NZ0048 | 2024-08-13T12:02:29.310Z | 2024-08-15T12:18:20.991Z |
4798157 | 4798157 | 20240803081801_o6CNV | NZ0048 | 2024-08-12T12:02:49.492Z | 2024-08-15T12:17:39.655Z |
4790254 | 4790254 | 20240802115011_Dls3i | NZ0048 | 2024-08-11T12:07:01.949Z | 2024-08-13T12:16:04.773Z |
4788678 | 4788678 | 20240802094532_lomj3 | NZ0048 | 2024-08-11T12:04:53.628Z | 2024-08-13T12:15:52.940Z |
4777932 | 4777932 | 20240801180904_hNkTL | NZ0048 | 2024-08-07T12:10:59.212Z | 2024-08-11T12:13:25.073Z |
4726048 | 4726048 | 20240728155102_TtSID | NZ0048 | 2024-07-31T12:11:58.364Z | 2024-08-05T12:20:22.338Z |
4711718 | 4711718 | 20240727174234_AmKyC | NZ0048 | 2024-07-29T12:12:22.405Z | 2024-08-04T12:20:01.919Z |
4707835 | 4707835 | 20240727073820_A2ujG | NZ0048 | 2024-07-29T12:08:18.192Z | 2024-08-04T12:19:27.762Z |
4685814 | 4685814 | 20240725101249_a2jo2 | NZ0048 | 2024-07-26T12:06:06.127Z | 2024-08-02T12:24:48.698Z |
4685356 | 4685356 | 20240725090403_DI2sq | NZ0048 | 2024-07-26T12:05:23.525Z | 2024-08-02T12:24:41.375Z |
4682144 | 4682144 | 20240724102503_N2XK0 | NZ0048 | 2024-07-25T12:05:00.248Z | 2024-08-01T12:12:05.758Z |
4681325 | 4681325 | 20240724065008_iJhLV | NZ0048 | 2024-07-25T12:03:53.821Z | 2024-08-01T12:12:04.304Z |
4679538 | 4679538 | 20240723152759_BcWjo | NZ0048 | 2024-07-24T12:05:48.375Z | 2024-07-31T12:18:06.557Z |
4679093 | 4679093 | 20240723125534_a3jt1 | NZ0048 | 2024-07-24T12:05:05.455Z | 2024-07-31T12:18:04.699Z |
4673273 | 4673273 | 20240720100012_0uCr2 | NZ0048 | 2024-07-21T12:05:16.814Z | 2024-07-28T12:14:59.508Z |
4655620 | 4655620 | 20240715180221_ulafK | NZ0048 | 2024-07-18T12:06:58.060Z | 2024-07-24T12:16:50.972Z |
4632531 | 4632531 | 20240712151618_UIb2x | NZ0048 | 2024-07-15T12:05:22.025Z | 2024-07-21T12:13:25.988Z |
4612615 | 4612615 | 20240711082558_FNBRq | NZ0048 | 2024-07-13T12:01:13.530Z | 2024-07-20T12:13:06.702Z |
4600997 | 4600997 | 20240708165144_eH11L | NZ0048 | 2024-07-11T12:07:57.970Z | 2024-07-16T12:09:21.076Z |
4598330 | 4598330 | 20240708082511_0kRKA | NZ0048 | 2024-07-11T12:04:20.451Z | 2024-07-16T12:09:15.862Z |
4598219 | 4598219 | 20240708080200_f0Cf2 | NZ0048 | 2024-07-11T12:04:09.674Z | 2024-07-16T12:09:15.423Z |
4598127 | 4598127 | 20240708075117_I0GRR | NZ0048 | 2024-07-11T12:04:03.772Z | 2024-07-16T12:09:15.097Z |
4582940 | 4582940 | 20240706133358_OSlQo | NZ0048 | 2024-07-09T12:05:39.727Z | 2024-07-14T12:14:07.211Z |
4555057 | 4555057 | 20240704080928_A6xL5 | NZ0048 | 2024-07-06T12:05:28.883Z | 2024-07-12T12:08:55.804Z |
4549709 | 4549709 | 20240703151058_NGLJ9 | NZ0048 | 2024-07-05T12:06:20.211Z | 2024-07-11T12:14:44.402Z |
4534092 | 4534092 | 20240701170146_B76PN | NZ0048 | 2024-07-03T12:00:10.596Z | 2024-07-10T12:15:21.342Z |
4533462 | 4533462 | 20240701163020_zb3iJ | NZ0048 | 2024-07-02T12:05:13.206Z | 2024-07-09T12:08:08.792Z |
4527336 | 4527336 | 20240630115545_Wu9dQ | NZ0048 | 2024-07-01T12:04:37.438Z | 2024-07-08T12:11:55.449Z |
4491350 | 4491350 | 20240620181224_dmp3L | NZ0048 | 2024-06-22T12:04:11.105Z | 2024-06-29T12:13:28.804Z |
4491095 | 4491095 | 20240620171910_aV3ur | NZ0048 | 2024-06-22T12:03:33.370Z | 2024-06-29T12:13:27.512Z |
4482433 | 4482433 | 20240618133537_hJ3hK | NZ0048 | 2024-06-20T12:02:35.452Z | 2024-06-27T12:11:16.841Z |
4470489 | 4470489 | 20240615174904_yDfgB | NZ0048 | 2024-06-17T12:07:30.028Z | 2024-06-23T12:12:30.365Z |
4459405 | 4459405 | 20240612174901_wKuIC | NZ0048 | 2024-06-14T12:05:32.005Z | 2024-06-20T12:12:05.098Z |
4441077 | 4441077 | 20240608115144_q0kp2 | NZ0048 | 2024-06-10T12:04:07.204Z | 2024-06-16T12:14:19.642Z |
4434960 | 4434960 | 20240607094654_kw16g | NZ0048 | 2024-06-09T12:03:42.092Z | 2024-06-15T12:17:05.261Z |
4430022 | 4430022 | 20240606091312_vEq3m | NZ0048 | 2024-06-08T12:09:52.196Z | 2024-06-14T12:08:29.128Z |
4420130 | 4420130 | 20240605174919_sYOAz | NZ0048 | 2024-06-07T12:03:23.958Z | 2024-06-14T12:08:15.479Z |
4412598 | 4412598 | 20240604115350_1DF83 | NZ0048 | 2024-06-06T12:00:19.789Z | 2024-06-13T12:08:28.009Z |
4412567 | 4412567 | 20240604114512_GeXSu | NZ0048 | 2024-06-06T12:00:15.721Z | 2024-06-13T12:08:27.991Z |
4358200 | 4358200 | 20240511084306_rqTU0 | NZ0048 | 2024-05-22T12:12:48.101Z | 2024-05-22T12:12:48.101Z |
4358125 | 4358125 | 20240511082240_RfNg9 | NZ0048 | 2024-05-22T12:12:45.295Z | 2024-05-22T12:12:45.295Z |
4352764 | 4352764 | 20240511154432_g3CfD | NZ0048 | 2024-05-22T12:02:08.825Z | 2024-05-22T12:02:08.825Z |
4339074 | 4339074 | 20240509172330_5vKL7 | NZ0048 | 2024-05-19T12:05:06.276Z | 2024-05-21T12:08:36.286Z |
4339026 | 4339026 | 20240509172113_qLcvY | NZ0048 | 2024-05-19T12:05:03.916Z | 2024-05-21T12:08:35.385Z |
4331114 | 4331114 | 20240509125721_2IeOJ | NZ0048 | 2024-05-18T12:01:40.703Z | 2024-05-21T12:06:26.333Z |
4330577 | 4330577 | 20240509115546_q93qE | NZ0048 | 2024-05-18T12:00:37.476Z | 2024-05-21T12:06:05.224Z |
4328985 | 4328985 | 20240508181019_YMrOm | NZ0048 | 2024-05-17T12:08:17.140Z | 2024-05-19T12:14:10.778Z |
4318668 | 4318668 | 20240507174713_dpu27 | NZ0048 | 2024-05-16T12:05:24.013Z | 2024-05-17T12:11:11.647Z |
4313998 | 4313998 | 20240507153338_LcjSN | NZ0048 | 2024-05-15T12:06:18.880Z | 2024-05-17T12:10:36.983Z |
4313891 | 4313891 | 20240507152708_2HRI5 | NZ0048 | 2024-05-15T12:06:14.480Z | 2024-05-17T12:10:35.918Z |
4313584 | 4313584 | 20240507151019_PktQI | NZ0048 | 2024-05-15T12:05:51.826Z | 2024-05-17T12:10:30.390Z |
4306107 | 4306107 | 20240506163507_NoVHM | NZ0048 | 2024-05-14T12:05:16.429Z | 2024-05-16T12:12:48.979Z |
4305879 | 4305879 | 20240506161046_jQamO | NZ0048 | 2024-05-14T12:04:40.051Z | 2024-05-16T12:12:46.900Z |
4305355 | 4305355 | 20240506152151_I4UDr | NZ0048 | 2024-05-14T12:03:44.135Z | 2024-05-16T12:12:41.837Z |
4292353 | 4292353 | 20240504173716_ui7WT | NZ0048 | 2024-05-08T12:05:35.662Z | 2024-05-13T12:10:20.294Z |
4290101 | 4290101 | 20240504170809_NJVg8 | NZ0048 | 2024-05-07T12:08:27.688Z | 2024-05-13T12:10:06.015Z |
4289742 | 4289742 | 20240504165058_2Dmbv | NZ0048 | 2024-05-07T12:07:55.459Z | 2024-05-13T12:09:49.740Z |
4289656 | 4289656 | 20240504164517_qxCtD | NZ0048 | 2024-05-07T12:07:49.391Z | 2024-05-13T12:09:46.599Z |
4286037 | 4286037 | 20240504094313_gnqic | NZ0048 | 2024-05-07T12:02:02.178Z | 2024-05-13T12:07:48.606Z |
4281565 | 4281565 | 20240503173016_ZGC16 | NZ0048 | 2024-05-06T12:09:44.661Z | 2024-05-12T12:18:15.738Z |
4279687 | 4279687 | 20240503161814_twk1m | NZ0048 | 2024-05-06T12:07:24.689Z | 2024-05-12T12:17:54.551Z |
4273005 | 4273005 | 20240503100636_mK3X7 | NZ0048 | 2024-05-05T12:03:03.766Z | 2024-05-12T12:15:27.138Z |
4271103 | 4271103 | 20240502160930_vWlUu | NZ0048 | 2024-05-04T12:10:16.207Z | 2024-05-11T12:27:03.982Z |
4269119 | 4269119 | 20240502123000_rgvSr | NZ0048 | 2024-05-04T12:06:45.415Z | 2024-05-11T12:26:17.821Z |
4267339 | 4267339 | 20240502073140_gAUYd | NZ0048 | 2024-05-04T12:01:27.489Z | 2024-05-11T12:25:15.329Z |
4255245 | 4255245 | 20240429165033_2Up8C | NZ0048 | 2024-05-01T12:06:58.426Z | 2024-05-08T12:24:50.799Z |
4255159 | 4255159 | 20240429163454_rsm9l | NZ0048 | 2024-05-01T12:06:52.245Z | 2024-05-08T12:24:50.543Z |
4253089 | 4253089 | 20240429075639_7Rtr7 | NZ0048 | 2024-05-01T12:01:32.659Z | 2024-05-08T12:24:42.352Z |
4247984 | 4247984 | 20240428075507_tHo6X | NZ0048 | 2024-04-30T12:00:46.287Z | 2024-05-07T12:18:12.864Z |
4245354 | 4245354 | 20240427123240_Fqbhq | NZ0048 | 2024-04-29T12:05:13.595Z | 2024-05-06T12:20:59.675Z |
4241445 | 4241445 | 20240426145002_EvRZj | NZ0048 | 2024-04-28T12:04:32.542Z | 2024-05-05T12:21:31.945Z |
4236140 | 4236140 | 20240423085430_idY37 | NZ0048 | 2024-04-26T12:06:01.569Z | 2024-05-02T12:22:41.185Z |
4224662 | 4224662 | 20240420165555_5x98g | NZ0048 | 2024-04-22T12:07:01.268Z | 2024-04-28T12:21:59.934Z |
4217141 | 4217141 | 20240418172703_dos3B | NZ0048 | 2024-04-20T12:11:54.945Z | 2024-04-26T12:17:33.593Z |
4214521 | 4214521 | 20240418082758_nmyTF | NZ0048 | 2024-04-20T12:05:49.387Z | 2024-04-26T12:17:06.681Z |
4173631 | 4173631 | 20240410155212_W4Vpv | NZ0048 | 2024-04-12T12:11:44.651Z | 2024-04-18T12:21:36.662Z |
4173471 | 4173471 | 20240410144751_rqOM7 | NZ0048 | 2024-04-12T12:11:33.431Z | 2024-04-18T12:21:35.624Z |
4168799 | 4168799 | 20240409163857_0psJS | NZ0048 | 2024-04-11T12:11:52.042Z | 2024-04-17T12:21:38.505Z |
4168461 | 4168461 | 20240409152800_hLh10 | NZ0048 | 2024-04-11T12:11:20.368Z | 2024-04-17T12:21:35.627Z |
4168198 | 4168198 | 20240409142626_bl52M | NZ0048 | 2024-04-11T12:10:51.809Z | 2024-04-17T12:21:32.931Z |
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);