names

26 rows where place_id = 720099

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4049481 2042259 2042259 plaintiff Tyssdall John (legal representative) 720099 720099 Tyssdall, John, of Tydd St Giles, yeoman, executor of 0
4232995 2107047 2107047 defendant Cockerill Nicholas husbandman 720099 720099 Cockerill, Nicholas, of Tydd St Giles, husbandman 3
4235830 2108104 2108104 defendant Cockerill Nicholas husbandman 720099 720099 Cockerill, Nicholas, of Tydd St Giles, husbandman 1
4235831 2108104 2108104 defendant Odam John husbandman 720099 720099 Odam, John, of Tydd St Giles, husbandman 2
4241636 2110188 2110188 defendant Cockerill Nicholas husbandman 720099 720099 Cockerill, Nicholas, of Tydd St Giles, husbandman 3
4244464 2111127 2111127 defendant Lovett Christopher husbandman 720099 720099 Lovett, Christopher, of Tydd St Giles, husbandman 1
4244465 2111127 2111127 defendant Cockerill Nicholas husbandman 720099 720099 Cockerill, Nicholas, of Tydd St Giles, husbandman 2
4244466 2111127 2111127 defendant Odam John husbandman 720099 720099 Odam, John, of Tydd St Giles, husbandman 3
4299430 2129887 2129887 defendant Waygate William yeoman 720099 720099 Waygate, William, of Tydd St Giles, yeoman 0
4339719 2143665 2143665 defendant Walker Thomas yeoman 720099 720099 Walker, Thomas, of Tydd St Giles, yeoman 1
4339720 2143665 2143665 defendant Lovett Robert husbandman 720099 720099 Lovett, Robert, of Tydd St Giles, husbandman 2
4339721 2143665 2143665 defendant Steede Baldwin husbandman 720099 720099 Steede, Baldwin, of Tydd St Giles, husbandman 3
4340472 2143934 2143934 defendant Martyn Clement clerk 720099 720099 Martyn, Clement, of Tydd St Giles, clerk 1
4354598 2148843 2148843 defendant Wortley Thomas yeoman 720099 720099 Wortley, Thomas, of Tydd St Giles, yeoman 2
4718771 2271213 2271213 defendant atte Brygge Geoffrey   720099 720099 atte Brygge, Geoffrey, of Tydd St Giles, yeoman, son of Thomas 2
4918823 2332399 2332399 defendant Brewestere John husbandman 720099 720099 Brewestere, John, of tydd St Giles, husbandman 0
4941099 2339238 2339238 defendant Wyteratt Thomas yeoman 720099 720099 Wyteratt, Thomas, of Tydd St Giles, yeoman 0
4941100 2339238 2339238 defendant Wyteratt Simon yeoman 720099 720099 Wyteratt, Simon, of Tydd St Giles, yeoman 1
4941101 2339238 2339238 defendant Wyteratt John yeoman 720099 720099 Wyteratt, John, of Tydd St Giles, yeoman 2
5035618 2367275 2367275 defendant Teryngton John husbandman 720099 720099 Teryngton, John, of Tydd St Giles, husbandman 1
5315139 2449585 2449585 plaintiff Clerk William   720099 720099 Clerk, William, of Tydd St Giles 0
5315145 2449586 2449586 defendant Hunston Thomas husbandman 720099 720099 Hunston, Thomas, of Tydd St Giles, husbandman 0
5315146 2449586 2449586 defendant Chamberleyn Philip husbandman 720099 720099 Chamberleyn, Philip, of Tydd St Giles, husbandman 1
5315148 2449586 2449586 defendant Fyssher William tailor 720099 720099 Fyssher, William, of Tydd St Giles, tailor 3
5327111 2453186 2453186 plaintiff Thurston John   720099 720099 Thurston, John, of Tydd St Giles 0
5386879 2471310 2471310 defendant Watson William husbandman 720099 720099 Watson, William, of Tydd St Giles, husbandman 1

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