participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,279 rows where station_code = "NZ003Q" 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 |
---|---|---|---|---|---|
5569533 | 5569533 | 20241121155912_ytPH4 | NZ003Q | 2024-11-22T14:11:02.558Z | 2024-11-22T14:11:02.558Z |
5569489 | 5569489 | 20241121154158_sr2sT | NZ003Q | 2024-11-22T14:10:58.370Z | 2024-11-22T14:10:58.370Z |
5569273 | 5569273 | 20241121150353_T3ogZ | NZ003Q | 2024-11-22T14:10:43.379Z | 2024-11-22T14:10:43.379Z |
5569148 | 5569148 | 20241121144130_KdzVi | NZ003Q | 2024-11-22T14:10:24.193Z | 2024-11-22T14:10:24.193Z |
5569146 | 5569146 | 20241121144108_3nM2T | NZ003Q | 2024-11-22T14:10:23.867Z | 2024-11-22T14:10:23.867Z |
5568919 | 5568919 | 20241121140408_rP7aL | NZ003Q | 2024-11-22T14:10:04.338Z | 2024-11-22T14:10:04.338Z |
5568779 | 5568779 | 20241121133209_d87k5 | NZ003Q | 2024-11-22T14:09:41.744Z | 2024-11-22T14:09:41.744Z |
5568759 | 5568759 | 20241121133044_KvoHH | NZ003Q | 2024-11-22T14:09:40.370Z | 2024-11-22T14:09:40.370Z |
5568755 | 5568755 | 20241121132955_wLXjP | NZ003Q | 2024-11-22T14:09:40.081Z | 2024-11-22T14:09:40.081Z |
5568717 | 5568717 | 20241121132644_aaRQg | NZ003Q | 2024-11-22T14:09:36.261Z | 2024-11-22T14:09:36.261Z |
5568405 | 5568405 | 20241121124153_JHc2N | NZ003Q | 2024-11-22T14:08:52.356Z | 2024-11-22T14:08:52.356Z |
5568314 | 5568314 | 20241121122252_1kLHu | NZ003Q | 2024-11-22T14:08:41.506Z | 2024-11-22T14:08:41.506Z |
5567291 | 5567291 | 20241121095823_QgWzV | NZ003Q | 2024-11-22T14:05:46.703Z | 2024-11-22T14:05:46.703Z |
5567216 | 5567216 | 20241121094252_52OnX | NZ003Q | 2024-11-22T14:05:35.634Z | 2024-11-22T14:05:35.634Z |
5560683 | 5560683 | 20241120135539_f7bgv | NZ003Q | 2024-11-21T14:09:25.331Z | 2024-11-22T14:19:21.712Z |
5560631 | 5560631 | 20241120132839_KSjfC | NZ003Q | 2024-11-21T14:09:17.947Z | 2024-11-22T14:19:21.701Z |
5559152 | 5559152 | 20241120092959_BlUhT | NZ003Q | 2024-11-21T14:05:29.182Z | 2024-11-22T14:19:21.375Z |
5555372 | 5555372 | 20241119125636_yERC8 | NZ003Q | 2024-11-20T14:05:20.032Z | 2024-11-22T14:20:04.912Z |
5551797 | 5551797 | 20241118151719_BSebL | NZ003Q | 2024-11-19T14:05:32.406Z | 2024-11-22T14:22:12.531Z |
5551677 | 5551677 | 20241118144128_85XvK | NZ003Q | 2024-11-19T14:05:10.884Z | 2024-11-22T14:22:12.030Z |
5551485 | 5551485 | 20241118135524_hS1De | NZ003Q | 2024-11-19T14:04:52.144Z | 2024-11-22T14:22:11.012Z |
5551438 | 5551438 | 20241118133558_4e20D | NZ003Q | 2024-11-19T14:04:47.002Z | 2024-11-22T14:22:10.678Z |
5551386 | 5551386 | 20241118132009_JmGGm | NZ003Q | 2024-11-19T14:04:42.904Z | 2024-11-22T14:22:10.449Z |
5551065 | 5551065 | 20241118121759_34X1p | NZ003Q | 2024-11-19T14:03:51.807Z | 2024-11-22T14:22:08.002Z |
5550776 | 5550776 | 20241118112412_zxlnY | NZ003Q | 2024-11-19T14:03:04.790Z | 2024-11-22T14:22:05.526Z |
5550724 | 5550724 | 20241118111524_Uc36n | NZ003Q | 2024-11-19T14:02:58.699Z | 2024-11-22T14:22:05.079Z |
5550384 | 5550384 | 20241118101124_sy9bb | NZ003Q | 2024-11-19T14:02:16.209Z | 2024-11-22T14:22:02.597Z |
5550186 | 5550186 | 20241118094412_07H6l | NZ003Q | 2024-11-19T14:01:43.131Z | 2024-11-22T14:21:59.474Z |
5549864 | 5549864 | 20241118082106_d3o5Z | NZ003Q | 2024-11-19T14:01:01.198Z | 2024-11-22T14:21:54.248Z |
5547381 | 5547381 | 20241117155359_Fz7D0 | NZ003Q | 2024-11-18T14:05:38.055Z | 2024-11-22T14:22:39.330Z |
5546987 | 5546987 | 20241117140022_KrGxb | NZ003Q | 2024-11-18T14:04:39.675Z | 2024-11-22T14:22:36.247Z |
5546892 | 5546892 | 20241117131704_MIS6i | NZ003Q | 2024-11-18T14:04:24.869Z | 2024-11-22T14:22:35.282Z |
5546475 | 5546475 | 20241117110636_2d1IR | NZ003Q | 2024-11-18T14:03:11.613Z | 2024-11-22T14:22:32.195Z |
5546397 | 5546397 | 20241117104244_cZbB5 | NZ003Q | 2024-11-18T14:03:00.566Z | 2024-11-22T14:22:31.731Z |
5546345 | 5546345 | 20241117102956_U3kJa | NZ003Q | 2024-11-18T14:02:53.783Z | 2024-11-22T14:22:31.240Z |
5544260 | 5544260 | 20241116091912_BDgje | NZ003Q | 2024-11-17T14:00:38.666Z | 2024-11-22T14:23:01.044Z |
5519997 | 5519997 | 20241111141408_vWhDI | NZ003Q | 2024-11-12T14:05:26.603Z | 2024-11-20T14:25:01.528Z |
5514463 | 5514463 | 20241110160743_6o25B | NZ003Q | 2024-11-11T14:06:42.612Z | 2024-11-19T14:21:48.847Z |
5514204 | 5514204 | 20241110150639_u5WZU | NZ003Q | 2024-11-11T14:06:20.361Z | 2024-11-19T14:21:44.857Z |
5514169 | 5514169 | 20241110145627_AoPiR | NZ003Q | 2024-11-11T14:06:17.993Z | 2024-11-19T14:21:44.613Z |
5508056 | 5508056 | 20241109135719_bQZSZ | NZ003Q | 2024-11-10T14:06:46.256Z | 2024-11-18T14:26:18.229Z |
5500428 | 5500428 | 20241108154202_SIVix | NZ003Q | 2024-11-09T14:06:16.065Z | 2024-11-17T14:23:22.564Z |
5500381 | 5500381 | 20241108153041_T3a2U | NZ003Q | 2024-11-09T14:06:11.828Z | 2024-11-17T14:23:22.377Z |
5500319 | 5500319 | 20241108151843_bycYs | NZ003Q | 2024-11-09T14:06:06.252Z | 2024-11-17T14:23:21.509Z |
5500280 | 5500280 | 20241108151056_QrFJv | NZ003Q | 2024-11-09T14:06:03.359Z | 2024-11-17T14:23:21.044Z |
5500275 | 5500275 | 20241108150938_cO16p | NZ003Q | 2024-11-09T14:06:02.824Z | 2024-11-17T14:23:21.025Z |
5500216 | 5500216 | 20241108150511_kHM37 | NZ003Q | 2024-11-09T14:05:59.242Z | 2024-11-17T14:23:20.203Z |
5500042 | 5500042 | 20241108143245_IyHQp | NZ003Q | 2024-11-09T14:05:34.356Z | 2024-11-17T14:23:18.226Z |
5500014 | 5500014 | 20241108142336_xlP9S | NZ003Q | 2024-11-09T14:05:30.005Z | 2024-11-17T14:23:17.971Z |
5499984 | 5499984 | 20241108141909_VdhTt | NZ003Q | 2024-11-09T14:05:27.351Z | 2024-11-17T14:23:17.863Z |
5499958 | 5499958 | 20241108141359_Hhidz | NZ003Q | 2024-11-09T14:05:24.025Z | 2024-11-17T14:23:17.602Z |
5499942 | 5499942 | 20241108141107_g0489 | NZ003Q | 2024-11-09T14:05:22.156Z | 2024-11-17T14:23:17.439Z |
5499916 | 5499916 | 20241108140146_81qPd | NZ003Q | 2024-11-09T14:05:19.421Z | 2024-11-17T14:23:17.138Z |
5499899 | 5499899 | 20241108135900_Dxrrk | NZ003Q | 2024-11-09T14:05:14.424Z | 2024-11-17T14:23:16.923Z |
5499836 | 5499836 | 20241108134410_kp0RQ | NZ003Q | 2024-11-09T14:05:02.877Z | 2024-11-17T14:23:16.363Z |
5499773 | 5499773 | 20241108132136_Fvfbc | NZ003Q | 2024-11-09T14:04:56.516Z | 2024-11-17T14:23:15.938Z |
5499655 | 5499655 | 20241108125219_rYIST | NZ003Q | 2024-11-09T14:04:34.640Z | 2024-11-17T14:23:14.198Z |
5498971 | 5498971 | 20241108103647_sdGPw | NZ003Q | 2024-11-09T14:02:53.429Z | 2024-11-17T14:23:02.882Z |
5498789 | 5498789 | 20241108095952_N32bO | NZ003Q | 2024-11-09T14:02:24.987Z | 2024-11-17T14:22:59.921Z |
5498586 | 5498586 | 20241108091412_wq2Ak | NZ003Q | 2024-11-09T14:01:52.735Z | 2024-11-17T14:22:58.108Z |
5498313 | 5498313 | 20241108080130_i45l2 | NZ003Q | 2024-11-09T14:01:07.223Z | 2024-11-17T14:22:52.792Z |
5494150 | 5494150 | 20241107160442_dPsDj | NZ003Q | 2024-11-08T14:05:26.474Z | 2024-11-16T14:27:48.578Z |
5494145 | 5494145 | 20241107160222_Gzird | NZ003Q | 2024-11-08T14:05:26.276Z | 2024-11-16T14:27:48.415Z |
5494096 | 5494096 | 20241107153437_MNWud | NZ003Q | 2024-11-08T14:05:22.259Z | 2024-11-16T14:27:46.871Z |
5487067 | 5487067 | 20241106143936_s8lN7 | NZ003Q | 2024-11-07T14:04:54.506Z | 2024-11-15T14:24:36.987Z |
5480564 | 5480564 | 20241105135558_Xsue2 | NZ003Q | 2024-11-06T14:05:55.878Z | 2024-11-14T14:23:04.861Z |
5480460 | 5480460 | 20241105130609_Gp1DK | NZ003Q | 2024-11-06T14:05:44.137Z | 2024-11-14T14:23:04.357Z |
5480365 | 5480365 | 20241105123643_NQhjh | NZ003Q | 2024-11-06T14:05:21.398Z | 2024-11-14T14:23:03.963Z |
5480354 | 5480354 | 20241105123212_uvKFs | NZ003Q | 2024-11-06T14:05:19.678Z | 2024-11-14T14:23:03.933Z |
5480237 | 5480237 | 20241105120528_tPNYn | NZ003Q | 2024-11-06T14:05:01.407Z | 2024-11-14T14:23:03.116Z |
5480218 | 5480218 | 20241105120335_C8dWY | NZ003Q | 2024-11-06T14:04:59.025Z | 2024-11-14T14:23:03.103Z |
5479891 | 5479891 | 20241105105649_uO2vR | NZ003Q | 2024-11-06T14:03:49.890Z | 2024-11-14T14:23:00.877Z |
5479880 | 5479880 | 20241105105544_i82nk | NZ003Q | 2024-11-06T14:03:48.524Z | 2024-11-14T14:23:00.850Z |
5479827 | 5479827 | 20241105104743_HZuWr | NZ003Q | 2024-11-06T14:03:41.158Z | 2024-11-14T14:23:00.779Z |
5479811 | 5479811 | 20241105104352_InmPh | NZ003Q | 2024-11-06T14:03:38.326Z | 2024-11-14T14:23:00.713Z |
5479675 | 5479675 | 20241105101733_tzPXJ | NZ003Q | 2024-11-06T14:03:03.770Z | 2024-11-14T14:23:00.095Z |
5479573 | 5479573 | 20241105095903_qRnYW | NZ003Q | 2024-11-06T14:02:47.910Z | 2024-11-14T14:22:59.384Z |
5479278 | 5479278 | 20241105085642_yi44b | NZ003Q | 2024-11-06T14:01:43.852Z | 2024-11-14T14:22:58.207Z |
5473674 | 5473674 | 20241103144849_69QHJ | NZ003Q | 2024-11-05T14:09:22.662Z | 2024-11-12T14:27:49.873Z |
5473627 | 5473627 | 20241103144152_f7wAz | NZ003Q | 2024-11-05T14:09:14.079Z | 2024-11-12T14:27:49.811Z |
5473512 | 5473512 | 20241103142750_srWhU | NZ003Q | 2024-11-05T14:09:03.146Z | 2024-11-12T14:27:49.679Z |
5473322 | 5473322 | 20241103140102_ShFyZ | NZ003Q | 2024-11-05T14:08:47.907Z | 2024-11-12T14:27:48.549Z |
5473224 | 5473224 | 20241103134634_oWfHo | NZ003Q | 2024-11-05T14:08:38.473Z | 2024-11-12T14:27:48.270Z |
5473123 | 5473123 | 20241103133004_19Kl9 | NZ003Q | 2024-11-05T14:08:19.921Z | 2024-11-12T14:27:47.977Z |
5473008 | 5473008 | 20241103131430_3e1M2 | NZ003Q | 2024-11-05T14:08:03.124Z | 2024-11-12T14:27:47.567Z |
5472965 | 5472965 | 20241103130540_5P0p4 | NZ003Q | 2024-11-05T14:07:55.442Z | 2024-11-12T14:27:47.426Z |
5472866 | 5472866 | 20241103125435_JcItz | NZ003Q | 2024-11-05T14:07:48.602Z | 2024-11-12T14:27:46.828Z |
5472838 | 5472838 | 20241103125045_BsD5w | NZ003Q | 2024-11-05T14:07:46.849Z | 2024-11-12T14:27:46.798Z |
5472819 | 5472819 | 20241103124846_cadF3 | NZ003Q | 2024-11-05T14:07:45.540Z | 2024-11-12T14:27:46.778Z |
5472710 | 5472710 | 20241103122646_4lVh8 | NZ003Q | 2024-11-05T14:07:34.577Z | 2024-11-12T14:27:46.384Z |
5472622 | 5472622 | 20241104155946_0gXgR | NZ003Q | 2024-11-05T14:06:20.542Z | 2024-11-13T14:27:26.556Z |
5472571 | 5472571 | 20241104154610_cIB3k | NZ003Q | 2024-11-05T14:06:16.347Z | 2024-11-13T14:27:26.488Z |
5472556 | 5472556 | 20241104154437_ENPqF | NZ003Q | 2024-11-05T14:06:13.531Z | 2024-11-13T14:27:26.468Z |
5472520 | 5472520 | 20241104153257_c20vN | NZ003Q | 2024-11-05T14:06:03.180Z | 2024-11-13T14:27:26.402Z |
5472488 | 5472488 | 20241104152100_ozwZL | NZ003Q | 2024-11-05T14:05:57.099Z | 2024-11-13T14:27:26.363Z |
5472388 | 5472388 | 20241104145626_vZ0FY | NZ003Q | 2024-11-05T14:05:44.232Z | 2024-11-13T14:27:26.236Z |
5472382 | 5472382 | 20241104145342_iivJJ | NZ003Q | 2024-11-05T14:05:43.682Z | 2024-11-13T14:27:26.229Z |
5472336 | 5472336 | 20241104144025_oN2Ia | NZ003Q | 2024-11-05T14:05:39.450Z | 2024-11-13T14:27:26.165Z |
5472303 | 5472303 | 20241104143453_AfCXH | NZ003Q | 2024-11-05T14:05:36.306Z | 2024-11-13T14:27:26.121Z |
5472164 | 5472164 | 20241104135805_Jmi7y | NZ003Q | 2024-11-05T14:05:20.785Z | 2024-11-13T14:27:25.813Z |
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);