names

16 rows where case_id = 2195490

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4483336 2195490 2195490 plaintiff (not given)   freeman of the port of Northampton   Northampton, freeman of the port of, on their own account 0
4483337 2195490 2195490 defendant Denes John   599957 599957 Denes, John, of Sprotton 0
4483338 2195490 2195490 defendant Syward John   636398 636398 with Syward, John, of Hanslap 1
4483339 2195490 2195490 defendant Wilham John     Wilham, John 2
4483340 2195490 2195490 defendant Mason Roger mercer 761962 761962 Mason, Roger, of Kyngesclyf, mercer 3
4483341 2195490 2195490 defendant Baill John   594214 594214 Baill, John, of Stoke Goldyngton 4
4483342 2195490 2195490 defendant Chaloner Hugh   586848 586848 Chaloner, Hugh, of Northampton 5
4483343 2195490 2195490 defendant Chalone Thomas     Chalone, Thomas 6
4483344 2195490 2195490 defendant Baker Simon   586848 586848 Baker, Simon, of Northampton 7
4483345 2195490 2195490 defendant Stryngger Roger   586848 586848 Stryngger, Roger, of Northampton 8
4483346 2195490 2195490 defendant Dallyng John   761963 761963 Dallyng, John, of Colyntrogh 9
4483347 2195490 2195490 defendant agge Lake Robert   588037 588037 agge Lake, Robert, of Lichefeld 10
4483348 2195490 2195490 defendant Holdwell Thomas   756729 756729 Holdwell, Thomas, of Byllyng 11
4483349 2195490 2195490 defendant Gos John   761964 761964 Gos, John, of Barton Yerles 12
4483350 2195490 2195490 defendant Keresle John     Keresle, John 13
4483351 2195490 2195490 defendant Bate Robert   599957 599957 Bate, Robert, of Sprotton 14

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);