names

28 rows where place_id = 608397

✎ 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
3673533 1917748 1917748 defendant Skarpe John husbandman 608397 608397 Skarpe, John, of orton, husbandman 3
3929443 2000192 2000192 plaintiff Byrkbankes William yeoman 608397 608397 Byrkbankes, William, of Orton, yeoman 0
3944414 2005146 2005146 defendant Blande Robert yeoman 608397 608397 Blande, Robert, of Orton, yeoman 0
3951622 2007621 2007621 defendant Hydley John gent 608397 608397 Hydley, John, of Orton, gent 0
3966543 2012930 2012930 defendant Orton John husbandman 608397 608397 Orton, John, of Orton, husbandman 1
3973265 2015223 2015223 defendant Hydley John gent 608397 608397 Hydley, John, of Orton, gent 1
4039221 2038653 2038653 defendant Hydley John yeoman 608397 608397 Hydley, John, of Orton, yeoman 0
4039223 2038654 2038654 defendant Hydley John yeoman 608397 608397 Hydley, John, of Orton, yeoman 0
4239235 2109346 2109346 defendant Kerke Richard husbandman 608397 608397 Kerke, Richard, of Orton, husbandman 0
4240508 2109808 2109808 defendant Cox John blacksmith 608397 608397 Cox, John, of Orton, blacksmith 0
4261388 2116774 2116774 defendant Kerke Richard husbandman 608397 608397 Kerke, Richard, of Orton, husbandman 0
4345193 2145593 2145593 defendant Whytehead Richard, junior carpenter 608397 608397 Whytehead, Richard, junior, of Orton, carpenter 3
4360812 2151033 2151033 defendant Arnold George laborer 608397 608397 Arnold, George, of Orton, laborer 1
4377149 2156901 2156901 defendant Hopwood Thomas laborer 608397 608397 Hopwood, Thomas, of Orton, laborer 0
4391049 2161624 2161624 defendant Byrtynshawe Robert yeoman 608397 608397 Byrtynshawe, Robert, of Orton, Manchester, yeoman 1
4398788 2164176 2164176 defendant Lea Francis yeoman 608397 608397 Lea, Francis, of Orton, yeoman 1
4640275 2243272 2243272 defendant Broun John   608397 608397 Broun, John, of Orton 2
4732193 2275248 2275248 defendant Falder Richard yeoman 608397 608397 Falder, Richard, of Orton, yeoman 6
4858876 2314153 2314153 defendant Moy Joan   608397 608397 Moy, Joan, of Orton, widow of Moy, John 0
4858877 2314153 2314153 defendant Moy John laborer 608397 608397 Moy, John, of Orton, laborer 1
5057678 2373862 2373862 plaintiff Cook John   608397 608397 Cook, John, of Orton 0
5097520 2385706 2385706 defendant Thornburgh Thomas gent 608397 608397 Thornburgh, Thomas, of Orton, gent 0
5223408 2422539 2422539 defendant Nykson William husbandman 608397 608397 Nykson, William, of Orton, husbandman 0
5223409 2422539 2422539 defendant Sclatear Henry husbandman 608397 608397 Sclatear, Henry, of Orton, husbandman 1
5528444 2513431 2513431 defendant Grene John husbandman 608397 608397 Grene, John, of Orton, husbandman 3
5599966 2534870 2534870 defendant Heryng Henry husbandman 608397 608397 Heryng, Henry, of Orton, husbandman 2
5627881 2552689 2552689 plaintiff Rogerson Thomas   608397 608397 Rogerson, Thomas, of Orton 1
5627882 2552689 2552689 plaintiff Milner John   608397 608397 Milner, John, of Orton 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);