names

55 rows where place_id = 607812

✎ 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
3670885 1916861 1916861 defendant Colar Thomas husbandman 607812 607812 Colar, Thomas, of Sherston, husbandman 0
3699461 1926059 1926059 defendant Horte Robert yeoman 607812 607812 Horte, Robert, of Sherston, yeoman 0
3728395 1935126 1935126 defendant Horte Robert yeoman 607812 607812 Horte, Robert, of Sherston, yeoman 0
3743728 1939920 1939920 defendant Horte Robert yeoman 607812 607812 Horte, Robert, of Sherston, yeoman 0
3743730 1939921 1939921 defendant Horte Robert yeoman 607812 607812 Horte, Robert, of Sherston, yeoman 0
3755660 1943726 1943726 defendant Horte Robert yeoman 607812 607812 Horte, Robert, of Sherston, yeoman 0
3788371 1954162 1954162 defendant Slugge Robert yeoman 607812 607812 Slugge, Robert, of Sherston, yeoman 0
3788379 1954164 1954164 defendant Slugge Robert yeoman 607812 607812 Slugge, Robert, of Sherston, yeoman 0
3796500 1956777 1956777 defendant Plummer William gent 607812 607812 Plummer, William, of Sherston, gent 1
3815246 1962684 1962684 defendant Bayly Robert husbandman 607812 607812 Bayly, Robert, of Sherston, husbandman 0
3854181 1974945 1974945 defendant Selbourne William husbandman 607812 607812 Selbourne, William, of Sherston, husbandman 0
3854183 1974946 1974946 defendant Seybourne William husbandman 607812 607812 Seybourne, William, of Sherston, husbandman 0
3868382 1979664 1979664 defendant Bayly William husbandman 607812 607812 Bayly, William, of Sherston, husbandman 0
3923813 1998271 1998271 defendant Turner William shoemaker 607812 607812 Turner, William, of Sherston, shoemaker 0
4001367 2025266 2025266 defendant Gardener Thomas clerk 607812 607812 Gardener, Thomas, of Sherston, clerk 0
4001369 2025267 2025267 defendant Gardener Thomas clerk 607812 607812 Gardener, Thomas, of Sherston, clerk 0
4083229 2054291 2054291 defendant Prowte Thomas   607812 607812 Prowte, Thomas, of Sherston, or of Shafton Magna, freemason 0
4224888 2104172 2104172 defendant Androse Thomas (legal representative) 607812 607812 Androse, Thomas, of Sherston, shoemaker, executrix of 0
4235056 2107814 2107814 defendant Blake John yeoman 607812 607812 Blake, John, of Sherston, yeoman 0
4239674 2109507 2109507 defendant Blake John gent 607812 607812 Blake, John, of Sherston, gent 0
4261965 2116954 2116954 defendant Blake John gent 607812 607812 Blake, John, of Sherston, gent 0
4303653 2131403 2131403 defendant Webbe Thomas gent 607812 607812 Webbe, Thomas, of Sherston, or of Keevell, Wilts, gent 0
4303655 2131403 2131403 defendant Moore John yeoman 607812 607812 Moore, John, of Sherston, yeoman 2
4494951 2199107 2199107 defendant Balkere Walter   607812 607812 Balkere, Walter, of Sherston 0
4506072 2202412 2202412 defendant Hogges William   607812 607812 Hogges, William, of Sherston 0
4513709 2204716 2204716 plaintiff Bruyther John   607812 607812 Bruyther, John, of Sherston 0
4540770 2213016 2213016 defendant Bruyther John   607812 607812 Bruyther, John, of Sherston 0
4584496 2226566 2226566 defendant Taillour William   607812 607812 together with Taillour, William, of Sherston 2
4629599 2240183 2240183 defendant Webbe Nicholas   607812 607812 Webbe, Nicholas, of Sherston 1
4634746 2241719 2241719 defendant Bodyn Roger   607812 607812 Bodyn, Roger, of Sherston, parson 0
4654891 2247410 2247410 defendant Freman William husbandman 607812 607812 Freman, William, of Sherston, husbandman 0
4691899 2263002 2263002 defendant Penpas Nicholas husbandman 607812 607812 Penpas, Nicholas, of Sherston, husbandman 1
4694242 2263700 2263700 defendant Freman William husbandman 607812 607812 Freman, William, of Sherston, husbandman 0
4696716 2264450 2264450 defendant Petypace Nicholas draper 607812 607812 Petypace, Nicholas, of Sherston, draper 0
4711755 2269000 2269000 defendant Petypas Nicholas husbandman 607812 607812 Petypas, Nicholas, of Sherston, husbandman 0
4714164 2269761 2269761 defendant Petipas Nicholas yeoman 607812 607812 Petipas, Nicholas, of Sherston, yeoman 0
4789755 2292865 2292865 defendant Piers Robert fletcher 607812 607812 Piers, Robert, of Sherston, fletcher 1
4789756 2292865 2292865 defendant Martyn Richard laborer 607812 607812 Martyn, Richard, of Sherston, laborer 2
4805777 2298012 2298012 defendant Clerk Robert husbandman 607812 607812 Clerk, Robert, of Sherston, husbandman 7
4811122 2299589 2299589 defendant Tresham William husbandman 607812 607812 Tresham, William, of Sherston, husbandman 1
4811123 2299589 2299589 defendant Piers John chapman 607812 607812 Piers, John, of Sherston, chapman 2
4856071 2313271 2313271 defendant Farreis John husbandman 607812 607812 Farreis, John, of Sherston, husbandman 0
4994643 2355257 2355257 defendant Moreman Richard (legal representative) 607812 607812 Moreman, Richard, of Sherston, gent, executors of 0
5140225 2398241 2398241 defendant Smyth Geoffrey (legal representative) 607812 607812 Smyth, Geoffrey, of Sherston, executors of 0
5209728 2418584 2418584 defendant Brynkeworth William clerk 607812 607812 Brynkeworth, William, of Sherston, clerk 0
5309798 2447966 2447966 defendant Grene John husbandman 607812 607812 Grene, John, of Sherston, husbandman 0
5309800 2447967 2447967 defendant Grene John husbandman 607812 607812 Grene, John, of Sherston, husbandman 0
5449783 2489825 2489825 defendant Broun John yeoman 607812 607812 Broun, John, of Sherston, yeoman 0
5461945 2493515 2493515 defendant Broun John yeoman 607812 607812 Broun, John, of Sherston, yeoman 0
5475773 2497752 2497752 defendant London Thomas laborer 607812 607812 London, Thomas, of Sherston, laborer 1
5518307 2510553 2510553 defendant Edmay alias Hoper Robert husbandman 607812 607812 Edmay alias Hoper, Robert, of Sherston, husbandman 0
5521130 2511423 2511423 defendant Bery John collier 607812 607812 Bery, John, of Sherston, collier 1
5631124 2553742 2553742 defendant Hunt John, junior carrier 607812 607812 Hunt, John, junior, of Sherston, carrier 0
5631125 2553742 2553742 defendant Hunt John, senior carrier 607812 607812 Hunt, John, senior, of Sherston, carrier 1
5631126 2553742 2553742 defendant Smyth Richard smith 607812 607812 Smyth, Richard, of Sherston, smith 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);