names

23 rows where place_id = 592890

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609291 1870564 1870564 defendant Grone or Grove John husbandman 592890 592890 Grone or Grove, John, of White Waltham, Berks, husbandman 0
3669737 1916481 1916481 defendant Grove John yeoman 592890 592890 Grove, John, of White Waltham, Berks, yeoman 0
3679131 1919541 1919541 defendant Grove John   592890 592890 Grove, John, of White Waltham, Berks, wood monger 0
3679154 1919547 1919547 defendant Grove John yeoman 592890 592890 Grove, John, of White Waltham, Berks, yeoman 0
3679157 1919548 1919548 defendant Grove John yeoman 592890 592890 Grove, John, of White Waltham, Berks, yeoman 0
3771083 1948645 1948645 defendant Grove Richard, junior husbandman 592890 592890 Grove, Richard, junior, of White Waltham, Berks, husbandman 2
3800291 1958012 1958012 defendant Grove Richard husbandman 592890 592890 Grove, Richard, of White Waltham, Berks, husbandman 2
4030834 2035692 2035692 defendant Cowper Thomas yeoman 592890 592890 Cowper, Thomas, of White Waltham, Berks, yeoman 1
4032160 2036171 2036171 defendant Cowper Thomas gent 592890 592890 Cowper, Thomas, of White Waltham, Berks, gent 0
4048093 2041753 2041753 defendant Grove John gent 592890 592890 Grove, John, of White Waltham, Berks, gent 0
4823717 2303507 2303507 defendant Everard Henry husbandman 592890 592890 Everard, Henry, of White Waltham, Berks, husbandman 0
4983120 2351854 2351854 defendant Grove William   592890 592890 Grove, William, of White Waltham, Berks, franklin 5
5136300 2397135 2397135 defendant Grove William husbandman 592890 592890 Grove, William, of White Waltham, Berks, husbandman 0
5156650 2403100 2403100 defendant Grove William husbandman 592890 592890 Grove, William, of White Waltham, Berks, husbandman 0
5357128 2462293 2462293 defendant Grove William yeoman 592890 592890 Grove, William, of White Waltham, Berks, yeoman 0
5390695 2472401 2472401 defendant Boweyer Thomas yeoman 592890 592890 Boweyer, Thomas, of White Waltham, Berks, yeoman 7
5418951 2480592 2480592 defendant Grove John husbandman 592890 592890 Grove, John, of White Waltham, Berks, husbandman 2
5451044 2490204 2490204 defendant (illegible) John husbandman 592890 592890 _, John, of White Waltham, Berks, husbandman 1
5464305 2494230 2494230 defendant Grove John husbandman 592890 592890 Grove, John, of White Waltham, Berks, husbandman 0
5464474 2494295 2494295 defendant Grove John husbandman 592890 592890 Grove, John, of White Waltham, Berks, husbandman 1
5464477 2494296 2494296 defendant Grove John husbandman 592890 592890 Grove, John, of White Waltham, Berks, husbandman 1
5519249 2510866 2510866 defendant Porter Thomas smith 592890 592890 Porter, Thomas, of White Waltham, Berks, smith 0
5577141 2527899 2527899 defendant Grove John, junior yeoman 592890 592890 Grove, John, junior, of White Waltham, Berks, yeoman 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);