names

43 rows where place_id = 621963

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3744465 1940172 1940172 defendant Ballard Richard husbandman 621963 621963 Ballard, Richard, of Elmeswell, husbandman 0
3774041 1949597 1949597 defendant Ballard Richard husbandman 621963 621963 Ballard, Richard, of Elmeswell, husbandman 0
3833081 1968271 1968271 defendant Bugge alias Gronger Thomas husbandman 621963 621963 Bugge alias Gronger, Thomas, of Elmeswell, husbandman 0
3953340 2008237 2008237 defendant Wyther Richard miller 621963 621963 Wyther, Richard, of Elmeswell, miller 0
4047942 2041710 2041710 defendant Jennyck John yeoman 621963 621963 Jennyck, John, of Elmeswell, yeoman 0
4072836 2050583 2050583 defendant Harrys Gilbert yeoman 621963 621963 Harrys, Gilbert, of Elmeswell, yeoman 2
4111915 2064509 2064509 defendant Fyske Simon yeoman 621963 621963 Fyske, Simon, of Elmeswell, yeoman 1
4121861 2068116 2068116 defendant Fiske Simon yeoman 621963 621963 Fiske, Simon, of Elmeswell, yeoman 0
4204782 2097218 2097218 defendant Harrys Gilbert carpenter 621963 621963 Harrys, Gilbert, of Elmeswell, carpenter 0
4242219 2110391 2110391 defendant Roo Robert   621963 621963 Roo, Robert, of Elmeswell, wheelwright 0
4242220 2110391 2110391 defendant Jermyn Giles butcher 621963 621963 Jermyn, Giles, of Elmeswell, butcher 1
4247562 2112171 2112171 defendant Woodwarde John laborer 621963 621963 Woodwarde, John, of Elmeswell, laborer 4
4247563 2112171 2112171 defendant Harte Thomas carpenter 621963 621963 Harte, Thomas, of Elmeswell, carpenter 5
4369441 2154130 2154130 defendant Kettleborough John gent 621963 621963 Kettleborough, John, of Elmeswell, gent 0
4411099 2168299 2168299 defendant Muskett Henry husbandman 621963 621963 Muskett, Henry, of Elmeswell, husbandman 1
4470496 2191418 2191418 defendant Kyrton Gilbert   621963 621963 Kyrton, Gilbert, of Elmeswell 0
4692620 2263208 2263208 defendant Shropham John chaplain 621963 621963 Shropham, John, of Elmeswell, chaplain 4
4724390 2272925 2272925 defendant Housom John   621963 621963 Housom, John, of Elmeswell, franklin 1
4724391 2272925 2272925 defendant Burnbut John yeoman 621963 621963 Burnbut, John, of Elmeswell, yeoman 2
4740335 2277683 2277683 defendant Hebbys John husbandman 621963 621963 Hebbys, John, of Elmeswell, husbandman 3
4747779 2279857 2279857 defendant Howeson William gent 621963 621963 Howeson, William, of Elmeswell, gent 7
4747780 2279857 2279857 defendant Burnebuttes John yeoman 621963 621963 Burnebuttes, John, of Elmeswell, yeoman 8
4752662 2281239 2281239 defendant Jotson John laborer 621963 621963 Jotson, John, of Elmeswell, laborer 3
4764570 2284906 2284906 defendant Chambirleyn William husbandman 621963 621963 Chambirleyn, William, of Elmeswell, husbandman 0
4776371 2288602 2288602 defendant Cros Isabel widow 621963 621963 Cros, Isabel, of Elmeswell, widow 0
5013414 2360757 2360757 defendant Hert John yeoman 621963 621963 Hert, John, of Elmeswell, yeoman 3
5055717 2373278 2373278 defendant Palmere William husbandman 621963 621963 Palmere, William, of Elmeswell, husbandman 4
5118321 2391794 2391794 plaintiff Hel John   621963 621963 Hel, John, of Elmeswell 2
5197545 2415020 2415020 defendant Geldegelt Simon yeoman 621963 621963 Geldegelt, Simon, of Elmeswell, yeoman 1
5224562 2422852 2422852 defendant Bacheler Michael carver 621963 621963 Bacheler, Michael, of Elmeswell, carver 1
5224566 2422853 2422853 defendant Bacheler Michael carver 621963 621963 Bacheler, Michael, of Elmeswell, carver 1
5376419 2468222 2468222 defendant Tylle John   621963 621963 Tylle, John, of Elmeswell, mason 0
5382637 2470092 2470092 defendant Tylle John   621963 621963 Tylle, John, of Elmeswell, mason 0
5382785 2470141 2470141 defendant Wryght Robert husbandman 621963 621963 Wryght, Robert, of Elmeswell, husbandman 3
5392645 2472962 2472962 defendant Tylle John   621963 621963 Tylle, John, of Elmeswell, mason 0
5393355 2473155 2473155 defendant Wryght Robert husbandman 621963 621963 Wryght, Robert, of Elmeswell, husbandman 5
5396066 2473962 2473962 defendant Johnson Hamo husbandman 621963 621963 Johnson, Hamo, of Elmeswell, husbandman 1
5405702 2476706 2476706 defendant Tylle John   621963 621963 Tylle, John, of Elmeswell, mason 0
5406543 2476940 2476940 defendant Wryght Robert husbandman 621963 621963 Wryght, Robert, of Elmeswell, husbandman 5
5409356 2477770 2477770 defendant Johnson Hammond husbandman 621963 621963 Johnson, Hammond, of Elmeswell, husbandman 1
5419655 2480796 2480796 defendant Wryght Robert husbandman 621963 621963 Wryght, Robert, of Elmeswell, husbandman 0
5422882 2481801 2481801 defendant Johnson Hamond husbandman 621963 621963 Johnson, Hamond, of Elmeswell, husbandman 1
5514508 2509384 2509384 defendant Elsegood Thomas yeoman 621963 621963 Elsegood, Thomas, of Elmeswell, yeoman 4

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