names

56 rows where place_id = 642335

✎ 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
3867355 1979315 1979315 defendant Scarlett William chapman 642335 642335 Scarlett, William, of Bloxham, Oxon, chapman 0
3867361 1979316 1979316 defendant Scarlett William chapman 642335 642335 Scarlett, William, of Bloxham, Oxon, chapman 0
4009222 2028065 2028065 defendant Hyll William yeoman 642335 642335 Hyll, William, of Bloxham, Oxon, yeoman 1
4039162 2038633 2038633 defendant Russell Robert yeoman 642335 642335 Russell, Robert, of Bloxham, Oxon, yeoman 0
4039166 2038634 2038634 defendant Russell Robert yeoman 642335 642335 Russell, Robert, of Bloxham, Oxon, yeoman 0
4355622 2149191 2149191 defendant Gaskyn Richard yeoman 642335 642335 Gaskyn, Richard, of Bloxham, Oxon, yeoman 1
4762266 2284180 2284180 defendant atte Grove William yeoman 642335 642335 atte Grove, William, of Bloxham, Oxon, yeoman 0
4806238 2298159 2298159 defendant Stanes Richard mercer 642335 642335 Stanes, Richard, of Bloxham, Oxon, mercer 4
4807946 2298668 2298668 defendant St Johns William draper 642335 642335 St Johns, William, of Bloxham, Oxon, draper 2
4825716 2304085 2304085 defendant Haule John husbandman 642335 642335 Haule, John, of Bloxham, Oxon, husbandman 3
4825724 2304087 2304087 defendant Hanle John husbandman 642335 642335 Hanle, John, of Bloxham, Oxon, husbandman 4
4833731 2306558 2306558 defendant Smyth William smith 642335 642335 Smyth, William, of Bloxham, Oxon, smith 2
4908394 2329180 2329180 defendant Napton John yeoman 642335 642335 Napton, John, of Bloxham, Oxon, yeoman 3
4909405 2329479 2329479 defendant Hevneden Thomas husbandman 642335 642335 Hevneden, Thomas, of Bloxham, Oxon, husbandman 2
4933657 2336903 2336903 defendant Napton John yeoman 642335 642335 Napton, John, of Bloxham, Oxon, yeoman 3
4992517 2354647 2354647 defendant Shelton Philip husbandman 642335 642335 Shelton, Philip, of Bloxham, Oxon, husbandman 1
5011339 2360179 2360179 defendant Tymmys Thomas husbandman 642335 642335 Tymmys, Thomas, of Bloxham, Oxon, husbandman 2
5021975 2363319 2363319 defendant Latymer John husbandman 642335 642335 Latymer, John, of Bloxham, Oxon, husbandman 2
5054433 2372900 2372900 defendant Sheldon Philip husbandman 642335 642335 Sheldon, Philip, of Bloxham, Oxon, husbandman 0
5060572 2374742 2374742 defendant Dandy or Daudy William husbandman 642335 642335 Dandy or Daudy, William, of Bloxham, Oxon, husbandman 2
5071153 2377864 2377864 defendant Mose John yeoman 642335 642335 Mose, John, of Bloxham, Oxon, yeoman 2
5079882 2380463 2380463 defendant Palmer William yeoman 642335 642335 Palmer, William, of Bloxham, Oxon, yeoman 0
5131665 2395744 2395744 defendant Bray John butcher 642335 642335 Bray, John, of Bloxham, Oxon, butcher 0
5157089 2403212 2403212 defendant Hoggys John husbandman 642335 642335 Hoggys, John, of Bloxham, Oxon, husbandman 3
5173145 2407855 2407855 defendant Hoggys John husbandman 642335 642335 Hoggys, John, of Bloxham, Oxon, husbandman 3
5195621 2414468 2414468 defendant Heggys John tailor 642335 642335 Heggys, John, of Bloxham, Oxon, tailor 2
5197199 2414920 2414920 defendant Bray John chapman 642335 642335 Bray, John, of Bloxham, Oxon, chapman 0
5209349 2418469 2418469 defendant Heggys John tailor 642335 642335 Heggys, John, of Bloxham, Oxon, tailor 2
5209961 2418646 2418646 defendant Bray John chapman 642335 642335 Bray, John, of Bloxham, Oxon, chapman 0
5275703 2437959 2437959 defendant Darset Richard fishmonger 642335 642335 Darset, Richard, of Bloxham, Oxon, fishmonger 0
5279585 2439106 2439106 defendant Dorset Richard woolman 642335 642335 Dorset, Richard, of Bloxham, Oxon, woolman 2
5279590 2439107 2439107 defendant Dorset Richard woolman 642335 642335 Dorset, Richard, of Bloxham, Oxon, woolman 2
5308300 2447515 2447515 defendant Rede Robert yeoman 642335 642335 Rede, Robert, of Bloxham, Oxon, yeoman 1
5319069 2450798 2450798 defendant Bretford Thomas husbandman 642335 642335 Bretford, Thomas, of Bloxham, Oxon, husbandman 1
5320665 2451275 2451275 defendant Averey William gent 642335 642335 Averey, William, of Bloxham, Oxon, gent 2
5329919 2454020 2454020 defendant Hervy John esq 642335 642335 Hervy, John, of Bloxham, Oxon, esq 0
5341891 2457661 2457661 defendant Hervy John esq 642335 642335 Hervy, John, of Bloxham, Oxon, esq 0
5350874 2460385 2460385 defendant Avery William gent 642335 642335 Avery, William, of Bloxham, Oxon, gent 4
5353553 2461184 2461184 defendant Serne or Serve John husbandman 642335 642335 Serne or Serve, John, of Bloxham, Oxon, husbandman 1
5371474 2466660 2466660 defendant Darset Richard husbandman 642335 642335 Darset, Richard, of Bloxham, Oxon, husbandman 1
5418529 2480470 2480470 defendant Halle William clerk 642335 642335 Halle, William, of Bloxham, Oxon, clerk 1
5436485 2485847 2485847 defendant Darset Richard husbandman 642335 642335 Darset, Richard, of Bloxham, Oxon, husbandman 0
5436494 2485849 2485849 defendant Darset Richard husbandman 642335 642335 Darset, Richard, of Bloxham, Oxon, husbandman 0
5436499 2485850 2485850 defendant Darset Richard husbandman 642335 642335 Darset, Richard, of Bloxham, Oxon, husbandman 0
5437860 2486255 2486255 defendant Cook Thomas husbandman 642335 642335 Cook, Thomas, of Bloxham, Oxon, husbandman 0
5437861 2486255 2486255 defendant Dynton Simon husbandman 642335 642335 Dynton, Simon, of Bloxham, Oxon, husbandman 1
5442929 2487797 2487797 defendant Cook Thomas husbandman 642335 642335 Cook, Thomas, of Bloxham, Oxon, husbandman 0
5470770 2496181 2496181 plaintiff Lerey William   642335 642335 (Lerey, William, of Bloxham, Oxon, parson 1
5474576 2497374 2497374 defendant Wadeluff Henry gent 642335 642335 Wadeluff, Henry, of Bloxham, Oxon, gent 0
5478765 2498669 2498669 defendant Dynton Simon husbandman 642335 642335 Dynton, Simon, of Bloxham, Oxon, husbandman 0
5485926 2500683 2500683 defendant Avery William gent 642335 642335 Avery, William, of Bloxham, Oxon, gent 0
5485929 2500683 2500683 defendant Pitte John yeoman 642335 642335 Pitte, John, of Bloxham, Oxon, yeoman 3
5486177 2500753 2500753 defendant Wadeluff Henry gent 642335 642335 Wadeluff, Henry, of Bloxham, Oxon, gent 0
5491326 2502295 2502295 defendant White John husbandman 642335 642335 White, John, of Bloxham, Oxon, husbandman 0
5500194 2505011 2505011 defendant Wadelove Henry mercer 642335 642335 Wadelove, Henry, of Bloxham, Oxon, gent, or of London, mercer 0
5500196 2505012 2505012 defendant Wadelove Henry mercer 642335 642335 Wadelove, Henry, of Bloxham, Oxon, gent, or of London, mercer 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);