names

71 rows where place_id = 672975

✎ 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
4007971 2027611 2027611 defendant Cooke Robert yeoman 672975 672975 Cooke, Robert, of Melkesham, yeoman 0
4369141 2154029 2154029 defendant Brouncker William (legal representative) 672975 672975 Brouncker, William, of Melkesham, esq, administrator of 1
4449612 2184826 2184826 plaintiff Gore Robert   672975 672975 Gore, Robert, of Melkesham 0
4449613 2184826 2184826 defendant Faunt John   672975 672975 Faunt, John, of Melkesham 0
4455909 2186865 2186865 defendant Heyward William   672975 672975 Heyward, William, of Melkesham 2
4535929 2211510 2211510 defendant Scot Henry   672975 672975 Scot, Henry, of Melkesham, mason 0
4536089 2211564 2211564 defendant Cowefold John   672975 672975 Cowefold, John, of Melkesham 2
4552118 2216610 2216610 defendant Ton_ John   672975 672975 Ton_, John, of Melkesham 1
4574254 2223476 2223476 plaintiff Benet John   672975 672975 Benet, John, of Melkesham 0
4574256 2223476 2223476 defendant Carpenter Thomas   672975 672975 Carpenter, Thomas, of Melkesham 0
4628799 2239935 2239935 defendant Benet John   672975 672975 Benet, John, of Melkesham 3
4672761 2257122 2257122 defendant Taillour Richard husbandman 672975 672975 Taillour, Richard, of Melkesham, husbandman 3
4689019 2262124 2262124 defendant Chitewe Walter husbandman 672975 672975 Chitewe, Walter, of Melkesham, husbandman 1
4689022 2262124 2262124 defendant Panter John laborer 672975 672975 Panter, John, of Melkesham, laborer 4
4689025 2262125 2262125 defendant Spuyrgayn Nicholas   672975 672975 Spuyrgayn, Nicholas, of Melkesham, vicar 0
4689027 2262125 2262125 defendant Chetwe Walter husbandman 672975 672975 Chetwe, Walter, of Melkesham, husbandman 2
4689028 2262125 2262125 defendant Bartelot William laborer 672975 672975 Bartelot, William, of Melkesham, laborer 3
4691901 2263003 2263003 defendant Cornysshe William husbandman 672975 672975 Cornysshe, William, of Melkesham, husbandman 0
4711536 2268936 2268936 defendant Foxanger John gent 672975 672975 Foxanger, John, of Melkesham, gent 0
4714697 2269925 2269925 defendant Rocy Richard husbandman 672975 672975 Rocy, Richard, of Melkesham, husbandman 2
4725262 2273192 2273192 defendant Carpenter Thomas carpenter 672975 672975 Carpenter, Thomas, of Melkesham, carpenter 2
4733450 2275636 2275636 defendant Wymely Walter husbandman 672975 672975 Wymely, Walter, of Melkesham, husbandman 0
4734180 2275870 2275870 defendant Wymely Walter farmer 672975 672975 Wymely, Walter, of Melkesham, farmer 0
4781201 2290132 2290132 defendant Ructour or Ruttour John husbandman 672975 672975 Ructour or Ruttour, John, of Melkesham, husbandman 0
4804032 2297443 2297443 defendant Poupyng John husbandman 672975 672975 Poupyng, John, of Melkesham, husbandman 0
4808884 2298947 2298947 defendant Gyffard John husbandman 672975 672975 Gyffard, John, of Melkesham, husbandman 0
4808885 2298947 2298947 defendant Roty Richard husbandman 672975 672975 Roty, Richard, of Melkesham, husbandman 1
4808886 2298947 2298947 defendant Russell John butcher 672975 672975 Russell, John, of Melkesham, butcher 2
4821388 2302773 2302773 defendant Lankylly John yeoman 672975 672975 Lankylly, John, of Melkesham, yeoman 0
4841417 2308848 2308848 defendant Belt Robert   672975 672975 Belt, Robert, of Melkesham, bailiff 2
4841418 2308848 2308848 defendant Gifford Thomas yeoman 672975 672975 Gifford, Thomas, of Melkesham, yeoman 3
4841419 2308848 2308848 defendant Skynner Richard husbandman 672975 672975 Skynner, Richard, of Melkesham, husbandman 4
4851461 2311902 2311902 defendant Gyfford Robert husbandman 672975 672975 Gyfford, Robert, of Melkesham, husbandman 1
4868700 2317182 2317182 defendant Belt Robert   672975 672975 Belt, Robert, of Melkesham, bailiff 1
4868701 2317182 2317182 defendant Gyfford Thomas yeoman 672975 672975 Gyfford, Thomas, of Melkesham, yeoman 2
4868702 2317182 2317182 defendant Skynner Richard husbandman 672975 672975 Skynner, Richard, of Melkesham, husbandman 3
4868709 2317183 2317183 defendant Belt Robert   672975 672975 Belt, Robert, of Melkesham, bailiff 0
4868710 2317183 2317183 defendant Gyffard Thomas yeoman 672975 672975 Gyffard, Thomas, of Melkesham, yeoman 1
4868711 2317183 2317183 defendant Skynner Richard husbandman 672975 672975 Skynner, Richard, of Melkesham, husbandman 2
4868720 2317184 2317184 defendant Belt Robert   672975 672975 Belt, Robert, of Melkesham, bailiff 1
4868721 2317184 2317184 defendant Gifford Thomas yeoman 672975 672975 Gifford, Thomas, of Melkesham, yeoman 2
4868722 2317184 2317184 defendant Skynner Richard husbandman 672975 672975 Skynner, Richard, of Melkesham, husbandman 3
4892653 2324431 2324431 defendant Popyng John husbandman 672975 672975 Popyng, John, of Melkesham, husbandman 1
4893930 2324802 2324802 defendant Gyfford Robert husbandman 672975 672975 Gyfford, Robert, of Melkesham, husbandman 1
4893931 2324802 2324802 defendant Roty Richard husbandman 672975 672975 Roty, Richard, of Melkesham, husbandman 2
4899137 2326372 2326372 defendant Russell John laborer 672975 672975 Russell, John, of Melkesham, laborer 1
4903565 2327726 2327726 defendant Roty Richard husbandman 672975 672975 Roty, Richard, of Melkesham, husbandman 0
4915769 2331430 2331430 defendant Popyng John husbandman 672975 672975 Popyng, John, of Melkesham, husbandman 0
4917976 2332136 2332136 defendant Porter Porter (legal representative) 672975 672975 Porter, Porter, of Melkesham, executrix of 0
4945069 2340441 2340441 defendant Hatte William husbandman 672975 672975 Hatte, William, of Melkesham, husbandman 0
4945858 2340689 2340689 defendant Gore William, junior gent 672975 672975 Gore, William, junior, of Melkesham, gent, son of Gore, William, of Aldryngton, gent 0
4963122 2345877 2345877 defendant Juwet William gent 672975 672975 Juwet, William, of Melkesham, gent 0
5023573 2363805 2363805 defendant Gifford Thomas husbandman 672975 672975 Gifford, Thomas, of Melkesham, husbandman 0
5053683 2372701 2372701 defendant Holwey John husbandman 672975 672975 Holwey, John, of Melkesham, husbandman 14
5057135 2373716 2373716 defendant Smyth Robert husbandman 672975 672975 Smyth, Robert, of Melkesham, husbandman 0
5081760 2381046 2381046 defendant Porter alias Ranger Alice widow 672975 672975 Porter alias Ranger, Alice, of Melkesham, widow 1
5099533 2386301 2386301 defendant Barlyche William husbandman 672975 672975 Barlyche, William, of Melkesham, husbandman 0
5162259 2404688 2404688 defendant Chetowe Robert husbandman 672975 672975 Chetowe, Robert, of Melkesham, husbandman 2
5176403 2408784 2408784 defendant Chetowe Robert husbandman 672975 672975 Chetowe, Robert, of Melkesham, husbandman 2
5198403 2415285 2415285 defendant Chetowe Robert husbandman 672975 672975 Chetowe, Robert, of Melkesham, husbandman 1
5259009 2432932 2432932 defendant Smyth Robert husbandman 672975 672975 Smyth, Robert, of Melkesham, husbandman 2
5299700 2444881 2444881 defendant Gore William gent 672975 672975 Gore, William, of Melkesham, gent 0
5322923 2451934 2451934 defendant Shropshyre Robert carpenter 672975 672975 Shropshyre, Robert, of Melkesham, carpenter 1
5322924 2451934 2451934 defendant Hous William carpenter 672975 672975 Hous, William, of Melkesham, carpenter 2
5322925 2451934 2451934 defendant Sawyer Philip sawyer 672975 672975 Sawyer, Philip, of Melkesham, sawyer 3
5506606 2506978 2506978 defendant Bartelot Richard husbandman 672975 672975 Bartelot, Richard, of Melkesham, husbandman 0
5614814 2548432 2548432 defendant Webbe William   672975 672975 Webbe, William, of Melkesham 1
5616814 2549063 2549063 defendant Sanderigge John   672975 672975 Sanderigge, John, of Melkesham 0
5623406 2551252 2551252 defendant Pallyng John   672975 672975 Pallyng, John, of Melkesham 0
5626676 2552317 2552317 defendant Wymeley Walter husbandman 672975 672975 Wymeley, Walter, of Melkesham, husbandman 0
5633651 2554524 2554524 defendant Spyrgayn Nicholas clerk 672975 672975 (Spyrgayn, Nicholas, of Melkesham, clerk 1

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