names

83 rows where place_id = 599835

✎ 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
3638456 1906849 1906849 plaintiff Fyncham John   599835 599835 Fyncham, John, of Welle 5
3638463 1906850 1906850 plaintiff Fyncham John   599835 599835 Fyncham, John, of Welle 5
3651816 1910926 1910926 plaintiff Fyncham John   599835 599835 Fyncham, John, of Welle 4
3685553 1921631 1921631 defendant Styward Richard grocer 599835 599835 Styward, Richard, of Welle, grocer 1
3697790 1925531 1925531 plaintiff Fyncham John   599835 599835 Fyncham, John, of Welle 4
3697797 1925532 1925532 plaintiff Fyncham John   599835 599835 Fyncham, John, of Welle 4
3697804 1925533 1925533 plaintiff Fyncham John   599835 599835 Fyncham, John, of Welle 4
3697811 1925534 1925534 plaintiff Fyncham John   599835 599835 Fyncham, John, of Welle 4
3706574 1928341 1928341 defendant Styward Richard grocer 599835 599835 Styward, Richard, of Welle, grocer 1
3706580 1928343 1928343 defendant Styward Richard grocer 599835 599835 Styward, Richard, of Welle, grocer 1
3726401 1934523 1934523 plaintiff Fyncham John   599835 599835 Fyncham, John, of Welle 4
3826353 1966092 1966092 defendant Spendluff Thomas yeoman 599835 599835 Spendluff, Thomas, of Welle, yeoman 0
3828284 1966720 1966720 defendant Steward Richard grocer 599835 599835 Steward, Richard, of Welle, grocer 0
3828287 1966721 1966721 defendant Steward Richard grocer 599835 599835 Steward, Richard, of Welle, grocer 0
3846703 1972524 1972524 defendant Pratt John yeoman 599835 599835 (Pratt, John, of Welle, yeoman 1
3846706 1972525 1972525 defendant Pratt John yeoman 599835 599835 (Pratt, John, of Welle, yeoman 1
3880984 1983910 1983910 defendant Togood Reginald servingman 599835 599835 Togood, Reginald, of Welle, servingman 0
3896987 1989210 1989210 defendant Starne Richard husbandman 599835 599835 Starne, Richard, of Welle, husbandman 0
3903811 1991507 1991507 defendant Yowen David tanner 599835 599835 Yowen, David, of Welle, tanner 4
3986726 2019992 2019992 defendant Mane Thomas shoemaker 599835 599835 Mane, Thomas, of Welle, shoemaker 2
4029429 2035163 2035163 plaintiff Jarye Robert yeoman 599835 599835 Jarye, Robert, of Welle, yeoman 1
4091025 2057078 2057078 defendant Storye John butcher 599835 599835 Storye, John, of Welle, butcher 2
4239551 2109460 2109460 defendant Cupledike William husbandman 599835 599835 Cupledike, William, of Welle, husbandman 0
4293886 2127883 2127883 defendant Caterton Thomas gent 599835 599835 Caterton, Thomas, of Welle, gent 0
4414446 2169423 2169423 defendant Sire John   599835 599835 Sire, John, of Welle, son of William 1
4437985 2181197 2181197 defendant Bailly Nicholas   599835 599835 Bailly, Nicholas, of Welle 1
4438642 2181373 2181373 plaintiff Aston John   599835 599835 Aston, John, of Welle 0
4438643 2181373 2181373 defendant Sauton William de   599835 599835 Sauton, William de, of Welle 0
4445931 2183672 2183672 defendant Santon William   599835 599835 Santon, William, of Welle 1
4478239 2193867 2193867 plaintiff Hayward or Haynard Robert   599835 599835 Hayward or Haynard, Robert, of Welle 0
4478240 2193867 2193867 defendant Longe Walter   599835 599835 Longe, Walter, of Welle 0
4482092 2195110 2195110 defendant Damet Walter   599835 599835 Damet, Walter, of Welle 0
4492557 2198366 2198366 defendant Longe Walter   599835 599835 Longe, Walter, of Welle 0
4513957 2204787 2204787 defendant Grove John tailor 599835 599835 Grove, John, of Welle, tailor 0
4543736 2213934 2213934 defendant Dorneford William   599835 599835 Dorneford, William, of Welle 0
4548670 2215527 2215527 plaintiff Cleydon Richard chaplain 599835 599835 Cleydon, Richard, of Welle, chaplain 0
4569501 2222046 2222046 defendant Everard John   599835 599835 Everard, John, of Welle 2
4602771 2232083 2232083 plaintiff Whelhous John   599835 599835 Whelhous, John, of Welle 0
4602773 2232083 2232083 defendant Thekeston William de   599835 599835 Thekeston, William de, of Welle 1
4607365 2233412 2233412 defendant Panell John   599835 599835 Panell, John, of Welle 2
4615161 2235750 2235750 plaintiff Everard John   599835 599835 Everard, John, of Welle 0
4615164 2235750 2235750 defendant Bangant Adma   599835 599835 Bangant, Adma, of Welle 2
4624226 2238562 2238562 defendant Newe John   599835 599835 Newe, John, of Welle 0
4647940 2245466 2245466 defendant Bangot Adam   599835 599835 Bangot, Adam, of Welle 1
4653044 2246883 2246883 defendant White Thomas   599835 599835 White, Thomas, of Welle, cook 0
4675328 2257895 2257895 defendant Edryche Robert husbandman 599835 599835 Edryche, Robert, of Welle, husbandman 0
4675358 2257901 2257901 defendant Taillour John yeoman 599835 599835 Taillour, John, of Welle, yeoman 5
4708390 2267991 2267991 defendant Broun Simon husbandman 599835 599835 Broun, Simon, of Welle, husbandman 5
4708391 2267991 2267991 defendant Bateman John husbandman 599835 599835 Bateman, John, of Welle, husbandman 6
4708412 2267995 2267995 defendant Bochere William butcher 599835 599835 Bochere, William, of Welle, butcher 1
4722323 2272306 2272306 defendant Walton Thomas butcher 599835 599835 Walton, Thomas, of Welle, butcher 0
4754107 2281663 2281663 defendant Neudyk Thomas husbandman 599835 599835 Neudyk, Thomas, of Welle, husbandman 2
4754108 2281663 2281663 defendant Bolle Robert husbandman 599835 599835 Bolle, Robert, of Welle, husbandman 3
4764845 2284985 2284985 defendant Collesson John fishmonger 599835 599835 Collesson, John, of Welle, fishmonger 0
4764847 2284985 2284985 defendant Chapman John   599835 599835 Chapman, John, of Welle, bailiff 2
4775489 2288330 2288330 plaintiff Wodewale John   599835 599835 Wodewale, John, of Welle 0
4781861 2290342 2290342 defendant Beyfle Thomas esq 599835 599835 Beyfle, Thomas, of Welle, esq 0
4788939 2292595 2292595 defendant Danyell Walter laborer 599835 599835 Danyell, Walter, of Welle, laborer 0
4798286 2295653 2295653 defendant Colson John husbandman 599835 599835 Colson, John, of Welle, husbandman 0
4798288 2295653 2295653 defendant Rusford or Rufford William yeoman 599835 599835 Rusford or Rufford, William, of Welle, yeoman 2
4803306 2297226 2297226 defendant Grayne Simon yeoman 599835 599835 Grayne, Simon, of Welle, yeoman 2
4824391 2303688 2303688 defendant Wodewane John yeoman 599835 599835 Wodewane, John, of Welle, yeoman 4
4835276 2307032 2307032 defendant Welle John de (legal representative) 599835 599835 Welle, John de, of Welle, knight, executors of 0
4843482 2309480 2309480 defendant Walpole Henry husbandman 599835 599835 Walpole, Henry, of Welle, husbandman 0
4864866 2315987 2315987 defendant Byflete Thomas esq 599835 599835 Byflete, Thomas, of Welle, esq 0
4876759 2319704 2319704 defendant Skylman Robert her son 599835 599835 Skylman, Robert, of Welle, yeoman, her son 1
4915358 2331311 2331311 defendant Kyng Simon yeoman 599835 599835 Kyng, Simon, of Welle, yeoman 0
4968089 2347402 2347402 defendant Hobarde William husbandman 599835 599835 Hobarde, William, of Welle, husbandman 0
5013893 2360914 2360914 defendant Dalyson William gent 599835 599835 Dalyson, William, of Welle, gent 0
5019202 2362506 2362506 defendant Warde William butcher 599835 599835 Warde, William, of Welle, butcher 0
5068289 2377019 2377019 defendant Hoberd Thomas husbandman 599835 599835 Hoberd, Thomas, of Welle, husbandman 3
5081661 2381022 2381022 plaintiff Dalyson William   599835 599835 Dalyson, William, of Welle 0
5085099 2382046 2382046 defendant Huberd Thomas husbandman 599835 599835 Huberd, Thomas, of Welle, husbandman 0
5085103 2382047 2382047 defendant Huberd Thomas   599835 599835 Huberd, Thomas, of Welle 0
5178075 2409291 2409291 defendant Vyrly William butcher 599835 599835 Vyrly, William, of Welle, butcher 0
5201452 2416183 2416183 defendant Vyrly William butcher 599835 599835 Vyrly, William, of Welle, butcher 0
5212237 2419318 2419318 defendant Vyrly William butcher 599835 599835 Vyrly, William, of Welle, butcher 0
5381837 2469862 2469862 defendant Lowen William husbandman 599835 599835 Lowen, William, of Welle, husbandman 2
5387415 2471471 2471471 defendant Styward Nicholas gent 599835 599835 Styward, Nicholas, of Welle, gent 1
5395061 2473656 2473656 defendant Lowen William husbandman 599835 599835 Lowen, William, of Welle, husbandman 0
5540053 2517012 2517012 defendant Rigdon William husbandman 599835 599835 Rigdon, William, of Welle, husbandman 0
5578183 2528247 2528247 defendant Mayowe John mercer 599835 599835 Mayowe, John, of Welle, mercer 0
5634797 2554881 2554881 defendant Pokelyngton Thomas clerk 599835 599835 Pokelyngton, Thomas, of Welle, clerk 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);