names

116 rows where place_id = 595165

✎ 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
3619190 1873602 1873602 defendant Austyn Thomas husbandman 595165 595165 Austyn, Thomas, of Brenchesle, husbandman 0
3827385 1966430 1966430 defendant Lorkyn John yeoman 595165 595165 Lorkyn, John, of Brenchesle, yeoman 0
4500979 2200914 2200914 defendant Prat Richard   595165 595165 Prat, Richard, of Brenchesle 1
4507313 2202750 2202750 defendant Prat Richard   595165 595165 Prat, Richard, of Brenchesle 1
4575999 2223989 2223989 defendant Brenchesle Thomas   595165 595165 Brenchesle, Thomas, of Brenchesle 0
4576004 2223990 2223990 defendant Brenchesle Thomas   595165 595165 Brenchesle, Thomas, of Brenchesle 0
4577331 2224426 2224426 defendant Pyrot John   595165 595165 Pyrot, John, of Brenchesle 1
4591384 2228661 2228661 plaintiff Miller Thomas   595165 595165 Miller, Thomas, of Brenchesle 0
4623372 2238282 2238282 defendant Michel John   595165 595165 Michel, John, of Brenchesle 0
4644894 2244573 2244573 defendant Michell John   595165 595165 Michell, John, of Brenchesle 0
4657818 2248333 2248333 defendant Hebelot William yeoman 595165 595165 Hebelot, William, of Brenchesle, yeoman 0
4658311 2248482 2248482 defendant Bakere Robert smith 595165 595165 Bakere, Robert, of Brenchesle, smith 2
4661734 2249512 2249512 defendant Everard Richard carrier 595165 595165 Everard, Richard, of Brenchesle, carrier 0
4667388 2255521 2255521 defendant Ricard Richard laborer 595165 595165 Ricard, Richard, of Brenchesle, laborer 0
4672386 2257015 2257015 defendant Kempe John miller 595165 595165 Kempe, John, of Brenchesle, miller 1
4672703 2257104 2257104 plaintiff Hervy John   595165 595165 Hervy, John, of Brenchesle 2
4687262 2261623 2261623 defendant Milys John   595165 595165 Milys, John, of Brenchesle, latthe or latch seller 0
4696851 2264495 2264495 defendant Clouth Richard chapman 595165 595165 Clouth, Richard, of Brenchesle, chapman 0
4710811 2268736 2268736 defendant Michel Margaret widow 595165 595165 Michel, Margaret, of Brenchesle, widow 0
4727634 2273882 2273882 defendant Donner Thomas husbandman 595165 595165 Donner, Thomas, of Brenchesle, husbandman 3
4740983 2277873 2277873 defendant Baker Robert husbandman 595165 595165 Baker, Robert, of Brenchesle, husbandman 0
4742129 2278190 2278190 defendant Kyne John laborer 595165 595165 Kyne, John, of Brenchesle, laborer 0
4742130 2278190 2278190 defendant Mellere Richard, junior laborer 595165 595165 Mellere, Richard, junior, of Brenchesle, laborer 1
4754294 2281720 2281720 defendant Hellys Thomas husbandman 595165 595165 Hellys, Thomas, of Brenchesle, husbandman 0
4754296 2281720 2281720 defendant Beanesbeche Richard husbandman 595165 595165 Beanesbeche, Richard, of Brenchesle, husbandman 2
4769101 2286316 2286316 defendant Wrynge Thomas laborer 595165 595165 Wrynge, Thomas, of Brenchesle, laborer 7
4776049 2288506 2288506 defendant _spythe Richard carpenter 595165 595165 _spythe, Richard, of Brenchesle, carpenter 0
4787736 2292232 2292232 defendant Godesday Nicholas laborer 595165 595165 Godesday, Nicholas, of Brenchesle, laborer 1
4801970 2296799 2296799 defendant Bewspryche Richard carpenter 595165 595165 Bewspryche, Richard, of Brenchesle, carpenter 0
4813113 2300219 2300219 plaintiff Hellys Thomas   595165 595165 Hellys, Thomas, of Brenchesle 0
4843652 2309537 2309537 defendant Tebbe Thomas yeoman 595165 595165 Tebbe, Thomas, of Brenchesle, yeoman 1
4861685 2315030 2315030 defendant Donnere or Dounere William glover 595165 595165 Donnere or Dounere, William, of Brenchesle, glover 0
4867577 2316830 2316830 defendant Baudewyn Robert cordainer 595165 595165 Baudewyn, Robert, of Brenchesle, cordainer 0
4873778 2318736 2318736 defendant Hoget John yeoman 595165 595165 Hoget, John, of Brenchesle, yeoman 0
4887376 2322888 2322888 defendant Tebbe Thomas husbandman 595165 595165 Tebbe, Thomas, of Brenchesle, husbandman 0
4897306 2325815 2325815 defendant Dowener William glover 595165 595165 Dowener, William, of Brenchesle, glover 0
4915992 2331501 2331501 defendant Edword Richard husbandman 595165 595165 Edword, Richard, of Brenchesle, husbandman 1
4920680 2332983 2332983 defendant Donner William butcher 595165 595165 Donner, William, of Brenchesle, butcher 2
4938729 2338500 2338500 defendant Bakere Robert smith 595165 595165 Bakere, Robert, of Brenchesle, smith 0
4944737 2340341 2340341 plaintiff Hellys Thomas   595165 595165 Hellys, Thomas, of Brenchesle 0
4944738 2340341 2340341 plaintiff Peek John butcher 595165 595165 Peek, John, of Brenchesle, butcher 1
4944740 2340341 2340341 defendant Rycard John laborer 595165 595165 Rycard, John, of Brenchesle, laborer 0
4952700 2342765 2342765 defendant Donner John butcher 595165 595165 Donner, John, of Brenchesle, butcher 0
4952704 2342766 2342766 defendant Peke John butcher 595165 595165 Peke, John, of Brenchesle, butcher 0
4962094 2345569 2345569 defendant Poyle Richard cooper 595165 595165 Poyle, Richard, of Brenchesle, cooper 0
4974343 2349294 2349294 defendant Goddesday Nicholas husbandman 595165 595165 Goddesday, Nicholas, of Brenchesle, husbandman 0
4974344 2349294 2349294 defendant Rodmerygge Thomas husbandman 595165 595165 Rodmerygge, Thomas, of Brenchesle, husbandman 1
4976075 2349805 2349805 defendant Appulby William husbandman 595165 595165 Appulby, William, of Brenchesle, husbandman 0
4990202 2353976 2353976 defendant Appylby Richard yeoman 595165 595165 Appylby, Richard, of Brenchesle, yeoman 0
4990205 2353977 2353977 defendant Appylby William yeoman 595165 595165 Appylby, William, of Brenchesle, yeoman 0
5016544 2361734 2361734 plaintiff Burre John, senior butcher 595165 595165 Burre, John, senior, of Brenchesle, butcher 0
5016546 2361734 2361734 defendant Newman William, junior smith 595165 595165 Newman, William, junior, of Brenchesle, smith 1
5016547 2361734 2361734 defendant Benge William husbandman 595165 595165 Benge, William, of Brenchesle, husbandman 2
5020083 2362761 2362761 defendant Martyn John smith 595165 595165 Martyn, John, of Brenchesle, smith 0
5027527 2364929 2364929 plaintiff Martyn John, senior   595165 595165 Martyn, John, senior, of Brenchesle 0
5029543 2365510 2365510 defendant Maycote John husbandman 595165 595165 Maycote, John, of Brenchesle, husbandman 0
5036762 2367626 2367626 defendant Maycote John tailor 595165 595165 Maycote, John, of Brenchesle, tailor 0
5055910 2373335 2373335 defendant Halle Richard husbandman 595165 595165 Halle, Richard, of Brenchesle, husbandman 1
5086680 2382495 2382495 defendant Catte John gent 595165 595165 Catte, John, of Brenchesle, gent 0
5094093 2384673 2384673 defendant Bocher John butcher 595165 595165 Bocher, John, of Brenchesle, butcher 2
5094094 2384673 2384673 defendant Grangeman John smith 595165 595165 Grangeman, John, of Brenchesle, smith 3
5098731 2386058 2386058 defendant Newman William husbandman 595165 595165 Newman, William, of Brenchesle, husbandman 1
5119925 2392263 2392263 defendant Kyrvyll John scrivener 595165 595165 Kyrvyll, John, of Brenchesle, scrivener 0
5131016 2395556 2395556 defendant Clement John husbandman 595165 595165 Clement, John, of Brenchesle, husbandman 1
5133770 2396368 2396368 defendant Wodeman William husbandman 595165 595165 Wodeman, William, of Brenchesle, husbandman 3
5150520 2401290 2401290 defendant Clement John husbandman 595165 595165 Clement, John, of Brenchesle, husbandman 1
5153610 2402207 2402207 defendant Neweman William husbandman 595165 595165 Neweman, William, of Brenchesle, husbandman 2
5153942 2402311 2402311 defendant Longe Robert   595165 595165 Longe, Robert, of Brenchesle, nail maker 3
5169025 2406672 2406672 defendant Clement John husbandman 595165 595165 Clement, John, of Brenchesle, husbandman 1
5171108 2407272 2407272 defendant Longe Robert   595165 595165 Longe, Robert, of Brenchesle, nail maker 3
5183398 2410884 2410884 defendant Tebbe Thomas yeoman 595165 595165 Tebbe, Thomas, of Brenchesle, yeoman 0
5217944 2420983 2420983 defendant Pocok John husbandman 595165 595165 Pocok, John, of Brenchesle, husbandman 0
5226409 2423388 2423388 defendant Tebbe Thomas gent 595165 595165 Tebbe, Thomas, of Brenchesle, gent 4
5233977 2425527 2425527 defendant Tebbe Thomas yeoman 595165 595165 Tebbe, Thomas, of Brenchesle, yeoman 0
5233978 2425527 2425527 defendant Tebbe John yeoman 595165 595165 Tebbe, John, of Brenchesle, yeoman 1
5274314 2437569 2437569 defendant Tebbe Thomas yeoman 595165 595165 Tebbe, Thomas, of Brenchesle, yeoman 0
5276111 2438088 2438088 defendant Tebbe Thomas yeoman 595165 595165 (Tebbe, Thomas, of Brenchesle, yeoman 1
5292375 2442769 2442769 defendant Tebbe Thomas yeoman 595165 595165 Tebbe, Thomas, of Brenchesle, yeoman 0
5294513 2443372 2443372 defendant Burre John, junior laborer 595165 595165 Burre, John, junior, of Brenchesle, laborer 0
5308104 2447449 2447449 defendant Tebbe Thomas yeoman 595165 595165 Tebbe, Thomas, of Brenchesle, yeoman 0
5309577 2447902 2447902 defendant Crotynden William husbandman 595165 595165 Crotynden, William, of Brenchesle, husbandman 0
5318998 2450773 2450773 defendant Crotynden William husbandman 595165 595165 Crotynden, William, of Brenchesle, husbandman 2
5321457 2451509 2451509 defendant Fyssher William carpenter 595165 595165 Fyssher, William, of Brenchesle, carpenter 1
5324886 2452518 2452518 defendant Tebbe Thomas yeoman 595165 595165 Tebbe, Thomas, of Brenchesle, yeoman 0
5340479 2457223 2457223 defendant Gold Robert cordwainer 595165 595165 Gold, Robert, of Brenchesle, cordwainer 0
5374211 2467534 2467534 defendant Dwoener James butcher 595165 595165 Dwoener, James, of Brenchesle, butcher 2
5375831 2468034 2468034 defendant Burre John husbandman 595165 595165 Burre, John, of Brenchesle, husbandman 2
5375834 2468035 2468035 defendant Crouche Thomas smith 595165 595165 Crouche, Thomas, of Brenchesle, smith 0
5391397 2472617 2472617 defendant Penyale Robert husbandman 595165 595165 Penyale, Robert, of Brenchesle, husbandman 0
5402813 2475881 2475881 defendant Crouche Thomas smith 595165 595165 Crouche, Thomas, of Brenchesle, smith 2
5404413 2476334 2476334 defendant Penyale Robert husbandman 595165 595165 Penyale, Robert, of Brenchesle, husbandman 0
5409747 2477892 2477892 defendant Penyale Thomas laborer 595165 595165 Penyale, Thomas, of Brenchesle, laborer 1
5415753 2479650 2479650 defendant Crouche Thomas smith 595165 595165 Crouche, Thomas, of Brenchesle, smith 2
5417527 2480164 2480164 defendant Penyale Robert husbandman 595165 595165 Penyale, Robert, of Brenchesle, husbandman 0
5421665 2481416 2481416 defendant Dowener James husbandman 595165 595165 Dowener, James, of Brenchesle, husbandman 0
5422660 2481729 2481729 defendant Downer James butcher 595165 595165 Downer, James, of Brenchesle, butcher 0
5422661 2481729 2481729 defendant Downer William laborer 595165 595165 Downer, William, of Brenchesle, laborer 1
5425266 2482529 2482529 defendant Fyssher William (legal representative) 595165 595165 Fyssher, William, of Brenchesle, husbandman, executors of 1
5432210 2484602 2484602 defendant Tronche Thomas smith 595165 595165 Tronche, Thomas, of Brenchesle, smith 1
5443726 2488046 2488046 defendant Fyssher William (legal representative) 595165 595165 Fyssher, William, of Brenchesle, husbandman, executors of 0

Next page

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