names

40 rows where place_id = 669924

✎ 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
3995007 2022960 2022960 plaintiff Cooper Thomas yeoman 669924 669924 Cooper, Thomas, of Abbotesbury, yeoman 0
3995009 2022961 2022961 plaintiff Cooper Thomas yeoman 669924 669924 Cooper, Thomas, of Abbotesbury, yeoman 0
4371987 2155043 2155043 defendant Rose Henry yeoman 669924 669924 Rose, Henry, of Abbotesbury, yeoman 1
4521182 2206964 2206964 defendant Muleward William   669924 669924 Muleward, William, of Abbotesbury 0
4629221 2240071 2240071 defendant Hunte Ralph   669924 669924 Hunte, Ralph, of Abbotesbury 0
4726410 2273542 2273542 defendant Dole John yeoman 669924 669924 Dole, John, of Abbotesbury, yeoman 0
5006191 2358703 2358703 plaintiff Sawndres Robert   669924 669924 Sawndres, Robert, of Abbotesbury 0
5043924 2369811 2369811 defendant Saunderys Robert tailor 669924 669924 Saunderys, Robert, of Abbotesbury, tailor 0
5123765 2393410 2393410 defendant Chartenay Andrew merchant 669924 669924 Chartenay, Andrew, of Abbotesbury, merchant 0
5131006 2395552 2395552 defendant Langton Peter husbandman 669924 669924 Langton, Peter, of Abbotesbury, husbandman 2
5131733 2395766 2395766 plaintiff Gould Robert   669924 669924 Gould, Robert, of Abbotesbury 0
5131734 2395766 2395766 defendant Smyth Ralph husbandman 669924 669924 Smyth, Ralph, of Abbotesbury, husbandman 0
5131735 2395766 2395766 defendant Neweman John husbandman 669924 669924 Neweman, John, of Abbotesbury, husbandman 1
5137857 2397586 2397586 defendant Mower John baker 669924 669924 Mower, John, of Abbotesbury, baker 0
5139963 2398169 2398169 defendant Mower John husbandman 669924 669924 Mower, John, of Abbotesbury, husbandman 0
5139964 2398169 2398169 defendant Clerke John husbandman 669924 669924 Clerke, John, of Abbotesbury, husbandman 1
5139965 2398169 2398169 defendant Style John husbandman 669924 669924 Style, John, of Abbotesbury, husbandman 2
5139973 2398170 2398170 defendant Raddon Robert husbandman 669924 669924 (Raddon, Robert, of Abbotesbury, husbandman 5
5142592 2398962 2398962 plaintiff Wuller William   669924 669924 Wuller, William, of Abbotesbury, abbot 0
5142593 2398962 2398962 defendant Barbour John barber 669924 669924 Barbour, John, of Abbotesbury, barber 0
5142594 2398962 2398962 defendant Bertelot Robert husbandman 669924 669924 Bertelot, Robert, of Abbotesbury, husbandman 1
5142595 2398962 2398962 defendant Tabard John husbandman 669924 669924 Tabard, John, of Abbotesbury, husbandman 2
5150503 2401283 2401283 defendant Langton Peter husbandman 669924 669924 Langton, Peter, of Abbotesbury, husbandman 2
5151086 2401460 2401460 defendant Brode Thomas hosier 669924 669924 Brode, Thomas, of Abbotesbury, hosier 1
5151273 2401520 2401520 plaintiff Gould Robert   669924 669924 Gould, Robert, of Abbotesbury 0
5151274 2401520 2401520 defendant Smyth Ralph husbandman 669924 669924 Smyth, Ralph, of Abbotesbury, husbandman 0
5151275 2401520 2401520 defendant Neweman John husbandman 669924 669924 Neweman, John, of Abbotesbury, husbandman 1
5158572 2403629 2403629 defendant Mower John baker 669924 669924 Mower, John, of Abbotesbury, baker 0
5160974 2404313 2404313 defendant Mower John husbandman 669924 669924 Mower, John, of Abbotesbury, husbandman 0
5160975 2404313 2404313 defendant Clerke John husbandman 669924 669924 Clerke, John, of Abbotesbury, husbandman 1
5160976 2404313 2404313 defendant Style John husbandman 669924 669924 Style, John, of Abbotesbury, husbandman 2
5169365 2406776 2406776 defendant Brode Thomas hosier 669924 669924 Brode, Thomas, of Abbotesbury, hosier 1
5169464 2406806 2406806 plaintiff Gould Robert   669924 669924 Gould, Robert, of Abbotesbury 0
5169465 2406806 2406806 defendant South Ralph husbandman 669924 669924 South, Ralph, of Abbotesbury, husbandman 0
5169466 2406806 2406806 defendant Neweman John husbandman 669924 669924 Neweman, John, of Abbotesbury, husbandman 1
5199620 2415632 2415632 defendant Chartenay Aandrew merchant 669924 669924 Chartenay, Aandrew, of Abbotesbury, merchant 0
5266390 2435237 2435237 defendant Tabard Robert husbandman 669924 669924 Tabard, Robert, of Abbotesbury, husbandman 0
5271452 2436743 2436743 defendant Dorchester Hugh   669924 669924 Dorchester, Hugh, of Abbotesbury, abbot 0
5456424 2491841 2491841 defendant Albryght Guido or Guy shoemaker 669924 669924 Albryght, Guido or Guy, of Abbotesbury, shoemaker 0
5464909 2494419 2494419 defendant Bagewell John husbandman 669924 669924 Bagewell, John, of Abbotesbury, 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);