names

28 rows where place_id = 609098

✎ 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
3652626 1911157 1911157 defendant Stylle Thomas   609098 609098 Stylle, Thomas, of Maidston, mason 2
3677011 1918848 1918848 defendant Kyng William tailor 609098 609098 Kyng, William, of Maidston, tailor 0
3677221 1918920 1918920 defendant Kyng William tailor 609098 609098 Kyng, William, of Maidston, tailor 0
3766677 1947239 1947239 defendant A- John yeoman 609098 609098 A-, John, of Maidston, yeoman 4
3827239 1966386 1966386 plaintiff Borham David   609098 609098 Borham, David, of Maidston, millwright 0
3890020 1986899 1986899 plaintiff Harper John smith 609098 609098 Harper, John, of Maidston, smith 0
4223539 2103723 2103723 defendant Wilson Christopher shoemaker 609098 609098 Wilson, Christopher, of Maidston, shoemaker 2
4227180 2104985 2104985 defendant Tayler Thomas yeoman 609098 609098 Tayler, Thomas, of Maidston, yeoman 0
4320141 2137146 2137146 defendant Barnes William yeoman 609098 609098 Barnes, William, of Maidston, yeoman 1
4320142 2137146 2137146 defendant Rowse Francis   609098 609098 Rowse, Francis, of Maidston, mason 2
4381996 2158664 2158664 defendant Barfott John yeoman 609098 609098 Barfott, John, of Maidston, yeoman 1
4499172 2200387 2200387 plaintiff Grove John   609098 609098 Grove, John, of Maidston 0
4644092 2244370 2244370 defendant Gerowede (illegible)   609098 609098 Gerowede, _, of Maidston 2
4670797 2256546 2256546 defendant Estwell Thomas laborer 609098 609098 Estwell, Thomas, of Maidston, laborer 3
4683348 2260396 2260396 defendant Wyke Alice widow 609098 609098 Wyke, Alice, of Maidston, widow 0
4684403 2260729 2260729 defendant Hewe Simon fuller 609098 609098 Hewe, Simon, of Maidston, fuller 0
4759359 2283269 2283269 defendant Saberne John yeoman 609098 609098 Saberne, John, of Maidston, yeoman 1
4914905 2331171 2331171 defendant Glover Thomas baker 609098 609098 Glover, Thomas, of Maidston, baker 0
4961240 2345328 2345328 defendant Gyles Robert barber 609098 609098 Gyles, Robert, of Maidston, barber 0
5126286 2394171 2394171 defendant Walter Thomas dyer 609098 609098 Walter, Thomas, of Maidston, dyer 3
5141524 2398637 2398637 defendant Ropkyn Roger weaver 609098 609098 Ropkyn, Roger, of Maidston, weaver 0
5312849 2448874 2448874 defendant Snelgore Thomas yeoman 609098 609098 Snelgore, Thomas, of Maidston, yeoman 0
5312850 2448874 2448874 defendant Mauntell Edmund yeoman 609098 609098 Mauntell, Edmund, of Maidston, yeoman 1
5366173 2465082 2465082 defendant Welford Henry yeoman 609098 609098 Welford, Henry, of Maidston, yeoman 8
5399552 2474952 2474952 defendant Smyth Joan widow 609098 609098 Smyth, Joan, of Maidston, widow 3
5405011 2476512 2476512 defendant Shaylys Alice widow 609098 609098 Shaylys, Alice, of Maidston, widow 1
5563145 2523816 2523816 defendant Burden William husbandman 609098 609098 Burden, William, of Maidston, husbandman 0
5563147 2523817 2523817 defendant Burden William husbandman 609098 609098 Burden, William, of Maidston, husbandman 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);