names

46 rows where place_id = 591167

✎ 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
3603568 1868786 1868786 defendant Dune John, senior husbandman 591167 591167 Dune, John, senior, of Cholsey, husbandman 0
3633202 1905198 1905198 defendant Absolon John husbandman 591167 591167 Absolon, John, of Cholsey, husbandman 0
3654958 1911812 1911812 defendant Brownyng William (legal representative) 591167 591167 Brownyng, William, of Cholsey, husbandman, executors of 2
3701956 1926864 1926864 defendant Absolon John husbandman 591167 591167 Absolon, John, of Cholsey, husbandman 1
3789757 1954627 1954627 defendant Eldryche Thomas husbandman 591167 591167 Eldryche, Thomas, of Cholsey, husbandman 2
3808783 1960627 1960627 defendant Wyllymot Richard husbandman 591167 591167 Wyllymot, Richard, of Cholsey, husbandman 0
3808784 1960627 1960627 defendant Andrewes Thomas husbandman 591167 591167 Andrewes, Thomas, of Cholsey, husbandman 1
3808785 1960627 1960627 defendant Lewysley William laborer 591167 591167 Lewysley, William, of Cholsey, laborer 2
3808786 1960627 1960627 defendant Brodcroft Henry laborer 591167 591167 Brodcroft, Henry, of Cholsey, laborer 3
3808787 1960627 1960627 defendant Brodcroft William laborer 591167 591167 Brodcroft, William, of Cholsey, laborer 4
3808788 1960627 1960627 defendant Brodcroft John laborer 591167 591167 Brodcroft, John, of Cholsey, laborer 5
3867940 1979511 1979511 defendant Grene Richard husbandman 591167 591167 Grene, Richard, of Cholsey, husbandman 0
4021406 2032381 2032381 plaintiff Wylmotte Thomas yeoman 591167 591167 Wylmotte, Thomas, of Cholsey, yeoman 0
4476196 2193218 2193218 plaintiff Frangkeleyn Thomas   591167 591167 Frangkeleyn, Thomas, of Cholsey, on his own account 0
4605901 2232960 2232960 plaintiff atte Hill William   591167 591167 atte Hill, William, of Cholsey 0
4684791 2260841 2260841 defendant Hay John   591167 591167 Hay, John, of Cholsey, vicar 0
4738808 2277229 2277229 defendant Hamon Lawrence   591167 591167 Hamon, Lawrence, of Cholsey, franklin 0
4738809 2277229 2277229 defendant Hamon Richard husbandman 591167 591167 Hamon, Richard, of Cholsey, husbandman 1
4738810 2277229 2277229 defendant Hamon John husbandman 591167 591167 Hamon, John, of Cholsey, husbandman 2
4738811 2277229 2277229 defendant Rose Simon laborer 591167 591167 Rose, Simon, of Cholsey, laborer 3
4738812 2277229 2277229 defendant Crilee John laborer 591167 591167 Crilee, John, of Cholsey, laborer 4
4770485 2286744 2286744 defendant Hay John   591167 591167 Hay, John, of Cholsey, vicar 0
4779328 2289517 2289517 defendant Combe Simon husbandman 591167 591167 Combe, Simon, of Cholsey, husbandman 0
4779329 2289517 2289517 defendant Webbe Thomas husbandman 591167 591167 Webbe, Thomas, of Cholsey, husbandman 1
4918613 2332336 2332336 defendant Absilon Robert husbandman 591167 591167 Absilon, Robert, of Cholsey, husbandman 0
4926938 2334854 2334854 defendant Assh Thomas husbandman 591167 591167 Assh, Thomas, of Cholsey, husbandman 0
4944271 2340183 2340183 defendant Ansolon Robert husbandman 591167 591167 Ansolon, Robert, of Cholsey, husbandman 0
4949937 2341950 2341950 defendant Gerveys Robert husbandman 591167 591167 Gerveys, Robert, of Cholsey, husbandman 0
4949938 2341950 2341950 defendant Levesley Richard husbandman 591167 591167 Levesley, Richard, of Cholsey, husbandman 1
4949939 2341950 2341950 defendant Hamond Richard husbandman 591167 591167 Hamond, Richard, of Cholsey, husbandman 2
4949940 2341950 2341950 defendant Barfote William husbandman 591167 591167 Barfote, William, of Cholsey, husbandman 3
4998497 2356431 2356431 defendant Hochon Robert husbandman 591167 591167 Hochon, Robert, of Cholsey, husbandman 0
5035443 2367224 2367224 defendant Absolon John yeoman 591167 591167 Absolon, John, of Cholsey, yeoman 1
5040947 2368913 2368913 defendant Leversle Richard husbandman 591167 591167 Leversle, Richard, of Cholsey, husbandman 0
5090074 2383468 2383468 defendant Abselon John husbandman 591167 591167 Abselon, John, of Cholsey, husbandman 1
5105262 2387980 2387980 defendant Brodecrofte John husbandman 591167 591167 Brodecrofte, John, of Cholsey, husbandman 0
5108623 2388956 2388956 defendant Bratton Thomas butcher 591167 591167 Bratton, Thomas, of Cholsey, butcher 0
5113603 2390369 2390369 defendant Brodecroft John yeoman 591167 591167 Brodecroft, John, of Cholsey, yeoman 0
5212273 2419329 2419329 defendant Absolan John yeoman 591167 591167 Absolan, John, of Cholsey, yeoman 0
5239252 2427069 2427069 defendant Absolon John yeoman 591167 591167 Absolon, John, of Cholsey, yeoman 0
5248981 2429825 2429825 defendant Webbe John husbandman 591167 591167 Webbe, John, of Cholsey, husbandman 2
5326333 2452965 2452965 defendant Polhampton Thomas yeoman 591167 591167 Polhampton, Thomas, of Cholsey, yeoman 1
5576983 2527845 2527845 defendant Dunny alias Marche John, senior yeoman 591167 591167 Dunny alias Marche, John, senior, of Cholsey, yeoman 0
5591542 2532332 2532332 defendant Marche alias Dunne John husbandman 591167 591167 Marche alias Dunne, John, of Cholsey, husbandman 0
5591543 2532332 2532332 defendant Absolon John husbandman 591167 591167 Absolon, John, of Cholsey, husbandman 1
5623661 2551338 2551338 defendant Baron John (legal representative) 591167 591167 Baron, John, of Cholsey, executors of 2

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