names

27 rows where place_id = 756923

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4441455 2182267 2182267 defendant Cranwell John de   756923 756923 Cranwell, John de, of Billesfeld 2
4471000 2191584 2191584 defendant Spryng Richard   756923 756923 Spryng, Richard, of Billesfeld 0
4563374 2220117 2220117 defendant Dey John   756923 756923 Dey, John, of Billesfeld 2
4624539 2238656 2238656 plaintiff Norby Thomas   756923 756923 Norby, Thomas, of Billesfeld 0
4624541 2238657 2238657 plaintiff Norby Thomas   756923 756923 Norby, Thomas, of Billesfeld 0
4624543 2238658 2238658 plaintiff Norby Thomas   756923 756923 Norby, Thomas, of Billesfeld 0
4694030 2263639 2263639 defendant Toly Robert laborer 756923 756923 Toly, Robert, of Billesfeld, laborer 0
4816065 2301116 2301116 defendant Tolle Nicholas husbandman 756923 756923 Tolle, Nicholas, of Billesfeld, husbandman 0
4817247 2301486 2301486 defendant Asselyn John ostler 756923 756923 Asselyn, John, of Billesfeld, ostler 0
4826001 2304167 2304167 defendant Asselyn John husbandman 756923 756923 Asselyn, John, of Billesfeld, husbandman 0
4845544 2310116 2310116 defendant Asselyn John ostler 756923 756923 Asselyn, John, of Billesfeld, ostler 5
4865169 2316081 2316081 defendant Makaunter John butcher 756923 756923 Makaunter, John, of Billesfeld, butcher 4
4870839 2317857 2317857 defendant Makaunter John butcher 756923 756923 Makaunter, John, of Billesfeld, butcher 2
4884706 2322124 2322124 defendant Howet John husbandman 756923 756923 Howet, John, of Billesfeld, husbandman 16
4891179 2323974 2323974 defendant Howet John husbandman 756923 756923 Howet, John, of Billesfeld, husbandman 17
4919103 2332488 2332488 defendant Astelon John husbandman 756923 756923 Astelon, John, of Billesfeld, husbandman 0
4944992 2340423 2340423 defendant Wryght Henry   756923 756923 Wryght, Henry, of Billesfeld, wright 0
4948053 2341368 2341368 defendant Makeaunter John butcher 756923 756923 Makeaunter, John, of Billesfeld, butcher 2
5108121 2388814 2388814 defendant Hewet John   756923 756923 Hewet, John, of Billesfeld, Lincs, proctor 3
5108126 2388815 2388815 defendant Howet John   756923 756923 Howet, John, of Billesfeld, Lincs, proctor 3
5108242 2388843 2388843 defendant Armstronge Christopher husbandman 756923 756923 Armstronge, Christopher, of Billesfeld, husbandman 0
5109788 2389292 2389292 defendant Hewet John husbandman 756923 756923 Hewet, John, of Billesfeld, husbandman 1
5116491 2391255 2391255 defendant Hewette John yeoman 756923 756923 Hewette, John, of Billesfeld, yeoman 0
5116494 2391256 2391256 defendant Hewette John yeoman 756923 756923 Hewette, John, of Billesfeld, yeoman 0
5297450 2444256 2444256 defendant Obyn William   756923 756923 Obyn, William, of Billesfeld 0
5616135 2548840 2548840 defendant Oundell John de   756923 756923 Oundell, John de, of Billesfeld 9
5630870 2553663 2553663 defendant Bell John butcher 756923 756923 Bell, John, of Billesfeld, butcher 0

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);