names

51 rows where place_id = 781273

✎ 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
4671976 2256879 2256879 defendant Jude alias Taillour Thomas draper 781273 781273 Jude alias Taillour, Thomas, of Warwick, Warws, draper 3
4677378 2258542 2258542 defendant Wotton Roger gent 781273 781273 Wotton, Roger, of Warwick, Warws, gent 0
4704063 2266648 2266648 defendant Radenore William tailor 781273 781273 Radenore, William, of Warwick, Warws, tailor 0
4730389 2274704 2274704 defendant Bernewell Thomas chapman 781273 781273 Bernewell, Thomas, of Warwick, Warws, chapman 0
4744114 2278805 2278805 defendant Rody John goldsmith 781273 781273 Rody, John, of Warwick, Warws, goldsmith 0
4747721 2279842 2279842 defendant Mayell John husbandman 781273 781273 Mayell, John, of Warwick, Warws, husbandman 0
4772922 2287501 2287501 defendant Tolas John yeoman 781273 781273 Tolas, John, of Warwick, Warws, yeoman 1
4823034 2303286 2303286 defendant Aleyn John trumper 781273 781273 Aleyn, John, of Warwick, Warws, trumper 2
4823921 2303561 2303561 defendant Water Simon yeoman 781273 781273 Water, Simon, of Warwick, Warws, yeoman 2
4823940 2303563 2303563 defendant Water Simon yeoman 781273 781273 Water, Simon, of Warwick, Warws, yeoman 2
4828224 2304872 2304872 defendant Brome John gent 781273 781273 Brome, John, of Warwick, Warws, gent 0
4909260 2329439 2329439 defendant Shoteswell William butcher 781273 781273 Shoteswell, William, of Warwick, Warws, butcher 2
4914574 2331079 2331079 defendant Paynter Richard clerk & Master of the House of St John 781273 781273 Paynter, Richard, of Warwick, Warws, clerk & Master of the House of St John 0
4914579 2331080 2331080 defendant Paynter Richard clerk & Master of the House of St John 781273 781273 Paynter, Richard, of Warwick, Warws, clerk & Master of the House of St John 0
4914852 2331157 2331157 defendant Graundon alias Samborun John skinner 781273 781273 Graundon alias Samborun, John, of Warwick, Warws, skinner 4
4915010 2331199 2331199 defendant Heryngton William husbandman 781273 781273 Heryngton, William, of Warwick, Warws, husbandman 0
4931776 2336326 2336326 defendant Grendun John skinner 781273 781273 Grendun, John, of Warwick, Warws, skinner 0
4985980 2352725 2352725 defendant Norreys John esq 781273 781273 Norreys, John, of Warwick, Warws, esq 0
4989907 2353892 2353892 defendant Rody Nicholas gent 781273 781273 (Rody, Nicholas, of Warwick, Warws, gent 1
4990564 2354085 2354085 defendant Somerlove Henry gent 781273 781273 Somerlove, Henry, of Warwick, Warws, gent 2
5002830 2357732 2357732 defendant Martyn Thomas   781273 781273 (Martyn, Thomas, of Warwick, Warws, franklin 1
5011623 2360256 2360256 defendant Holt Richard chapman 781273 781273 Holt, Richard, of Warwick, Warws, chapman 0
5011630 2360257 2360257 defendant Holt Richard chapman 781273 781273 Holt, Richard, of Warwick, Warws, chapman 0
5043941 2369816 2369816 defendant Pery Simon baker 781273 781273 Pery, Simon, of Warwick, Warws, baker 0
5126879 2394338 2394338 defendant Dounyng Thomas chapman 781273 781273 Dounyng, Thomas, of Warwick, Warws, chapman 1
5145582 2399852 2399852 plaintiff Brom John gent 781273 781273 Brom, John, of Warwick, Warws, gent 0
5178574 2409448 2409448 defendant Mayell John chapman 781273 781273 Mayell, John, of Warwick, Warws, chapman 0
5297484 2444269 2444269 defendant Mylner Henry chapman 781273 781273 Mylner, Henry, of Warwick, Warws, chapman 0
5300251 2445039 2445039 defendant Southwell Philip clerk 781273 781273 Southwell, Philip, of Warwick, Warws, clerk 0
5304619 2446380 2446380 defendant Oter John gent 781273 781273 Oter, John, of Warwick, Warws, gent 0
5304624 2446382 2446382 defendant Orer John gent 781273 781273 Orer, John, of Warwick, Warws, gent 0
5304627 2446383 2446383 defendant Oter John gent 781273 781273 Oter, John, of Warwick, Warws, gent 0
5381539 2469777 2469777 defendant Barbour John barber 781273 781273 Barbour, John, of Warwick, Warws, barber 1
5384939 2470765 2470765 defendant Barbour John barber 781273 781273 Barbour, John, of Warwick, Warws, barber 1
5387285 2471436 2471436 defendant Swertebrygge Thomas yeoman 781273 781273 Swertebrygge, Thomas, of Warwick, Warws, yeoman 2
5389130 2471942 2471942 defendant Barbour John barber 781273 781273 Barbour, John, of Warwick, Warws, barber 0
5393374 2473162 2473162 defendant Curson John gent 781273 781273 Curson, John, of Warwick, Warws, gent 2
5396974 2474216 2474216 defendant Barbour John barber 781273 781273 Barbour, John, of Warwick, Warws, barber 1
5409777 2477899 2477899 defendant Tapton John clerk 781273 781273 Tapton, John, of Warwick, Warws, clerk 2
5410246 2478016 2478016 defendant Barbour John barber 781273 781273 Barbour, John, of Warwick, Warws, barber 1
5418542 2480473 2480473 defendant Barbour John yeoman 781273 781273 Barbour, John, of Warwick, Warws, yeoman 3
5419661 2480798 2480798 defendant Curson John gent 781273 781273 Curson, John, of Warwick, Warws, gent 2
5435406 2485530 2485530 defendant Welles William mercer 781273 781273 Welles, William, of Warwick, Warws, mercer 1
5464519 2494308 2494308 defendant Keyt Thomas mercer 781273 781273 Keyt, Thomas, of Warwick, Warws, mercer 3
5466086 2494792 2494792 defendant Smyth John   781273 781273 Smyth, John, of Warwick, Warws 0
5469802 2495895 2495895 defendant Palmer Richard gent 781273 781273 Palmer, Richard, of Warwick, Warws, gent 0
5470035 2495956 2495956 defendant Hurst William tailor 781273 781273 Hurst, William, of Warwick, Warws, tailor 2
5470367 2496061 2496061 defendant Smyth John yeoman 781273 781273 Smyth, John, of Warwick, Warws, yeoman 1
5473834 2497152 2497152 defendant Smyth John barber 781273 781273 Smyth, John, of Warwick, Warws, barber 0
5476038 2497847 2497847 defendant Mylner Henry mercer 781273 781273 Mylner, Henry, of Warwick, Warws, mercer 0
5476041 2497847 2497847 defendant K_ Thomas mercer 781273 781273 K_, Thomas, of Warwick, Warws, mercer 3

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