names

38 rows where place_id = 601482

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645553 1909005 1909005 defendant Blether John husbandman 601482 601482 Blether, John, of Preston on Wye, husbandman 4
3830984 1967574 1967574 defendant Garnans John yeoman 601482 601482 Garnans, John, of Preston on Wye, yeoman 1
3831645 1967794 1967794 defendant Bagge John husbandman 601482 601482 Bagge, John, of Preston on Wye, husbandman 0
3839974 1970430 1970430 defendant Bagge John husbandman 601482 601482 Bagge, John, of Preston on Wye, husbandman 1
4001061 2025155 2025155 defendant Colcombe Richard husbandman 601482 601482 Colcombe, Richard, of Preston on Wye, husbandman 0
4001097 2025172 2025172 plaintiff Gytto John   601482 601482 Gytto, John, of Preston on Wye tanner 0
4001101 2025173 2025173 plaintiff Gytto John   601482 601482 Gytto, John, of Preston on Wye tanner 0
4001103 2025174 2025174 plaintiff Gytto John tanner 601482 601482 Gytto, John, of Preston on Wye, tanner 0
4008511 2027812 2027812 defendant Powton William yeoman 601482 601482 Powton, William, of Preston on Wye, yeoman 1
4098027 2059624 2059624 defendant Hyde Thomas yeoman 601482 601482 Hyde, Thomas, of Preston on Wye, yeoman 0
4098028 2059624 2059624 defendant Hyde John yeoman 601482 601482 Hyde, John, of Preston on Wye, yeoman 1
4116950 2066359 2066359 defendant Prise Richard yeoman 601482 601482 Prise, Richard, of Preston on Wye, yeoman 0
4170294 2085103 2085103 defendant Heynes Walter husbandman 601482 601482 Heynes, Walter, of Preston on Wye, husbandman 0
4171842 2085611 2085611 defendant Grene Eleanor widow 601482 601482 Grene, Eleanor, of Preston on Wye, widow 0
4171843 2085611 2085611 defendant Prosser David husbandman 601482 601482 Prosser, David, of Preston on Wye, husbandman 1
4173184 2086078 2086078 defendant Haynes Walter husbandman 601482 601482 Haynes, Walter, of Preston on Wye, husbandman 0
4194974 2093805 2093805 defendant Grene Eleanor widow 601482 601482 Grene, Eleanor, of Preston on Wye, widow 0
4194975 2093805 2093805 defendant Prosser David husbandman 601482 601482 Prosser, David, of Preston on Wye, husbandman 1
4230822 2106278 2106278 defendant Knyghte Philip yeoman 601482 601482 Knyghte, Philip, of Preston on Wye, yeoman 0
4237615 2108747 2108747 defendant Parler Philip smith 601482 601482 Parler, Philip, of Preston on Wye, or of Plowfeeld Greene, smith 0
4241716 2110216 2110216 defendant Pyers Thomas yeoman 601482 601482 Pyers, Thomas, of Preston on Wye, yeoman 0
4243287 2110745 2110745 defendant Price Richard yeoman 601482 601482 Price, Richard, of Preston on Wye, yeoman 2
4265055 2117949 2117949 defendant Pearse Thomas yeoman 601482 601482 Pearse, Thomas, of Preston on Wye, yeoman 0
4296480 2128842 2128842 defendant Harryes alias Penner Richard yeoman 601482 601482 Harryes alias Penner, Richard, of Preston on Wye, yeoman 0
4296482 2128843 2128843 defendant Harryes alias Penry Richard yeoman 601482 601482 Harryes alias Penry, Richard, of Preston on Wye, yeoman 0
4305926 2132211 2132211 defendant Webbe John husbandman 601482 601482 Webbe, John, of Preston on Wye, husbandman 1
4326470 2139215 2139215 defendant John David husbandman 601482 601482 John, David, of Preston on Wye, husbandman 1
4361867 2151405 2151405 defendant Cocke Thomas yeoman 601482 601482 Cocke, Thomas, of Preston on Wye, or of Monyngton Stadle, yeoman 2
4376333 2156605 2156605 defendant Bulcott John yeoman 601482 601482 Bulcott, John, of Preston on Wye, yeoman 1
4377267 2156944 2156944 defendant Foxe Thomas yeoman 601482 601482 Foxe, Thomas, of Preston on Wye, yeoman 0
4377268 2156944 2156944 defendant Apprees John husbandman 601482 601482 Apprees, John, of Preston on Wye, husbandman 1
4390889 2161567 2161567 defendant Heynes Walter yeoman 601482 601482 Heynes, Walter, of Preston on Wye, yeoman 0
4400619 2164799 2164799 defendant Heynes Walter husbandman 601482 601482 Heynes, Walter, of Preston on Wye, husbandman 0
4791982 2293598 2293598 defendant Peres Roger husbandman 601482 601482 Peres, Roger, of Preston on Wye, husbandman 0
4934213 2337089 2337089 defendant Belymare alias Perys Roger yeoman or husbandman 601482 601482 Belymare alias Perys, Roger, of Preston on Wye, yeoman or husbandman 0
5459573 2492776 2492776 defendant Trehayron Thomas gent 601482 601482 Trehayron, Thomas, of Preston on Wye, gent 0
5587392 2531081 2531081 defendant Notyngham Richard husbandman 601482 601482 Notyngham, Richard, of Preston on Wye, husbandman 4
5598084 2534298 2534298 defendant ap Meryk Triamore yeoman 601482 601482 ap Meryk, Triamore, of Preston on Wye, yeoman 1

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