names

121 rows where place_id = 596250

✎ 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
3623863 1874995 1874995 defendant Toker William yeoman 596250 596250 Toker, William, of Fordyngton, yeoman 0
3623864 1874995 1874995 defendant Croweston Thomas husbandman 596250 596250 Croweston, Thomas, of Fordyngton, husbandman 1
3623865 1874995 1874995 defendant Floyd Robert yeoman 596250 596250 Floyd, Robert, of Fordyngton, yeoman 2
3623866 1874995 1874995 defendant Gybbon Roger husbandman 596250 596250 Gybbon, Roger, of Fordyngton, husbandman 3
3623867 1874995 1874995 defendant Cosyn Philip husbandman 596250 596250 Cosyn, Philip, of Fordyngton, husbandman 4
3623868 1874995 1874995 defendant Cosyn Henry husbandman 596250 596250 Cosyn, Henry, of Fordyngton, husbandman 5
3623869 1874995 1874995 defendant Baron John husbandman 596250 596250 Baron, John, of Fordyngton, husbandman 6
3623870 1874995 1874995 defendant Wyndesore Robert husbandman 596250 596250 Wyndesore, Robert, of Fordyngton, husbandman 7
3623871 1874995 1874995 defendant White Thomas husbandman 596250 596250 White, Thomas, of Fordyngton, husbandman 8
3623872 1874995 1874995 defendant Chyppe John husbandman 596250 596250 Chyppe, John, of Fordyngton, husbandman 9
3623873 1874995 1874995 defendant Chyppe Thomas husbandman 596250 596250 Chyppe, Thomas, of Fordyngton, husbandman 10
3623874 1874995 1874995 defendant Wodecok Alan husbandman 596250 596250 Wodecok, Alan, of Fordyngton, husbandman 11
3623875 1874995 1874995 defendant Clerk John husbandman 596250 596250 Clerk, John, of Fordyngton, husbandman 12
3623876 1874995 1874995 defendant Bunne Robert husbandman 596250 596250 Bunne, Robert, of Fordyngton, husbandman 13
3624104 1875065 1875065 defendant Nicoll John husbandman 596250 596250 Nicoll, John, of Fordyngton, husbandman 0
3644852 1908798 1908798 defendant Baron John husbandman 596250 596250 Baron, John, of Fordyngton, husbandman 0
3711214 1929811 1929811 defendant Cosand William husbandman 596250 596250 Cosand, William, of Fordyngton, husbandman 1
3711217 1929812 1929812 defendant Cosand William husbandman 596250 596250 Cosand, William, of Fordyngton, husbandman 1
3725876 1934368 1934368 defendant Cosyn William yeoman 596250 596250 Cosyn, William, of Fordyngton, yeoman 0
3812390 1961767 1961767 defendant Cosyn William husbandman 596250 596250 Cosyn, William, of Fordyngton, husbandman 0
3812391 1961767 1961767 defendant Cosyn Richard husbandman 596250 596250 Cosyn, Richard, of Fordyngton, husbandman 1
3812392 1961767 1961767 defendant Hutton William husbandman 596250 596250 Hutton, William, of Fordyngton, husbandman 2
3961451 2011099 2011099 defendant Wylles Ralph husbandman 596250 596250 Wylles, Ralph, of Fordyngton, husbandman 0
3970938 2014395 2014395 plaintiff Downton William yeoman 596250 596250 Downton, William, of Fordyngton, yeoman 0
3970943 2014396 2014396 plaintiff Downton William yeoman 596250 596250 Downton, William, of Fordyngton, yeoman 0
4023361 2033065 2033065 plaintiff Barnes Robert husbandman 596250 596250 Barnes, Robert, of Fordyngton, husbandman 0
4023364 2033066 2033066 plaintiff Barnes Robert husbandman 596250 596250 Barnes, Robert, of Fordyngton, husbandman 0
4119258 2067181 2067181 defendant Games or Gaines Thomas husbandman 596250 596250 Games or Gaines, Thomas, of Fordyngton, husbandman 2
4126583 2069791 2069791 defendant Butt William yeoman 596250 596250 Butt, William, of Fordyngton, yeoman 2
4234949 2107774 2107774 defendant Wyllyams John husbandman 596250 596250 Wyllyams, John, of Fordyngton, husbandman 0
4334670 2141865 2141865 defendant Reeves Thomas gent 596250 596250 Reeves, Thomas, of Fordyngton, gent 1
4358329 2150147 2150147 defendant Adyn Thomas yeoman 596250 596250 Adyn, Thomas, of Fordyngton, yeoman 0
4448622 2184499 2184499 defendant Goyere John   596250 596250 Goyere, John, of Fordyngton 1
4448977 2184621 2184621 plaintiff Gay William   596250 596250 Gay, William, of Fordyngton 0
4455900 2186862 2186862 defendant Mascall William   596250 596250 Mascall, William, of Fordyngton 0
4471589 2191777 2191777 defendant Hore John   596250 596250 Hore, John, of Fordyngton, vicar 0
4476667 2193363 2193363 defendant Eyre John   596250 596250 Eyre, John, of Fordyngton 1
4476668 2193363 2193363 defendant Corne Robert   596250 596250 Corne, Robert, of Fordyngton 2
4495021 2199133 2199133 defendant Cayser John (legal representative) 596250 596250 Cayser, John, of Fordyngton, executors of 0
4504293 2201896 2201896 defendant Webbe Henry   596250 596250 Webbe, Henry, of Fordyngton 4
4504294 2201896 2201896 defendant Knoll John   596250 596250 Knoll, John, of Fordyngton 5
4504296 2201896 2201896 defendant Wolrygg Robert   596250 596250 Wolrygg, Robert, of Fordyngton 7
4504299 2201896 2201896 defendant Seman John   596250 596250 Seman, John, of Fordyngton 10
4556117 2217856 2217856 defendant Blount John   596250 596250 Blount, John, of Fordyngton 1
4556123 2217857 2217857 defendant Blount John   596250 596250 Blount, John, of Fordyngton 1
4566563 2221112 2221112 defendant Smyth Henry   596250 596250 Smyth, Henry, of Fordyngton 0
4575982 2223983 2223983 defendant Jurdan John, sen   596250 596250 Jurdan, John, sen, of Fordyngton 0
4587731 2227569 2227569 defendant Wyght William   596250 596250 Wyght, William, of Fordyngton 1
4597165 2230354 2230354 defendant Drynkewater John   596250 596250 Drynkewater, John, of Fordyngton 0
4627075 2239415 2239415 defendant Wotton William   596250 596250 Wotton, William, of Fordyngton 0
4644316 2244426 2244426 plaintiff Loym Thomas   596250 596250 Loym, Thomas, of Fordyngton 0
4644318 2244426 2244426 defendant Tetebol William   596250 596250 Tetebol, William, of Fordyngton 0
4649397 2245873 2245873 defendant Chyldcombe John   596250 596250 Chyldcombe, John, of Fordyngton 8
4667547 2255568 2255568 defendant Prious Henry   596250 596250 Prious, Henry, of Fordyngton, millward 3
4681913 2259959 2259959 defendant Seeman Henry husbandman 596250 596250 Seeman, Henry, of Fordyngton, husbandman 4
4687856 2261766 2261766 defendant Tolet Thomas carter 596250 596250 Tolet, Thomas, of Fordyngton, carter 0
4698378 2264971 2264971 defendant Pounchardon John smith 596250 596250 Pounchardon, John, of Fordyngton, smith 0
4718073 2270994 2270994 defendant Pyrys Nicholas husbandman 596250 596250 Pyrys, Nicholas, of Fordyngton, husbandman 0
4720852 2271853 2271853 defendant Batrok Roger husbandman 596250 596250 Batrok, Roger, of Fordyngton, husbandman 0
4740158 2277638 2277638 defendant Ferchyng William husbandman 596250 596250 Ferchyng, William, of Fordyngton, husbandman 3
4773850 2287801 2287801 defendant Cosyn Thomas tailor 596250 596250 Cosyn, Thomas, of Fordyngton, tailor 0
4792643 2293788 2293788 defendant Rogger John yeoman 596250 596250 Rogger, John, of Fordyngton, yeoman 1
4822259 2303041 2303041 defendant Chyppe William milner 596250 596250 Chyppe, William, of Fordyngton, milner 0
4847342 2310672 2310672 defendant Pyrys John, sen dyer 596250 596250 Pyrys, John, sen, of Fordyngton, dyer 2
4871559 2318076 2318076 defendant Slowe Richard husbandman 596250 596250 Slowe, Richard, of Fordyngton, husbandman 0
4871560 2318076 2318076 defendant Crooker Thomas husbandman 596250 596250 Crooker, Thomas, of Fordyngton, husbandman 1
5054869 2373023 2373023 defendant Croke John butcher 596250 596250 Croke, John, of Fordyngton, butcher 0
5139932 2398161 2398161 defendant Parker John husbandman 596250 596250 Parker, John, of Fordyngton, husbandman 0
5139933 2398161 2398161 defendant Crokker Thomas husbandman 596250 596250 Crokker, Thomas, of Fordyngton, husbandman 1
5139934 2398161 2398161 defendant Cosyn Peter husbandman 596250 596250 Cosyn, Peter, of Fordyngton, husbandman 2
5139935 2398161 2398161 defendant Tolde William husbandman 596250 596250 Tolde, William, of Fordyngton, husbandman 3
5139936 2398161 2398161 defendant Sargeaunt John husbandman 596250 596250 Sargeaunt, John, of Fordyngton, husbandman 4
5160948 2404309 2404309 defendant Tolet William husbandman 596250 596250 Tolet, William, of Fordyngton, husbandman 0
5175562 2408538 2408538 defendant Tolet William husbandman 596250 596250 Tolet, William, of Fordyngton, husbandman 0
5175563 2408538 2408538 defendant Hardy Walter husbandman 596250 596250 Hardy, Walter, of Fordyngton, husbandman 1
5175564 2408538 2408538 defendant Jolyffe John husbandman 596250 596250 Jolyffe, John, of Fordyngton, husbandman 2
5175565 2408538 2408538 defendant Gebon Bartholomew husbandman 596250 596250 Gebon, Bartholomew, of Fordyngton, husbandman 3
5175566 2408538 2408538 defendant Crokker William husbandman 596250 596250 Crokker, William, of Fordyngton, husbandman 4
5196867 2414834 2414834 defendant Tolet William husbandman 596250 596250 Tolet, William, of Fordyngton, husbandman 0
5196868 2414834 2414834 defendant Hardy Walter husbandman 596250 596250 Hardy, Walter, of Fordyngton, husbandman 1
5196869 2414834 2414834 defendant Jolyffe John husbandman 596250 596250 Jolyffe, John, of Fordyngton, husbandman 2
5196870 2414834 2414834 defendant Gebon Bartholomew husbandman 596250 596250 Gebon, Bartholomew, of Fordyngton, husbandman 3
5196871 2414834 2414834 defendant Crokker William husbandman 596250 596250 Crokker, William, of Fordyngton, husbandman 4
5209855 2418615 2418615 defendant Tolet William husbandman 596250 596250 Tolet, William, of Fordyngton, husbandman 0
5209856 2418615 2418615 defendant Hardy Walter husbandman 596250 596250 Hardy, Walter, of Fordyngton, husbandman 1
5209857 2418615 2418615 defendant Jolyffe Henry husbandman 596250 596250 Jolyffe, Henry, of Fordyngton, husbandman 2
5209858 2418615 2418615 defendant Gebon Stephen husbandman 596250 596250 Gebon, Stephen, of Fordyngton, husbandman 3
5209859 2418615 2418615 defendant Crokker William husbandman 596250 596250 Crokker, William, of Fordyngton, husbandman 4
5215498 2420256 2420256 defendant Pynge Henry husbandman 596250 596250 Pynge, Henry, of Fordyngton, husbandman 0
5215500 2420257 2420257 defendant Pynge Henry husbandman 596250 596250 Pynge, Henry, of Fordyngton, husbandman 0
5295308 2443624 2443624 defendant Tedbolt Robert husbsndman 596250 596250 Tedbolt, Robert, of Fordyngton, husbsndman 0
5295309 2443624 2443624 defendant Bengevyle William husbandman 596250 596250 Bengevyle, William, of Fordyngton, husbandman 1
5295311 2443624 2443624 defendant Taillour William husbandman 596250 596250 Taillour, William, of Fordyngton, husbandman 3
5306503 2446935 2446935 defendant Pyng Henry husbandman 596250 596250 Pyng, Henry, of Fordyngton, husbandman 0
5323633 2452153 2452153 defendant Shoter William yeoman 596250 596250 Shoter, William, of Fordyngton, yeoman 1
5339711 2456995 2456995 defendant Pyng Henry husbandman 596250 596250 Pyng, Henry, of Fordyngton, husbandman 0
5352815 2460967 2460967 defendant Bedford Edward   596250 596250 Bedford, Edward, of Fordyngton, groom 1
5416923 2479976 2479976 defendant Gybon William   596250 596250 Gybon, William, of Fordyngton 0
5416928 2479977 2479977 defendant Gebon William   596250 596250 Gebon, William, of Fordyngton 1
5433983 2485118 2485118 defendant Gybon William   596250 596250 Gybon, William, of Fordyngton, mason 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);