names

34 rows where place_id = 807813

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4822477 2303102 2303102 defendant Sergeaunt William butcher 807813 807813 Sergeaunt, William, of Makesey, butcher 0
4823964 2303570 2303570 defendant Brewester Roger husbandman 807813 807813 Brewester, Roger, of Makesey, husbandman 0
4873503 2318670 2318670 defendant Hay John husbandman 807813 807813 Hay, John, of Makesey, husbandman 0
4873504 2318670 2318670 defendant Taillour John   807813 807813 together with Taillour, John, of Makesey, servant 1
4873505 2318670 2318670 defendant Killam John husbandman 807813 807813 Killam, John, of Makesey, husbandman 2
4873506 2318670 2318670 defendant Palmys Robert husbandman 807813 807813 Palmys, Robert, of Makesey, husbandman 3
4873507 2318670 2318670 defendant Burton Henry yeoman 807813 807813 Burton, Henry, of Makesey, yeoman 4
4873508 2318670 2318670 defendant Clerk William husbandman 807813 807813 Clerk, William, of Makesey, husbandman 5
4873509 2318670 2318670 defendant Rogger Stephen husbandman 807813 807813 Rogger, Stephen, of Makesey, husbandman 6
4873514 2318670 2318670 defendant Parmenter John   807813 807813 Parmenter, John, of Makesey, wright 11
4873533 2318673 2318673 defendant Taillour John   807813 807813 Taillour, John, of Makesey, servant 0
4873534 2318673 2318673 defendant Killam John husbandman 807813 807813 Killam, John, of Makesey, husbandman 1
4873535 2318673 2318673 defendant Palmys Robert husbandman 807813 807813 Palmys, Robert, of Makesey, husbandman 2
4873536 2318673 2318673 defendant Burton Henry yeoman 807813 807813 Burton, Henry, of Makesey, yeoman 3
4873537 2318673 2318673 defendant Clerk William husbandman 807813 807813 Clerk, William, of Makesey, husbandman 4
4873538 2318673 2318673 defendant Rogger Stephen husbandman 807813 807813 Rogger, Stephen, of Makesey, husbandman 5
4873543 2318673 2318673 defendant Parmenter John   807813 807813 Parmenter, John, of Makesey, wright 10
4873544 2318673 2318673 defendant Hay John husbandman 807813 807813 together with Hay, John, of Makesey, husbandman 11
5039221 2368372 2368372 defendant Hareby Simon esq 807813 807813 Hareby, Simon, of Makesey, esq 0
5053774 2372729 2372729 defendant Hareby Simon esq 807813 807813 Hareby, Simon, of Makesey, esq 0
5076772 2379553 2379553 defendant Hareby Simon esq 807813 807813 Hareby, Simon, of Makesey, esq 0
5102072 2387029 2387029 defendant Hareby Simon esq 807813 807813 Hareby, Simon, of Makesey, esq 0
5125744 2394012 2394012 defendant Hareby Simon esq 807813 807813 Hareby, Simon, of Makesey, esq 0
5157873 2403429 2403429 defendant Bacon Thomas chaplain 807813 807813 Bacon, Thomas, of Makesey, chaplain 0
5157875 2403430 2403430 defendant Bacon Thomas chaplain 807813 807813 Bacon, Thomas, of Makesey, chaplain 0
5160632 2404205 2404205 defendant Hareby Simon esq 807813 807813 Hareby, Simon, of Makesey, esq 0
5173622 2407986 2407986 defendant Bacon Thomas chaplain 807813 807813 Bacon, Thomas, of Makesey, chaplain 0
5175384 2408490 2408490 defendant Hareby Simon esq 807813 807813 Hareby, Simon, of Makesey, esq 0
5193683 2413881 2413881 defendant Bacon Thomas chaplain 807813 807813 Bacon, Thomas, of Makesey, chaplain 0
5196555 2414745 2414745 defendant Hareby Simon esq 807813 807813 Hareby, Simon, of Makesey, esq 0
5209689 2418574 2418574 defendant Hareby Simon   807813 807813 Hareby, Simon, of Makesey 0
5244445 2428559 2428559 defendant Graunt John husbandman 807813 807813 Graunt, John, of Makesey, husbandman 0
5244446 2428559 2428559 defendant Squyer Robert husbandman 807813 807813 Squyer, Robert, of Makesey, husbandman 1
5244447 2428559 2428559 defendant Alye John, junior husbandman 807813 807813 Alye, John, junior, of Makesey, husbandman 2

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